this is what is known as a cross tab query; you are converting rows to columns. you can search for cross tab or pivot to find more examples:

here's an example...

the equivilent of the First() function is SELECT TOP 1 COLUMNNAME from sometable order by COLUMNNAME ;

the TOP function can give you the top 10 like david letterman, or return...

the BULK INSERT function in SQL is the most effecient. If you know the layout of the file will always be the same, and the data rows are the differences,...

sql server agent must be started in order for jobs to execute...is it running? on a laptop, you often do not turn on that service...

if you go to Enterprise manager...

again, your timing is off: if you stop the SQl server service, you will see something like this in the events log:

17148 :SQL Server is terminating due to 'stop'...

turning statistics off is only good if you have a job to update the statistics manually. if statistics go out of date, execution plans can become outdated and have the...

I think your logic is backwards.... if the sql server is going down or, is already down/offline, you wouldn't be able to backup the databases...well...because the server must be up...

obviously there is an implied order somewhere, otherwise you would not want them in 3,1,2 order...is there a datetime field, or the order of insert (based on an identity field?)...

an FYI that you already know most likely: programatically automating excel is slow, and it is notoriously difficult to close the last excel object...so if you run task manager, it...

here's an example to show all records based on the criteria you described

SELECT SOMETABLE.* FROM SOMETABLE

INNER JOIN

(

SELECT F1,F2,F3,F4,F5,F6,F7 FROM SOMETABLE

GROUP BY F1,F2,F3,F4,F5,F6,F7

HAVING COUNT(F1) > 1 --FINDS ALL RECORDS WITH...

same here...in my case, developers were dropping and recreating databases all the time, just needed to be aware of it really; so i had to save the previous data and...

spot on analysis of some of the detriments of Oracle vs SQL Server...my shop has to support both as well.

we often copy the same identical database to SQL and Oracle...

creepy...looked in BOL for the CREATE database example, and their database is named Sales, just like you are asking:

CREATE DATABASE Sales

ON

( NAME = Sales_dat,

   FILENAME = 'c:\program files\microsoft sql...

you can also save a copy of sysdatabases to a table, and schedule a job to compare that table to the current sysdatabases to compare changes....same thing at the database...

I've always been interested in getting and programming a robot arm, but anything in the sub $500 price range are cheap, rinky dinky, have a lift limit of like 6...