You're welcome.

Execution plans costs and percentages are misleading. They are quite often just plain wrong. Personally, I wish MS would get rid of them, because they cause more problems...

Given all the actions you're trying to do, SSIS might be a good solution. It can import data into SQL tables, run command line/exe actions, etc. Take a...

Because DateTime data type is accurate to 1/300th of a second, not 1/1000th of a second. The definition of the data type in Books Online (or MSDN) explains this...

I'd probably still be doing sales, marketing, and/or management, since those are the roles that got me into being a DBA in the first place.

Jeff:

Please make sure you don't ever accidentally/intentionally go to http://www.sqlservercentral.com/Forums/Topic782099-338-2.aspx

(Sorry, Paul, I couldn't resist!)

Are you just trying to find the difference between a date and the date in the next row?

If so, try this:

;with Dates (Row, Date, Days) as

(select...

Since you can use Exec with varchar(max), you're not really limited on this, but the string-build can get a little complex, especially if you have nested single-quotes.

Exiting the SQL context...

I get a Page Not Found error from that address.

I don't see the execution plans.

I'd say it's a problem that should be fixed, but it's a minor one.

Dynamic SQL is the usual tool for this kind of thing. You create a varchar variable, populate it with the commands you want by concatenating the database name into...

This link provides the full syntax for declaring a cursor:...

Failure to report a known crime is conspiracy, which can actually be worse than committing the crime in some cases. In most cases, conspiracy to commit a misdemeanor is...

Yes, I read the paper. His use of sa was just examples. As I mentioned, if someone has the sa password for your server, SQL injection is the...