Viewing 15 posts - 16 through 30 (of 151 total)
Jeff Moden (7/20/2009)
ab5sr (6/25/2009)
I'd look at the split method in .Net to create an array for this. Otherwise you might get stuck with some cheesy TSQL string manipulation.
I know this...
July 20, 2009 at 7:59 am
Ok cool. Glad you found something that works for you.
Interestingly, I just saw a jumpstart on this today. I haven't taken a look at this, but I know that the...
June 26, 2009 at 9:22 am
Abdullah M. Al-Fararjeh (6/22/2009)
Great question! Welcome to the board by the way.
My rule of thumb is...don't listen to rules of thumb and find out...
June 25, 2009 at 2:59 pm
Do me a favor - can you open perfmon and compare Sql Server:Databases/ Transactions/sec for _total to tempdb transactions per second? Subtract out tempdb so you can see what %...
June 25, 2009 at 2:49 pm
Wonder if you could use sqlcmd for this?
June 25, 2009 at 2:33 pm
Well that is one option. I can't tell if he wants to exec the query from tsql in a file, or do what you posted.
Another option - create a linked...
June 25, 2009 at 2:20 pm
That might require a HAVING clause, which filters the aggregate. Can you post whatcha got now?
June 25, 2009 at 1:38 pm
John Paul (6/25/2009)
I am not sure , But Can you try once with UNION ALL (combined with a GROUP BY): really quick and easy way to compare two tables.
Well sure,...
June 25, 2009 at 12:56 pm
No, like:
SELECT RANK, col2, col3, etc.
FROM
(SELECT *
FROM yourquery
...
June 25, 2009 at 12:48 pm
Can you remove all of the group by stuff and create a derived table on your query, and then reference 'Rank'?
June 25, 2009 at 12:20 pm
EXCEPT and INTERSECT will have bad plans for the most part, so this doesn't surprise me. Handy, but not performance-friendly.
June 25, 2009 at 12:15 pm
I'd look at the split method in .Net to create an array for this. Otherwise you might get stuck with some cheesy TSQL string manipulation.
June 25, 2009 at 12:13 pm
Try this maybe?
/************************
Including extra columns in a grouping - solution
Lee Everest
************************/
use tempdb
go
CREATE TABLE Project (
Project varchar (10)
,Employee_ID varchar (10)
,Job_Name varchar (20)
,Job_Start_Date datetime
)
GO
INSERT INTO Project VALUES ('Beach','Emp01',...
June 25, 2009 at 11:57 am
Viewing 15 posts - 16 through 30 (of 151 total)