Heh... I'll agree that the author had a naming convention problem with choosing the title of the article... 😉

I've also found that a great many "personal preferences" can really gum...

Heh... still, the best thing to do would be to give the person requesting that this be done without adding an IDENTITY column and without using an intermediate table a...

Oh, very clever... well done, Barry!

Only corrections are to remove the CASE in the final insert and to delete the compressed rows...

Other than that, very, very clever... 🙂

Tally table method in 2000 for this would require a triangular join... I believe. If you know a way to do this in 2k without using a loop but...

Jeff Moden (6/21/2008)

---

Steve Jones - Editor (6/21/2008)

---

SQL Apprentice Jeff...has a nice ring to it. Maybe we can chip in for a pointy hat for you to wear to the meetings...

rbarryyoung (6/21/2008)

---

I want to add that IMHO, the reason that the work of ths ANSI SQL has seemed so out of step with users and practioners for the last 15...

Heh... you...

Dang... I just can't beat the kids anymore... 😀

Very nice, Matt. Thanks.

Matt Miller (6/21/2008)

---

I'm looking at this now - and I'm not so sure at all about this. I don't get the same results out of Count(*) as I do...

Absolutely perfect... you actually need to use two tables... let's say you have TableA and TableB and they are identical. You have a view or a synonym pointing...

Mobasha,

To be true, there is a UID (User ID) column in the TempDB..SysObjects comapatibility view of SQL Server 2005... it's not the ID of the person that made it, though......

I don't understand why you think there's a problem... no one else has access to the Temp Table or Table Variables... why are you using a transaction on them? ...

To the best of my...

...and, if you just happend to have posted in the wrong forum and you actually have SQL Server 2005, you need to let us know that because there's a very...

sqldba (6/20/2008)

---

But in this case , the apllication is sending some strings

example

(SVDB, N, Y; SFGB, N, N; SGTE Y, S; SVHG Y,Y; SVFH, Y, Y; ........)

data set in string...