Viewing 15 posts - 286 through 300 (of 859 total)
Cliff Jones (7/17/2012)
SQLRNNR (7/17/2012)
EL Jerry (7/17/2012)
JAZZ Master (7/17/2012)
Cliff Jones (7/17/2012)
Daniel Bowlin (7/17/2012)
rhythmk (7/16/2012)
SQLRNNR (7/16/2012)
incorporateaddition
subtraction
no traction
icy
I see, too. Or three. 😀
ICU
ICQ
AIM
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 17, 2012 at 3:37 pm
Lynn Pettis (7/17/2012)
Really???
does not seem to be the same welsh as when i first started posting.
or is it
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 17, 2012 at 3:34 pm
not a problem, i use to use a 1 base tally untill i read jeff's new 8k split then started running a 0 based tally. i should probably have...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 17, 2012 at 1:54 pm
dynamic sql for sure would solve this however this is not normally a good option. can you provide a little more detail on what you are trying to accomplish....
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 17, 2012 at 12:56 pm
i should not try to solve problems real quick before lunch. empty stomach leads to face palm moments. no need to add N to 65 since thats the...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 17, 2012 at 12:53 pm
Sean Lange (7/17/2012)
capn.hector (7/17/2012)
DECLARE @STR VARCHAR(8000)
SET @STR = 'Rang the client and agreed they would begin to pay off £x...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 17, 2012 at 12:29 pm
Here is mine, slightly different way to calculate the bits
DECLARE @STR VARCHAR(8000)
SET @STR = 'Rang the client and agreed they would begin to pay off £x off their current...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 17, 2012 at 11:09 am
you have 3 levels of views, (the giant over view, the 11 sub views which are made up of both tables and views) and you are returning over 4.5...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 16, 2012 at 6:09 pm
JAZZ Master (7/13/2012)
SQLRNNR (7/13/2012)
downtown
Funky
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 13, 2012 at 2:46 pm
i think this is your original query
SELECT o.OrderID, o2.OrderID, o.ItemID
FROM OrderItem o
INNER JOIN OrderItem o2
ON o.ItemID = o2.ItemID
AND...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 13, 2012 at 2:44 pm
can you post the query you are using to get the "Bad" result set
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 13, 2012 at 2:34 pm
the question is how often do you upload? if its quicker than every month then getting the last month of data would increase the size not decrease it. ...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 13, 2012 at 12:40 pm
SQLRNNR (7/12/2012)
And since the old style cannot be easily deprecated, it's best just to teach the new ways imho.
untill you run into a production system using sql 7 because its...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 12, 2012 at 3:42 pm
depending on how much accuracy you want to imply in your code would be which one i would choose. they are both the same once the implicit conversion occurs...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 12, 2012 at 1:15 pm
rhythmk (7/11/2012)
SQLRNNR (7/11/2012)
Cliff Jones (7/11/2012)
crookj (7/11/2012)
Possinator (7/11/2012)
SQLRNNR (7/11/2012)
jasona.work (7/11/2012)
EL Jerry (7/11/2012)
SQLRNNR (7/11/2012)
exploding grapesExploding Gremlins
"El" Jerry.
Mogwai
Gizmo
Bright light!
Poltergeist
They're heeeeere!
steak and maggots
Careful
Security
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
July 12, 2012 at 6:18 am
Viewing 15 posts - 286 through 300 (of 859 total)