Viewing 15 posts - 21,871 through 21,885 (of 22,224 total)
Take a look at today's article on CTE's. It shows several methods that might help with this question:
http://www.sqlservercentral.com/columnists/phe/2926.asp
Depending on how complicated you want to get with the query, you...
"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
May 8, 2007 at 6:57 am
Look up the statement ALTER TABLE and then follow Lynn Pettis' advice above.
"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
May 8, 2007 at 6:53 am
I'd sure like to see the queries before I can completely agree with the conclusions.
"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
May 8, 2007 at 6:17 am
I've never been asked anything too odd. However, back in the good ole days of the DOT COM boom, I was interviewed in a backyard sitting on a swing set....
"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
May 4, 2007 at 11:35 am
Just to reassure you, you found "the" solution. You didn't have sufficient permissions under your regular login. You had to either get your login the permssions needed, or use a...
"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
May 4, 2007 at 11:24 am
You didn't mention what level of access you have to the database in question. If you're not mapped to the owner of the stored procedure (for example, 'dbo'), then your...
"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
May 4, 2007 at 11:21 am
Sorry, I was answering the other question, not your statement. You're correct. That, in fact, is probably what he needs to do. I apologize for any confusion.
"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
May 3, 2007 at 1:23 pm
I don't think you can. At least, I don't seem to be able to in the tests I've run so far. However, can you, instead, return a larger set of...
"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
May 3, 2007 at 12:55 pm
Sorry, we don't check to see if records exist, we simply insert them as part of changes otherwise your approach would work very well. What I showed is the select...
"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
May 3, 2007 at 10:33 am
I agree on the recursion. I've implemented one solution using it and I was VERY sorry afterwards.
We have a need to only every insert data, no updates. So, we have a...
"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
May 3, 2007 at 10:02 am
If I understand the question... No. You can't pass parameters to a view.
"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
May 3, 2007 at 8:29 am
Thanks for the correction. 100% accurate. Apologies for the bit of bad info.
"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
May 3, 2007 at 8:20 am
Download the AdventureWorks database from Microsoft. It's a pretty good place for running tests & learning.
"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
May 3, 2007 at 8:16 am
There is a lot of time in Itzik's book on graphing & trees & pivots that, in my opinion, won't be used by most people (myself included). However the APPLY &...
"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
May 3, 2007 at 8:15 am
I want to jump on the band wagon and recommend Itzik Ben-Gan's "Inside TSQL Querying". Add to it his "Inside TSQL Programming". The first book is all about TSQL queries. The...
"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
May 3, 2007 at 8:11 am
Viewing 15 posts - 21,871 through 21,885 (of 22,224 total)