Viewing 15 posts - 1,351 through 1,365 (of 7,636 total)
Grant Fritchey (11/9/2009)
...Best thing was showing up late to Buck Woody's session, in a kilt. I sat up front... Sharon Stone was mentioned... 'nough said.
BWAHAAHA!!! OMGROFL! :w00t:
November 25, 2009 at 4:56 pm
Jeff Moden (11/3/2009)
malli.chitturi (11/2/2009)
November 25, 2009 at 3:55 pm
Alvin Ramard (11/2/2009)
Lynn Pettis (11/2/2009)
Thought this one was interesting. Basically, I found this neat code and I would like someone else to port it to SQL Server for me.
I'm...
November 25, 2009 at 3:38 pm
Do you use DB Mirroring or DM Mail on that instance?
November 4, 2009 at 6:05 pm
JLSSCH (11/2/2009)
One final update to my solution. Using CTE's, the output query is much easier to understand.
CTE's also are not avaialble in SQL Server 2000.
November 3, 2009 at 9:54 pm
JLSSCH (11/2/2009)
Thanks for your comments. The following modified solution works when you use the row_number() function to number the rows in an output query.
ROW_NUMBER() makes it easy. However,...
November 3, 2009 at 9:52 pm
Wanderlei Santos (10/30/2009)
November 2, 2009 at 6:52 pm
BlackHawk-17 (10/30/2009)
It was fun to watch the problem solving unfold and the answer develop.
These are the articles that keep me coming back.
Thanks a ton...
November 2, 2009 at 6:46 pm
Tom Garth (10/30/2009)
I've used the Temp In-Place method in the past. Sometimes to fix my own...
November 2, 2009 at 6:45 pm
sjimmo (10/30/2009)
November 2, 2009 at 6:42 pm
arms.dan (10/30/2009)
November 2, 2009 at 6:40 pm
jghali (10/30/2009)
My personal opinion the...
November 2, 2009 at 6:35 pm
skjoldtc (10/30/2009)
November 2, 2009 at 6:30 pm
Stephen.Richardson (10/30/2009)
...-- Step 1 Get list of only DUPLICATE rows
INSERT INTO xSource (Name, Age, Sex)
SELECT '~'+Name, Age, Sex FROM xSource GROUP BY Name, Age, Sex Having COUNT(*) > 1
The problem...
November 2, 2009 at 6:29 pm
honza.mf (10/30/2009)
Phil Factor (8/5/2008)
November 2, 2009 at 6:26 pm
Viewing 15 posts - 1,351 through 1,365 (of 7,636 total)