Hey Flo! I have to ask... how did you get that picture of me first thing in the morning? 😛

Another thing to consider is rebuilding indexes, especially wide indexes, will use quite a bit of the Log file and then release it (didn't say shrink). That's another good...

I've gotta ask, Ed... why do you need this type of denormalize output? What is that output going to be used on? I'm asking because I like to...

Mohit (3/5/2009)

---

That trigger is def a good idea :). Another option you have is since the stored procedure is required in each database; why not add it to the...

florian.reischl (3/5/2009)

---

BEGIN TRANSACTION

UPDATE #id_tab SET next_id = next_id + 1 WHERE table_name = @table_name

SELECT @id = next_id...

Chris Morris (3/5/2009)

---

Jeff Moden (3/5/2009)

---

Heh... I absolutely love...

Bob Hovious (3/5/2009)

---

Thanks Jeff... I take more pride in a compliment like that from you than I would from an MVP.... although unfortunately it doesn't look as good on a...

That's why I'll frequently use a programmable Tally CTE. I've got that bad boy written up in the Tally table article...

Thanks for the test code... I'll try to find...

I absolutely agree... right now, there's a "Rate Topic" button in the upper right quadrant of the screen... if you look at the topics in any given week, you might...

Heh... I absolutely love it... let me officially...

Heh... well said, Bob... my opinion is, "We don' need no stinkin' ratin' system." RTFP instead. 😀

Heh... Yeah... especially where I'm concerned... everyone knows I do nothing but write a couple "hunert"...

Perfect... thanks... here's how to do it...

;WITH

cteTableA AS

(

SELECT ROW_NUMBER() OVER (ORDER BY Phone_No) AS RowNumber,

Phone_No

FROM dbo.TableA

...

SQL_Quest (3/5/2009)

---

Jeff Moden (3/4/2009)

---

... and, no... sorry... I don't know how to write a script to do it for 300 different tables auto-magically... no way to know which columns make...

Punketal (3/5/2009)

---

It was mostly to do with U/I presentational stuff, showing how many had graduated from the school it´s first and last years.

I solved it with some VB programming so...