Viewing 15 posts - 5,221 through 5,235 (of 5,685 total)
Piotr.Rodak (10/27/2010)
Having said that, wouldn't you be looking for something like
select #tmp.key1, #tmp.key2 FROM #tmpinner join
(
SELECT key1 FROM #tmp
EXCEPT
SELECT key1 FROM #tmp2
) q on #tmp.key1 = q.key1
?
Regards
Piotr
Pretty much, but...
October 27, 2010 at 5:10 pm
PHXHoward (10/26/2010)
Using your example, I tried to do it this way:
declare @Version int
set @Version = '10000'
SELECT DP.Name, DV.Version
FROM DatabaseProduct DP
JOIN DatabaseVersion DV
ON...
October 26, 2010 at 6:27 pm
sasi.tripuraneni (10/26/2010)
hello,Can any one please post Sr level interview questions, its very urgent!
thanks
Sasi.
Question 1: Did you ever go to SSC to...
October 26, 2010 at 5:52 pm
GSquared (10/26/2010)
October 26, 2010 at 4:49 pm
mtillman-921105 (10/26/2010)
Steve Jones - SSC Editor (10/26/2010)
My son says this reminded him of me. Yikes.
You remind him of which one? Steve or Bill? 😀
That's really funny by the...
October 26, 2010 at 3:27 pm
virpan_17 (10/26/2010)
I hope that my question is clear.
As mud.
Alright, you have a table. Col1 is varchar with an assumed column indicating level that's calculated by LEN(Col1). Easy...
October 26, 2010 at 2:18 pm
drew.allen (10/26/2010)
Craig Farrell (10/25/2010)
Okay, the error message is simple enough, but I thought the point of EXCEPT was to reword the anti semi-join operation?
The purpose of EXCEPT is to handle...
October 26, 2010 at 11:04 am
Jeffrey Williams-493691 (10/25/2010)
You have a simple mistake in your test:
SELECT key1, key2 FROM #tmp
EXCEPT
SELECT key1, key2 FROM #tmp2
Sadly, that wasn't a mistake, that's actually what I'm trying to do, and...
October 25, 2010 at 8:16 pm
Is this a new development or has the system been slowly stagnating over time?
If it's a new development, and it's a cluster, force a failover. Let the users work...
October 25, 2010 at 8:10 pm
I recently ran into this one head first.
The view using ROW_NUMBER() has to compute all the rownumbers before the where clause from the outer call gets involved.
So SELECT * FROM...
October 25, 2010 at 5:45 pm
WayneS (10/21/2010)
Here is the latest version of the Delimited Split Function
DelimitedSplit8k... d'oh. My bad. Thank you Wayne. It's now (finally) stored in my 'favorites' folder.
Jeff and yourself...
October 22, 2010 at 4:46 pm
Alvin Ramard (10/22/2010)
Craig Farrell (10/22/2010)
Alvin Ramard (10/22/2010)
Alvin Ramard (10/22/2010)
I'm getting sick and tired of having to deal with people trying to use SSIS without taking the time to learn how...
October 22, 2010 at 4:01 pm
Alvin Ramard (10/22/2010)
Alvin Ramard (10/22/2010)
[rant]I'm getting sick and tired of having to deal with people trying to use SSIS without taking the time to learn how to use it first!!!!!!!!
[/rant]
I...
October 22, 2010 at 3:37 pm
Can't... resist...
after the deployment of ssis package in filesystem.
we run the package in filesystem in ssms.
commonly run the package in dtexeutility.
after we are providing the roles to the client.
how the...
October 22, 2010 at 3:31 pm
Alvin Ramard (10/22/2010)
[rant]I'm getting sick and tired of having to deal with people trying to use SSIS without taking the time to learn how to use it first!!!!!!!!
[/rant]
Heh, DTS to...
October 22, 2010 at 1:50 pm
Viewing 15 posts - 5,221 through 5,235 (of 5,685 total)