Viewing 15 posts - 49,156 through 49,170 (of 59,065 total)
This is right on the border line of me thinking this is some type of homework... please post a decent try!
I will give you a hint, though... lookup GROUP BY.
July 16, 2008 at 5:35 pm
karthikeyan (7/16/2008)
which one is good when we think performance ?
Try it... let us know...
--===== Create and populate a 1,000,000 row test table.
-- Column "RowNum" has...
July 16, 2008 at 8:45 am
karthikeyan (7/16/2008)
Jeff,how about my code ?
What size column do you thing NAME = '' will make? Also, look at the update... which NAME shall it use to do the...
July 16, 2008 at 8:40 am
RyanRandall (7/14/2008)
update #TEST set Descr = replace(replace(replace(Descr, ' ', '¬ '), ' ¬', ''), '¬', '') where Descr like '% %'
(Where...
July 16, 2008 at 8:07 am
Ok... now that I've had a bit of coffee... 😛
In the original problem posted, San didn't care about which name was returned so just use the MIN or Max name...
July 16, 2008 at 7:37 am
Dugi (7/16/2008)
Hi Jeff!Your code here just selecting and ordering asc the data inside the table it doesn't do any elimination of duplicate records!
Can you explain little bit this!
Dugi
I believe that...
July 16, 2008 at 7:17 am
Dugi (7/16/2008)
Hi Jeff!Your code here just selecting and ordering asc the data inside the table it doesn't do any elimination of duplicate records!
Can you explain little bit this!
Dugi
Heh... Sure! ...
July 16, 2008 at 7:15 am
I wouldn't recommend that way... it has a While loop in it and a couple of other performance related problems. Try the following, please... it also explains how it...
July 15, 2008 at 11:45 pm
There are a couple of ways... I believe the fastest for large data sets in SQL Server 2000 would be in the following...
http://www.sqlservercentral.com/articles/Advanced+Querying/61716/
July 15, 2008 at 11:39 pm
riga1966 (7/15/2008)
I think you are right.
I replaced UPDATE code and ran it.
But it now gets stuck inside a loop.
I run this SP a a script. I put lots of...
July 15, 2008 at 1:45 pm
Heh... you guys are missing the real problem! 😉 The real problem is why does the OP NOT care about which data is returned? If you don't care,...
July 15, 2008 at 12:12 pm
Heh... I feel the same... but I said "Today, just this one day, I shall not rant." 😛
July 15, 2008 at 12:08 pm
karthikeyan (7/15/2008)
use distinct keyword
Let's see how you would do that, Karthik... 😉
July 15, 2008 at 8:55 am
I know disk space is relatively cheap... I just can't bring myself to suffer the overhead of storing XML in a database anywhere except a temporary staging table. With...
July 15, 2008 at 7:06 am
paulhunter (7/15/2008)
In the .NET world you don't grant access to the internal code and data structures except thru properties and methods, so don't treat your database differently.
THAT is one of...
July 15, 2008 at 7:01 am
Viewing 15 posts - 49,156 through 49,170 (of 59,065 total)