Viewing 15 posts - 19,261 through 19,275 (of 22,219 total)
kalikal (11/25/2008)
So from the table below I want
ProductID UnitID
1 ...
"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
November 25, 2008 at 6:37 am
I gave him the answer.... Yes
"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
November 25, 2008 at 6:11 am
Yes, SSIS or BCP can both work with semi-structured data.
"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
November 25, 2008 at 6:11 am
From the information you've given, you must have more than one row that meets the criteria defined. It's the only way you would get the problem.
"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
November 25, 2008 at 6:04 am
The question intrigued me, so I played with until I got the right answer. I've no doubt (at all) that there are more efficient ways to work this, but this...
"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
November 25, 2008 at 5:59 am
Take a look at the Books Online for the topic OUTPUT clause. That's exactly what you need. It can work with a single row insert, or with batches, and captures...
"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
November 25, 2008 at 5:33 am
A "self Join" is when a single table is joined back to itself. You have two tables.
Can you better define what it is you're trying to do?
"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
November 25, 2008 at 5:31 am
You can only run it once for a particular set of values, yeah.
Here, an example:
CREATE TABLE dbo.x
(ColNo1 INT NOT NULL,
ColNo2 INT NOT NULL,
Val VARCHAR(50) NULL)
ALTER TABLE dbo.x ADD CONSTRAINT...
"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
November 24, 2008 at 1:23 pm
It's not the each one is a primary key. You're looking at the GUI and seeing a key next to each column. That means they're part of a compound primary...
"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
November 24, 2008 at 12:55 pm
Lynn Pettis (11/24/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
November 24, 2008 at 11:30 am
Absolutely not a cursor.
If you're getting the error that you're violating the primary key, it's simply because you are, in fact, violating the primary key.
The purpose of the primary key...
"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
November 24, 2008 at 11:25 am
Another vote for the Inside series of books. Fantastic stuff in there. Other than that, no other books come to mind as absolute must reads. You start to get into,...
"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
November 24, 2008 at 11:17 am
Sure sounds like a possible case for transactional replication.
"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
November 24, 2008 at 7:25 am
Yes.
If you want records that only meet the criteria defined AND records that don't, it seems a bit odd. What you're saying then is return everything.
The two limiting factors, 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
November 24, 2008 at 7:02 am
Actually, it looks like you've changed the structure of the query unnecessarily.
...from (Premium_Access
inner join Premium
on Premium_Access.rollup =...
"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
November 24, 2008 at 6:30 am
Viewing 15 posts - 19,261 through 19,275 (of 22,219 total)