Viewing 15 posts - 2,146 through 2,160 (of 2,443 total)
First of all, congratulations to Jonathan Kehayias for the 1600th post!:D
Secondly, I digress, but I was reading through some of your efforts with this guy (http://www.sqlservercentral.com/Forums/Topic658811-338-1.aspx) and I almost soiled...
---------------------------------------------------------
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."
February 20, 2009 at 6:50 am
Lynn Pettis (2/19/2009)
---------------------------------------------------------
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."
February 19, 2009 at 8:02 am
bkDBA (2/18/2009)
Jeff Moden (2/14/2009)
---------------------------------------------------------
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."
February 19, 2009 at 7:55 am
In addition to Sergiy's recommendation, check this article out, and the discussion that follows. I particularly like JimFive's suggestion near the very end.
http://www.sqlservercentral.com/articles/T-SQL/65423/
---------------------------------------------------------
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."
February 19, 2009 at 7:36 am
I had two thoughts here, neither constructive.
1. Semantic Web
2. Eagle Eye
---------------------------------------------------------
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."
February 19, 2009 at 7:22 am
Jeff, I just made myself feel a whole lot better today, since I was helping someone work through a Pivot, and ended up doing much of what you demonstrate here,...
---------------------------------------------------------
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."
February 18, 2009 at 3:27 pm
JenG (2/18/2009)
---------------------------------------------------------
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."
February 18, 2009 at 6:55 am
blandry (2/18/2009)
"There was a mismatch of expectations in the presentation of a new product..."
"The CEO of a 3,000+ person company had to approve a $1,500-2,000...
---------------------------------------------------------
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."
February 18, 2009 at 6:31 am
RBarryYoung (2/17/2009)
kevin (2/17/2009)
---------------------------------------------------------
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."
February 17, 2009 at 1:03 pm
GilaMonster (2/17/2009)
louisevb (2/17/2009)
Oops it is Gail, sorry i am half asleep morning 😀😀
Either works, I don't mind.
Qui'Gail?
Gila'gon?
---------------------------------------------------------
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."
February 17, 2009 at 7:23 am
kevin (2/17/2009)
---------------------------------------------------------
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."
February 17, 2009 at 7:17 am
Mike Levan (2/15/2009)
can i write your second query like this...SELECT a.col1,a.col2
FROM tableA a
WHERE a.col1 IN (SELECT 1 FROM tableB b inner join tableA a
ON a.col1=b.col1
and a.col1=b.col1)
Note that aside from Grant's...
---------------------------------------------------------
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."
February 17, 2009 at 6:38 am
RBarryYoung, am I missing something here? the function name is LatLonDistance(), but the tests use calculateDistance()?
Is there a missing piece to this, or is it just a naming...
---------------------------------------------------------
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."
February 17, 2009 at 6:21 am
GSquared (2/12/2009)
Bert (2/12/2009)
GSquared (2/12/2009)
---------------------------------------------------------
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."
February 12, 2009 at 9:08 am
daniel.thompson (2/12/2009)
---------------------------------------------------------
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."
February 12, 2009 at 8:53 am
Viewing 15 posts - 2,146 through 2,160 (of 2,443 total)