Jeff Moden (11/29/2012)

---

peter-757102 (11/29/2012)

---

I haven't read the article properly and just scanned it to see what it is about and if it is interesting.

But one thing I noticed quickly was...

Jeff Moden (11/29/2012)

---

Peter H (11/29/2012)

---

My version of SQL (2005) does not seem to handle the "VALUES" in

SELECT TOP(DATALENGTH(@List))

n = ROW_NUMBER() OVER(ORDER BY (SELECT NULL))

FROM

...

Irozenberg 1347 (11/29/2012)

---

Why we have to be inventive and create such acrobatic solution in a first place? Just to compensate for bad design and implementation decisions.

If original DB developers...

MarbryHardin (11/29/2012)

---

It does seem like that would be one instance where a CLR udf would do very well, especially to support more complex examples. That's precisely the type of...

Thanks Mike! Glad you stopped by.

Sorry but in this article I...

Alas I am not the man to ask.

I failed to mention...

Interesting...

Didn't know those tables were deprecated.

Welcome to the world of SSC although I see you have around 40 posts, so better late than never.

Jeff Moden has a couple of good articles on setting up randomized...

Jason-299789 (11/22/2012)

---

Thanks Dwain, I've read that article (+1 BTW), I did say I wasnt sure about the performance on a large dataset, and it was just another Option to consider.

Looking...

Jason and MickyT - You may want to take a look at this article: http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/. It compares UNPIVOT vs. the CROSS APPLY VALUES approach from a performance perspective. ...

Jeff Moden (11/21/2012)

---

Not only would it be cool to be able to name object names with a variable but it would also be cool if we could use variables and...

Jeff Moden (11/21/2012)

---

I haven't fired...

Possibly Sean may have been planning to suggest something like this:

SELECT COUNT(*)

FROM #UserMain a

INNER JOIN #Professional b ON a.UserNumber = b.UserNumber

WHERE Base_State = 'MA' AND User_status = 'C'

Can...