Viewing 15 posts - 51,736 through 51,750 (of 59,072 total)
Thanks for the feedback, Tracey. Except for the SPID (I had an active connection with 58), that's the exact code I used. Got zero rows in return no...
March 15, 2008 at 6:19 pm
Compare that to where C/C++ programmers have been for over 15 years: they can write new code targeted to run on multiple different platforms right from the start AND expect...
March 15, 2008 at 6:14 pm
bitbucket (3/7/2008)
Run sp_who or sp_who2 to obtain the process id (spid) then
DECLARE @Handle binary(20)
SELECT @Handle...
March 15, 2008 at 5:53 pm
Thanks, Barry... Which state is Drexel in and which major is this typically for?
I'd still like to know which school Kaiitong is going to...
March 15, 2008 at 5:37 pm
Thanks Adam, but he said
"The source table will have approx 10,000 records."
I want to know how many rows are in the destination table. That will answer...
March 15, 2008 at 3:31 pm
Hi, everyone. I'm working on my senior project.
Cool! Which school?
March 15, 2008 at 3:25 pm
How many rows in the desitination table?
March 15, 2008 at 3:11 pm
Dang, Barry... good stuff but awfully long for saying that folks preach the standards right up to the point where the standards don't work for them and then they violate...
March 15, 2008 at 2:42 pm
Barry, you're correct... the single column update example yields nearly identical results for both query types in 2k5.
[font="Courier New"]Correlated Subquery...
Table 'TargetTable'. Scan count 1, logical reads 54, physical reads 0,...
March 15, 2008 at 1:42 pm
All I can say is “Not in My Experience.” Although Sql2000 did have some problems in this area (performance “bugs”, IMHO) these were mostly addressed in Sql2005.
Thanks for that...
March 15, 2008 at 1:18 pm
Oh... ok. Thanks Jack.
Hey, do you have a dates table? I've got a neat trick to show you if you do...
March 15, 2008 at 12:56 pm
Like this...
--===== Solve the problem is 2k5
SELECT Category,[Desc],ID,
DENSE_RANK() OVER (ORDER BY Category,[Desc]) AS Seq
FROM #yourtable
ORDER BY...
March 15, 2008 at 11:55 am
But for some application elements it would be very handy to copy a complete row of data
and then alter some values of the new record via the userapplication,
You really...
March 15, 2008 at 11:45 am
Sure... use DENSE_RANK instead of ROW_NUMBER... look it up in Books Online... except for the partition, the rest of the query will be pretty much the same...
March 15, 2008 at 11:06 am
Ummm... just in case you don't have a "Dates" table like what Jack used, please consider the information at the following URL...
March 15, 2008 at 10:47 am
Viewing 15 posts - 51,736 through 51,750 (of 59,072 total)