EXEC @sql will try execute a named stored procedure where the name is stored in @sql.

EXEC (@SQL) will execute the SQL stored in the variable @sql

Did you get an "A" on the homework?

FTP to a text file... then BCP or Bulk Insert into SQL Server.  See Books Online for more info on either or both.

Lindsay,

What are the rules for the first week/first month of the year?

Considering your other post... this looks a lot like a take-home exam...

Considering your other post, this looks a lot like a take-home exam.

Yep... clever code.  Thanks.

Very hard for me to believe you can't display an estimated execution plan... even a fully read only data base let's you do an estimated execution plan in Query Analyzer......

Yep... some serious truth in that... the best accounting procedure is, of course, don't make mistakes.  The second best is don't try to roll back anything... issue a credit!

Just curious... why don't YOU just give it a try?

Oh noo, no, no.... go look at Master.dbo.sp_SpaceUsed and "steal" code from that... do it in a set based manner so that you can create a view like an Information_Schema...

Hey Micheal!  Welcome aboard!  Have seen lot's of your posts on the "other" forum... glad to see another intelligent person come on (well, except for the cursor

And, do a ...

SELECT COUNT(*)

FROM yourtablename

... to find out how many rows it's really looking at...

p.s.  Lookup QUOTENAME in Books OnLine if you need to do lot's of stuff like this...

Alot... the very first '+ is followed on the next line by a single ' which ends the string literal which is followed by CASE so SQL Server see's it...