Viewing 15 posts - 616 through 630 (of 2,443 total)
opc.three (5/24/2011)
I just recognized you from the boards jcrawf02
Which means nothing, I'm definitely not an expert, just trying to learn 😉
opc.three (5/24/2011)
---------------------------------------------------------
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."
May 24, 2011 at 9:39 am
webrunner (5/24/2011)
---------------------------------------------------------
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."
May 24, 2011 at 7:46 am
opc.three (5/24/2011)
---------------------------------------------------------
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."
May 24, 2011 at 7:22 am
opc.three (5/23/2011)
SELECT INDACCOUNTNUMBER ,
TOTALPYMTAMT ,
NETPAID ,
...
---------------------------------------------------------
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."
May 24, 2011 at 7:00 am
...Brain exploding.....can't ..think...anymore...!!!!!
Gah!
*Achoo!!!
There, all better.
Thanks Paul!
---------------------------------------------------------
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."
May 24, 2011 at 6:21 am
LutzM (5/24/2011)
GilaMonster (5/23/2011)
LutzM (5/23/2011)
---------------------------------------------------------
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."
May 24, 2011 at 6:17 am
SQLRNNR (5/23/2011)
Jim Murphy (5/23/2011)
Jack Corbett (5/23/2011)
LutzM (5/23/2011)
GilaMonster (5/23/2011)
---------------------------------------------------------
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."
May 23, 2011 at 8:59 pm
you might also want to convert it to XML, then you can actually expand it and look at the elements (it'll come back as a link, click on it, and...
---------------------------------------------------------
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."
May 23, 2011 at 7:53 pm
Try wrapping your column in ISNULL() or COALESCE()
example:
SELECT INDACCOUNTNUMBER, TOTALPYMTAMT, NETPAID, PAIDDATE, ACCOUNT_NAME
FROM dbo.Audit2010$
WHERE ISNULL(ACCOUNT_NAME,'') IN ('Community Impact Fund','Health', 'Income', 'Education','Community Relief Fund')
---------------------------------------------------------
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."
May 23, 2011 at 7:52 pm
I don't know the exact reason, but my guess it has to do with the clustered index being in the reverse order of the columns as listed in your 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."
May 23, 2011 at 6:12 pm
Not a fan of roses, Craig?
---------------------------------------------------------
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."
May 23, 2011 at 3:52 pm
SQLRNNR (5/19/2011)
Steve Jones - SSC Editor (5/19/2011)
Sorry, I saw your code and my wife came home from 3 days in Boston. Got distracted 😛
That and the liquor displayed on your...
---------------------------------------------------------
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."
May 19, 2011 at 3:58 pm
SQLRNNR (5/19/2011)
jcrawf02 (5/19/2011)
mister.magoo (5/19/2011)
[rant]This takes the biscuit http://www.sqlservercentral.com/Forums/FindPost1112017.aspx
[/rant]
hahahahaha....sorry you put so much time into that one, but that's pretty funny...
I like your new avatar. I was thinking of doing...
---------------------------------------------------------
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."
May 19, 2011 at 3:30 pm
mister.magoo (5/19/2011)
[rant]This takes the biscuit http://www.sqlservercentral.com/Forums/FindPost1112017.aspx
[/rant]
hahahahaha....sorry you put so much time into that one, but that's pretty funny...
---------------------------------------------------------
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."
May 19, 2011 at 2:33 pm
Ray K (5/19/2011)
WOTD: ark(as in [in his best Bill Cosby voice], "NOAH!!! I WANT YOU TO BUILD . . . ")
Bill Cosby told Noah to do that? Man, was...
---------------------------------------------------------
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."
May 19, 2011 at 7:38 am
Viewing 15 posts - 616 through 630 (of 2,443 total)