Viewing 15 posts - 20,881 through 20,895 (of 22,224 total)
I hate to say it, at this point, I'm confused. I'd have to see structure & some data to better understand what you're trying to do and what's going wrong....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2008 at 2:48 pm
It sounds like a paging problem.
One, of many, solutions that Itzik Ben-Gan offers in TSQL Querying:
--sets up data this way:
SELECT ROW_NUMBER() OVER(ORDER BY qty,empid) AS rownum,
empid,mgrid,qty
INTO #SALESRN
FROM dbo.Table;
CREATE UNIQUE CLUSTERED...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2008 at 2:46 pm
The MAX statement isn't working now?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2008 at 2:37 pm
Thanks. I'll check it out.
This thing jumped the topic track about 5 or six pages ago.
Just to put it back near the topic for a moment...
When being interviewed, how many...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2008 at 10:24 am
No, I mean get rid of the sub-select entirely. Why would you need it? If the name is in the consultant table then you should be able to pull it...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2008 at 10:21 am
Chris Morris (3/12/2008)
Grant Fritchey (3/12/2008)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2008 at 9:45 am
Nice. I made my long bow in a course with the Royal Bowyer of England. It's only about 50-60lb pull, but it'll throw a bodkin point about 75 yards. Only...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2008 at 9:26 am
Evidently, geeks with weapons!
:w00t:
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2008 at 9:18 am
The good news is, it's working. I just finished the install and I'm looking at the February CTP, finally.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2008 at 9:02 am
Get rid of the TOP 1 sub select in the SELECT clause, that's effectively a cursor in your code.
Try using a LEFT JOIN?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2008 at 8:56 am
The axe is such a clumsy weapon. How about a katana? Unless the interviewers are wearing armor, then I'm going for a good broadsword.
No pork chops!
How about just coming as...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2008 at 8:30 am
Oh, and it happened to one other guy at my company too. He was able to get his uninstalled. Mine wasn't. I'm probably going to be rebuilding my lap top....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2008 at 7:30 am
I ran into a problem. It didn't prevent 2005 from working, but it did cause parts of the GUI in SSMS to stop working. I would be very cautious about...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2008 at 7:29 am
Because you're grouping on everything, you'll get the max date for a distict select. You might want to look at something like:
SELECT c.consultantid
...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2008 at 7:12 am
Do I have to setup a stored procedure, or just write a select satement?
Yes.
Oh, a little more? Fine.
You can do either. The preferred approach when building applications is to create...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2008 at 6:10 am
Viewing 15 posts - 20,881 through 20,895 (of 22,224 total)