Viewing 15 posts - 1,516 through 1,530 (of 5,590 total)
Henrico Bekker (4/13/2011)
question doesnt state that you need to SET LANGUAGE....
Look closer... (bolded emphasis mine)
Which of the following statements will complete successfully - i.e. not cause an error - in...
April 13, 2011 at 5:48 am
Ninja's_RGR'us (4/12/2011)
All I know for sure at this point is...
April 12, 2011 at 1:35 pm
Tom.Thomson (4/12/2011)
Stefan Krzywicki (4/12/2011)
I see SanDroid has started digging again...
How deep can he dig before the heat makes him stop? Or do we have a new version of the...
April 12, 2011 at 1:30 pm
Craig Farrell (4/12/2011)
WayneS (4/12/2011)
Jack Corbett (4/12/2011)
April 12, 2011 at 1:26 pm
String manipulation in windows is notoriously bad. XML is probably using the .net stringbuilder, which is supposed to be very efficient. A while back, I think Jeff compared it to...
April 12, 2011 at 11:39 am
Jack Corbett (4/12/2011)
April 12, 2011 at 11:26 am
Stefan Krzywicki (4/12/2011)
WayneS (4/12/2011)
Steve Jones - SSC Editor (4/12/2011)
Stefan Krzywicki (4/12/2011)
WayneS (4/12/2011)
Stefan Krzywicki (4/12/2011)
I see SanDroid has started digging again...Where?
Still on your QOTD. bottom of the page and then on...
April 12, 2011 at 10:34 am
Steve Jones - SSC Editor (4/12/2011)
Stefan Krzywicki (4/12/2011)
WayneS (4/12/2011)
Stefan Krzywicki (4/12/2011)
I see SanDroid has started digging again...Where?
Still on your QOTD. bottom of the page and then on the next page.
I...
April 12, 2011 at 8:40 am
Maksymilian Mulawa (4/12/2011)
April 12, 2011 at 8:01 am
Stefan Krzywicki (4/12/2011)
I see SanDroid has started digging again...
Where?
April 12, 2011 at 7:49 am
Brandie Tarvin (4/12/2011)
DECLARE OMG_NotAnotherCursor CURSOR GLOBAL_SCREAM BACKWARD_FACING
STATIC_THE_SUPERHERO PESSIMISTIC DB_LOCKDOWN
FOR
SELECT Superpower
FROM dbo.JusticeLeague
WHERE SupType = 'Lightning'
OPEN OMG_NotAnotherCursor
FETCH LAST FROM OMG_NotAnotherCursor
...
April 12, 2011 at 7:48 am
Hey Jack...
Just wanted to say that I really like your new avatar. Much better looking that what you had up previously... :-P:-D
April 11, 2011 at 8:01 pm
Jeff Moden (4/11/2011)
Craig Farrell (4/11/2011)
Ho Boy. How did you fill your PM box up quickly Jeff? :hehe:
I wore a shirt with a Gila Monster on it. 😛
That's just...
April 11, 2011 at 3:59 pm
And here's a version of the cross apply w/ row-number:
SELECT sell.*, buy.cost, buy.taxes, buy.date
FROM #SELL sell
CROSS APPLY (SELECT Vehicle, Date, Cost,...
April 11, 2011 at 12:57 pm
GilaMonster (4/11/2011)
Stefan Krzywicki (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.People complained about the lizard?
Yes, I have a bunch of PMs on the topic....
April 11, 2011 at 12:30 pm
Viewing 15 posts - 1,516 through 1,530 (of 5,590 total)