mlandry (12/3/2008)

---

Jeff,

Whoa, using SQL to do cross-tabs really is "old school" (circa mid-90's or before.) It just wasn't designed for this.

Do yourself a BIG favor and try Analysis Services....

Thanks for the feedback and absolutely! 🙂

Thanks for the great feedback Anirban. Great to know that folks get things out of these articles. 🙂

Thanks...

Is this what you want?

--===== Declare local files

--Jeff Moden

DECLARE @DBID INT

DECLARE @DBName VARCHAR(30)

DECLARE @Text ...

Why? What's the goal or business rule other than someone said they wanted it?

John Barry (12/2/2008)

---

Jeff,

Thanks - I have used that syntax as well - it's cool. And I agree if I move the Nextval outside the transaction it would solve the...

One more thing... you're updating the same columns that you have in your criteria. Sometimes, and it's again unpredictable, that will cause a recompile for every row updated. ...

P.S. You may want to stop that single Update you're running right now. It may take several hours to rollback or it might rollback quicker. But even...

To add to what Lynn stated.... there are two reasons you need to break up such a large update... the first is the LOG file. Even with the SIMPLE...

That's not really a DateTime datatype you asked for or it would have a date with it like this...

DECLARE @Time CHAR(4)

SET @Time = '1330'

SELECT CAST(STUFF(@Time,3,0,':')...

John Barry (12/2/2008)

---

I do not want to use an identity field in the tables to get a sequence number. This would present many additional challenges that are worse than...

Heh... if you need to borrow some porkchops... 😀

Heh... "Must look eye..." 😛

SET STATISTICS TIME ON

SELECT ID,

...

Steps 1 through 3 can can be very easily accomplished... open the file in Excel. Step 4 is a simple "Save As". You don't need to even go near...