Lab Sql

OK this will probably be a lot of explanation for a small question, so here goes. I have a quiz sys… Read more Multiple Requests To Php Blocked By First Connection

I think I will want to use combine a model level finder with a lambda. named_scope :recent_snaps, l… Read more Trying To Create A Rails Model Scope Query For Records Since Date X, Use A Lambda?

I have a SQL query I'm running in SSMS that generates about 8 different resulting datasets (all… Read more Ssms: Automatically Save Multiple Result Sets From Same Sql Script Into Separate Tabs In Excel?

This is my table: Using this query, I am getting most sold items: SELECT [Purchased Item], SUM([Ov… Read more Sql Views, Grouping By Most Sold Items And Customers Who Purchased Most

command.CommandText = String.Format('CREATE LOGIN {0} WITH password='{1}'', loginNa… Read more How To Build A Parameterized Query Or User Escaping In This Sql Statement In C#?

By this code i can able insert the checkbox values to database. But i need add one column in phpmya… Read more How Insert The Multiple Checkbox Values Into Database Using Php

How do I convert a datetime to just a date in SSIS? I'm trying to perform an aggregate query wh… Read more How Do I Extract Just The Date From A Sql Datetime Value In Ssis?

I am trying to compare a date in SQL and create a new field to allow me to group the results by Tod… Read more Tsql - Case Date Compare

I wrote a query against a WordPress Database that selects the 10 closest restaurants, ordered by di… Read more Mysql Wordpress Query Returning A Distance Of Zero For Some Records

I'm new to IOS and this is My first crud operation on it And I named this App As BIDDatabaseApp… Read more Getting Error While Inserting Data To My Table In Database Using 'storyboard' I.e "no Visible Interface..."?

I would like to execute a stored procedure MyProc with certain input parameters for each row in the… Read more Execute Stored Procedure For Each Row In The Table In Ssis

I have table named 'acts' which has 3 columns which are indexed together: act_name, short_d… Read more Mysql Query: Match Against Using Wildcard

connecting to a mysql database from java using jdbc. declaring a query String query = … Read more Java - Mysql - Select Query Outfile - Where Is File Getting Saved

I need to know all the tables on which particular user let's say 'Abc' has any(read, wr… Read more How To Get All The Tables On Which A Particular User Has Access-db2

I'm using union all to combine the results of two select statements. I'm trying to group t… Read more Combing Results From Union All Into One Row When Some Columns Have Different Values

I am using delphi 2010, and Tim Anderson's SQLite3 wrapper - http://www.itwriting.com/blog/?pag… Read more Inserting Dates Using "a Simple Delphi Wrapper For Sqlite3"

This is my sql string from which I prepare statement: SELECT (DAYS(?) - DAYS(FROM)) * 86400 + (MIDN… Read more Db2, When Trying To Calculate Difference Between Provided And Stored Timestamp I Get An Error 'the Invocation Of Function Is Ambiquious'

I have table with Values and Date. Values in Integer and date is Integer in milliseconds from 1970&… Read more Sum Over Values By Month In Milliseconds

I have a very expensive query that creates a temporary table for reporting purposes. I am having a … Read more Expensive Query Takes Down Database Server -- Looking For Ways To Mitigate

Background I have a lot of different 'things' (a domain specific item/entity/subject) that … Read more An "entity" Specific Sequence