re: why GO has to be on its own line.

From the BOL help screen....

GO is not a Transact-SQL statement; it is a command recognized by the sqlcmd and osql utilities...

The category for this QOD is a bit misleading. It's not strictly a Transact-SQL feature that's being highlighted here. T-SQL syntax takes care of interpreting the two single-quote...

I believe the "Expert" book you bought is really a follow-on to the "Professional". As such, you may get the feeling you're missing something when using it.

Another,...

Hector,

I'm curious. Why do you want to use a script to copy files rather than use the built-in file tasks that come with SSIS?

To add weight to Hugo's argument, here's a bit from BOL that seems relevant:

Caution:

If there are multiple assignment clauses in a single SELECT statement, SQL Server does not...

My preference in a case like this would be to use SSIS File tasks to copy the files. I'd encourage you to remember that a lot of functions now...

Jasmine and John Hansen,

I'm with Jeff on this one: I'd like to see the specifics of solution that doesn't add any new rows at all. It's an attractive idea to...

What are the comparitive advantages of having rows refer to other rows in the same table rather than setting up an associative table? My instinct (as an application programmer...

Posts from Anders and webrunner point to how this script uses a new feature in SSMS not available in SQL 2000 QM. The Go 3syntax to run something multiple...

I thank David Dresser for a good job parsing this out. I tried making it slightly more coder-friendly by renaming the proc "JO" and the variable "KO". I...

Tomm,

Does your solution depend on the temp table being read back in the same order in which it was loaded? That "gotcha" would have to be avoided at least by...

The download link is part way down the page below the properties chart. Find "Version 1.2.6.100".

File Watcher is indeed a custom task from Konesans, Inc., downloadable at http://www.sqlis.com/23.aspx.

Tao,

I think the difference is just in the wording of the error message. My SQL 2000 instance gives: Msg 245, Level 16, State 1, Line 1

Syntax error converting the...

Andy DBA,

Adding the clustered index to my TALLY table did the trick. As I suspected it would, the query returns instantly now without bothering with a range filter. Shame...