Viewing 15 posts - 6,301 through 6,315 (of 18,926 total)
SwayneBell (5/10/2011)
By now, I'm sure that you've looked it up in BOL, but it's worth mentioning for others who read this thread; a constraint if you're implementing this function...
May 10, 2011 at 5:40 am
Awesome, thanks for posting the final answer. Will surely help someone someday.
May 10, 2011 at 5:34 am
An easy solution could be to do it in 2 steps (easier on the eyes too).
Get all the sums > derived table
ROW_NUMBER () OVER(col1 / case when col2 <> then...
May 9, 2011 at 7:44 pm
Dave Morrison (5/9/2011)
my head hurts 🙂 I was agreeing with you and was meant to be commenting on Jesse's post.
There's a session bug on thsoe buttons. Long story short...
May 9, 2011 at 2:33 pm
MyDoggieJessie (5/9/2011)
May 9, 2011 at 2:32 pm
Dave Morrison (5/9/2011)
Yeah sorry quoted the wrong post, my bad 🙂
How could you have quoted the wrong post when you quoted no post?... sounds like a null debate to me...
May 9, 2011 at 11:57 am
mikeincape (5/9/2011)
Ninja's_RGR'us (5/9/2011)
You need to correlate the base query with the column's subquery so that you only get...
May 9, 2011 at 11:54 am
Dave Morrison (5/9/2011)
Take a gander at the post, its a count(). What you've said is obviously correct but wasnt the question that was asked 🙂
Who are you talking to? ...
May 9, 2011 at 11:52 am
Lowell (5/9/2011)
Ninja's_RGR'us (5/9/2011)
I'll let you figure this on out... or correct lowell's typos :w00t:. Yes uncalled-ish for ;-).
😀 only uncalled for when it's not true!
anyway, fix the syntax issues...
May 9, 2011 at 11:50 am
No, your whole left join goes into a subquery for the column only.
You need to correlate the base query with the column's subquery so that you only get 1 client,...
May 9, 2011 at 11:48 am
stormsentinelcammy (5/9/2011)
Yes Jessie, selecting one column will always be faster than selecting the entire table.select * from Mytable vs select [hello] from Mytable will return back results quicker. 🙂
I'm...
May 9, 2011 at 11:45 am
mikeincape (5/9/2011)
May 9, 2011 at 11:40 am
GilaMonster (5/9/2011)
MyDoggieJessie (5/9/2011)
Shouldn't SELECT COUNT(1) be the preffered method here over (*)? In larger tables I've noticed drastic performance improvements by choosing only 1 column...
No. The * in count(*)...
May 9, 2011 at 11:37 am
I'll let you figure this on out... or correct lowell's typos :w00t:. Yes uncalled-ish for ;-).
SELECT
T.name,
STUFF((
...
May 9, 2011 at 11:30 am
mikeincape (5/9/2011)
Ok.... Runs fine on my server. Must be from using the express version on my local pc...
Microsoft SQL Server Management Studio9.00.4035.00
Microsoft Analysis Services Client Tools2005.090.4035.00
Microsoft Data Access Components...
May 9, 2011 at 11:27 am
Viewing 15 posts - 6,301 through 6,315 (of 18,926 total)