Thank you! I was wondering if there was a way to do this without a totals table. Also, thank you for the link about the Tally table. I have never...

Just to let you know how we got the databases back online.

Shutting down the server and the array and bringing them back up in the proper order helped some...

I don't have the rights to restart the services, but I will have them do that. They are going to shutdown the server and the array and bring them back...

When I try to delete the database I get an error that the file does not exist. The database name is showing up in the drop down list under "Databases"...

Thank you. I ran the query and replaced the table name with the actual table I was working with, but my output only says (0 row(s) affected)

So it ran without...

I've had issues with the import. When it expects a decimal and the word "NULL" is there, the import completely stops. I was hoping there was a way to change...

Thank you very much Terry, that worked on my sample data so I'm sure it will work on the rest. I do not know how the

LEFT OUTER JOIN TestID td...

Lowell (7/8/2009)

---

i think your issue is the NOT EXISTS...

whenever you do that, You have to test for nulls, as that will screw up the EXISTS

WHERE NOT EXISTS

(SELECT OldLicenseNumber...

I was doing something a little different. I had a column of dates that needed to be put in the MM/DD/YYYY format so it could be imported into SAS.

Most...

I will try that.

Thank you.

Thank you for the help.

I had originally tried it at server, database, and table level but the tasks options would not show up. I went back through the control...

Thanks David

Thanks for the advice!

A cube reminds me of a pivot table in Excel.

The spam I get now has news headlines and asks if you want to unsubscribe.

The funniest header for spam I have ever gotten said "the bodyguards are now surrounding Angelina's...