Programming SQL

Get minimum from table
I have a table TempInventory with 2 fields Id, Inventory. I would like to grab all distinct Id's and the minmum inventory for thse Id's. What is the sql query to get such data. The data looks something like this: Id Inventory 28386 32 28386 52 28386 59 283... 2 Feb 2010 17:35

Updating Bit fields over a linked server
We have been trying to implement a multi-server database solution that tracks millions of invoices. However, updating a bit data type status column across the link has proved problematic. The following update fails due to a timeout because of a full table scan of the remote table SET XACT_ABORT ON BEGIN TRAN ... 2 Feb 2010 17:35

See each of the steping through few rows to see how data gets
Thanks Plamen for your help. It worked great. Regards. "Plamen Ratchev" wrote: You can use the OUTPUT clause: INSERT INTO @test OUTPUT Inserted.machine, Inserted.plan_date, Inserted.plan_hrs SELECT machine, DATEADD(dd, @days, '20100101'), 16 FROM @machines; -- Plamen Ratchev http:... 2 Feb 2010 17:35

See each of the steping through few rows to see how data getsappe
You can use the OUTPUT clause: INSERT INTO @test OUTPUT Inserted.machine, Inserted.plan_date, Inserted.plan_hrs SELECT machine, DATEADD(dd, @days, '20100101'), 16 FROM @machines; -- Plamen Ratchev http://www.SQLStudio.com ... 2 Feb 2010 17:35

Extra row in CTE
Hi, I have a table (#qed_missing_quarters) with the following rows in it: row_num quarter_end_date 1 2002-09-30 00:00:00.000 2 2002-12-31 00:00:00.000 3 2003-03-31 00:00:00.000 4 2003-06-30 00:00:00.000 5 2003-09-30 00:00:00.000 And I have the following code as a test to traverse across the table: ;W... 2 Feb 2010 17:35

Automate Scripting of Jobs to a flat file
hI, Could anybody please point me in the direction of the best way to automate the scripting of jobs to a flat file. so far I have come u with following 1 use T-SQL in a job to iterate jobs, pull back the text and dump it to file using xp_cmdshell. 2 use a C# CLR to iterate jobs and dump them to a file. 3 ... 2 Feb 2010 17:35

Nested Count
Hi all. I have got 3 tables. GamePlayer - GameMatchId, GamePlayerName, Results GameRecord - GameMatchId, Email, GamePlayerSelection User - Id, Email, FullName, DOB i'm trying to do a 'nested count', where if GamePlayer.Results = 'Win', it will do a count and give me the results as WIN and if GamePlayer.Res... 2 Feb 2010 17:35

How to create SQL logins in FIPS compliant environment ?
Hi, our objective is to make our application FIPS compliant. One of the procedure accepts username and password as parameters and does a CREATE LOGIN call. But with FIPS, if we pass the password to the procedure in clear text format, it will be a violation. Can you suggest any other method of passing the pass... 2 Feb 2010 17:35

Consequences to setting the db compatibility level to SQL Server 2000
Frank No, it does not relate to performance, it does to the new features such as ROW_NUMBER() function that won't work "Frank Rizzo" <none(a)none.net> wrote in message news:O7CsZS8nKHA.4648(a)TK2MSFTNGP06.phx.gbl... We have a Sql Server 2005 DB. For whatever reason, the compatibility level (e.g. via sp_d... 28 Jan 2010 05:20

DataSet Tables to SQL Server database
Hi all For example: I have a DataSet with two tables and one relation between each other. Is there a direct way to publish this tables to the SQL Server even when the tables dont exists ? I know, using SqlDataAdapter, it is possible to update/insert/delete data. But for this, the table has to exists ... ... 2 Feb 2010 17:35