Viewing 15 posts - 2,041 through 2,055 (of 8,416 total)
Craig Farrell (3/14/2011)
...It's about that MAX()/CrossApply()/Row_Number() bit we were batting around about a month ago.
Was this a thread on SSC? Do you have a link?
March 15, 2011 at 4:43 am
Ian Scarlett (3/11/2011)
DBA - Does Bu**er All
Does Backups - Allegedly
March 11, 2011 at 5:11 pm
Stefan Krzywicki (3/7/2011)
March 7, 2011 at 9:49 pm
Stefan Krzywicki (3/7/2011)
Just send him money! If he gets enough he may feel guilty and decide he has to write a book.
An excellent suggestion. 🙂
I'm not going to flood The...
March 7, 2011 at 12:30 pm
Jeff Moden (3/7/2011)
March 7, 2011 at 8:39 am
Gianluca Sartori (3/7/2011)
Thanks, you're very kind. But you had the proof today! 😉
Ok so you're a n00b on Twitter 🙂
March 7, 2011 at 8:04 am
Gianluca Sartori (3/7/2011)
SQLkiwi (3/4/2011)
Exciting day - just had my first Simple Talk article published:http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
Great job, Paul! Outstanding, as usual.
Now there's a chance that a poor n00b like me can understand...
March 7, 2011 at 7:12 am
Jeff Moden (3/5/2011)
arturv (3/4/2011)
Hi guys,why dont we keep it simple?
SELECT @fruit = COALESCE(@fruit + '', '') + name
Because that's RBAR an solves only for one scalar return. Also,...
March 7, 2011 at 7:06 am
Grant Fritchey (3/6/2011)
SQLkiwi (3/4/2011)
Exciting day - just had my first Simple Talk article published:http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
Well done and congratulations!
Good article too.
Ta Grant. They published one by Celko at the same time so...
March 6, 2011 at 7:08 am
Exciting day - just had my first Simple Talk article published:
http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
March 4, 2011 at 9:35 pm
WayneS (3/4/2011)
SQLkiwi (3/4/2011)
Ok, so the first part of my parallelism article went out a couple of days earlier than I expected :blush:Link: http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
That is one fantastic article. When's the book...
March 4, 2011 at 9:25 pm
Ok, so the first part of my parallelism article went out a couple of days earlier than I expected :blush:
Link: http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
March 4, 2011 at 8:53 pm
No problem. By the way, it could also be expressed this way:
...
March 4, 2011 at 7:40 am
HowardW (3/4/2011)
March 4, 2011 at 7:34 am
If I understand the question correctly, this should work:
SELECT Invitee_ID =
CASE
...
March 4, 2011 at 6:28 am
Viewing 15 posts - 2,041 through 2,055 (of 8,416 total)