Viewing 15 posts - 1,366 through 1,380 (of 2,443 total)
Very nice. Must be like voodoo, I feel ill and alien already.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 30, 2010 at 2:45 pm
CirquedeSQLeil (4/30/2010)
jcrawf02 (4/30/2010)
:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D15,000
:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D
And I was so tempted to do that myself.
I knew you were, but you were being so conscientious about just posting real Threadliness, so figured I'd take care...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 30, 2010 at 2:32 pm
:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D
15,000
:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 30, 2010 at 2:05 pm
One bottle of beer on the wall, one bottle of beeeeeerrrr,
take one down, pass it around, one bottle of beer on the wall
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 30, 2010 at 2:03 pm
Two bottles of beer on the wall, two bottles of beeeeeerrrr,
take one down, pass it around, two bottles of beer on the wall
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 30, 2010 at 2:03 pm
Right, obviously not SQL Compare. We should use Access.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 30, 2010 at 10:37 am
CirquedeSQLeil (4/30/2010)
WayneS (4/30/2010)
CirquedeSQLeil (4/30/2010)
Has anybody here ever tried setting their sa account password to contain emoticons? Or any sql logon password for that matter.
sa...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 30, 2010 at 8:38 am
JP - and when your manager asked who said what, which one of the team told him it was inappropriate, and walked out to discuss with HR?
I think a...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 30, 2010 at 8:12 am
Gotcha, thanks! Learn something new every day...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 29, 2010 at 2:18 pm
CirquedeSQLeil (4/29/2010)
Lynn Pettis (4/29/2010)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 29, 2010 at 2:10 pm
Wayne, why the isnull() and max()?
Why not just case when sp.action = 193 then 'Y' else 'N' end?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 29, 2010 at 1:53 pm
CirquedeSQLeil (4/27/2010)
Paul White NZ (4/27/2010)
Yep. I'd only start to worry if you start finding SSC notification emails stashed around the house in unlikely places.
Why find them stashed when you...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 28, 2010 at 5:30 am
Trey Staker (4/27/2010)
I always take the approach that I do with camping,
aww, golden opportunity missed.
revised edition:
"I always take the approach that I do with camping, I dig a...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 27, 2010 at 9:32 am
Found another example [/url]of someone re-posting an article in its entirety on their blog. Not a summary, not a reference to go read it, actually a copy/paste on their blog.
They...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 27, 2010 at 6:12 am
Chris Howarth-536003 (4/27/2010)
jcrawf02 (4/21/2010)
How do you replicate a LEFT JOIN using the where clause?
Since you asked (compatibility level 80 or lower):
WITH CTELeft
AS
(SELECT 1 AS ID UNION
SELECT 2UNION
SELECT 3UNION
SELECT...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 27, 2010 at 5:28 am
Viewing 15 posts - 1,366 through 1,380 (of 2,443 total)