Vivien Xing (11/21/2007)

---

This is a question I was being asked during an interview a couple years ago. I think it is a pretty good open question. I keep...

Perfect...

EDIT: Actually, create a database on the new server with the same name as the database you're linking to on the old server. Create views which have the same name...

Why not just a Tally table driven split function, then?

Heh! If that's true, guess I need to give you a lawnmower...

Joe Contreras (11/20/2007)

---

Thanks for the information. I just found out that my boss is leaving the company and he's the only one that supports and buys into my design...

Heh... well said Robert and ALI...

Yeup... that's kinda the way I figure it but we're only guessing...

The bad part here is a huge opportunity was missed to help the users...

No, no... not a problem, Ramesh. And, the RowNumber Over Partition to...

Allen,

I'm not 100% sure because I don't have 2k5, but I don't believe that Ramesh's wonderfully easy to read code is going to do the trick for you because it...

Jim,

Is this in reference to the table variable function you created that calls itself?

I don't know what Celko's "Packing Join" is, but I think you're gonna need another column like a date/time or and IDENTITY column even if you were to use a...

"REVERSE" is pretty expensive performance-wise... PARSENAME still does the trick even with the modified list...

CREATE TABLE dbo.Hits (RowNum INT IDENTITY(1,1) PRIMARY KEY, Site VARCHAR(100))

INSERT INTO dbo.Hits (Site)

SELECT 'abc.support.microsoft.com' UNION ALL

SELECT...

Problem with such calcs is that you have to recalculate them over and over. Recommend you take a look at Joe Celko's post on the "Nested Set Model" instead...

I believe you've hit the nail on the head... not sure even a "by value" would help on such a recursive call...

Outstanding! Congratulations, Brandie!