How did you intend to place the results in a file? Also, can you use xp_CmdShell or not?

AT&T used to have whacky date/time codes like this so they could fit date/time in 8.3 file names.

Just a thought... If you're coming in as a replacement for these DBA's and the replacement is not voluntary, I wouldn't expect a whole lot of cooperation. In fact,...

How many rows are being output by the query? Also, are you outputing the query to the screen? If so, why?

Isn't CROSS APPLY just another name for "correlated sub-query"?

If you must use Excel for reporting, why not write a couple of SQL Server views and use "Get External Data" in Excel to interogate the views and seemingly "import"...

The Tally table cannot be used to solve ranking problems because of the inherent cross-join. You've limited the cross-join, but only with a triangular join... half as bad but...

srienstr (4/1/2008)

---

Jeff Moden (3/31/2008)

---

On the "Persists" disadvantage, I kinda of agree if the sproc is big and the Temp table is used only at the beginning. I just want...

Nicely done, Ryan.

You can if the in and out times are truly date times...

Please post some of the input data and the real table schema. Please see the URL in my...

Deprecated... another word for "we're taking another feature away". I understand that deprecated aliasing by equality and forcing AS. Too bad... aliasing by equality made for some very...

The real key is that the other folks are right... there should be a separate DB for each company. I've found that when the "higher ups" get involved, and...

Another question would be... if you're converting TEXT to VARCHAR(4000), why don't you just pass VARCHAR(4000)? In fact, why waste time... do the conversion without a UDF...

heh... looks like homework... you forgot to remove the extra brace character from the example you copied out of Books Online. 😉

Also, you say this worked and now it doesn't....

Actually, the method you've shown won't work either... the INTO is in the wrong place. 😉 As a sidebar, you really shouldn't use global temp tables... to much of...