Viewing 15 posts - 38,926 through 38,940 (of 59,072 total)
CirquedeSQLeil (4/10/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2010 at 8:13 pm
Oh... and just to be sure... this code also removes dupes if they occur on the same date. Only the earliest dupe according to the RowID will be kept....
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2010 at 8:11 pm
BIMind (4/10/2010)
Hmmm Jeff..thanks for the input...i am surprised by the results with your code...i am wondering why...because it works perfectly with the same data i posted above
It's because there is...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2010 at 7:57 pm
Here's one very high speed method that also has the advantage of being able to stop the code just prior to the final delete to verify what's actually going to...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2010 at 7:53 pm
BIMind (4/10/2010)
berry...this worked perfect..i cant believe how simple this is...
if anyone is interested, here's the sample script
create table sample_7day (call_id int identity(1,1), UserID int, Post_date...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2010 at 7:04 pm
bteraberry (4/8/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2010 at 7:03 pm
kjain (4/9/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2010 at 9:31 am
hennie7863 (4/6/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2010 at 8:58 am
pmadhavapeddi22 (4/9/2010)
Hi Sasidhar,It really helped me. Thanks
Padmaja[font="Arial"][/font]
Cool... can you post the function you ended up with, please? I'd like to see what you did. Thanks.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2010 at 10:31 pm
SQL_NuB (4/9/2010)
I have 2 tables that I have to use.
table 1 has 2 columns that I need
refDate, closedDate (taskName needs to be joined on...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2010 at 10:21 pm
GSquared (4/9/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2010 at 10:09 pm
rames.net (4/9/2010)
I have a small doubt, Generally when I got alert on tempdb log file size 75 %...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2010 at 10:04 pm
Baskar B.V (4/9/2010)
Forgot to mention in the previous post.The total records which would get updated would be around 10 million records.
My recommendation is that you split that up into batches...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2010 at 10:02 pm
NEAL-464478 (4/9/2010)
IdnoProcessDataIDNameColor
1-1- ...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2010 at 9:57 pm
Hey folks... as a sidebar to all of this, since the Integer date is in the yyyymmdd ISO format, the formula to convert the Integer date to the DATETIME datatype...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2010 at 5:20 pm
Viewing 15 posts - 38,926 through 38,940 (of 59,072 total)