Viewing 15 posts - 50,311 through 50,325 (of 59,078 total)
CrazyMan,
I have a similar situation at work... Just to be sure... you're talking about 24 tables, correct?
Just to be sure, you ARE using 2005, correct?
How many (order of magnitude) rows...
May 24, 2008 at 9:44 am
Marvin,
I'm a bit confused and I'm obviously missing something.... I looked at the 100 rows of test data you attached... Without me wading through all the code you posted, what...
May 24, 2008 at 9:33 am
Alright, Venki... you've given us just about nothing to go on... no table Create statement, no data, no column names... and your sample query of...
1st query:
select month, count(*) from ...
May 24, 2008 at 9:04 am
Sorry about that... BitBucket's method for deleting dupes when an IDENTITY column is present is just as fast as what I posted. Here's his code "Modenized" for the test...
May 23, 2008 at 7:37 pm
Jeff Moden (5/23/2008)
I'll crank out an example tonight...
Wow! I think I just figured out what to write about in an article!
Terry,
IF there's and IDENTITY column on the table...
May 23, 2008 at 7:25 pm
tosscrosby (5/23/2008)
May 23, 2008 at 5:36 pm
Matt Miller (5/23/2008)
Jeff Moden (5/23/2008)
Heh... just imagine me writing a book... 11 pages every 2 days... it would take an eon for me to write one. I don't know...
May 23, 2008 at 5:28 pm
Peso (5/23/2008)
Even simpler
ALTER FUNCTION TruncDate
(
@InDate DATETIME
)
RETURNS DATETIME
AS
BEGIN
RETURN DATEDIFF(DAY, '19000101', @InDate)
END
Simple... yes. Clever... very....
May 23, 2008 at 5:24 pm
Rob Reid (5/23/2008)
I haven't done much work with views and I definitley don't need the data to...
May 23, 2008 at 4:49 pm
Why not, indeed... that would be the way to go...
May 23, 2008 at 3:29 pm
That's some of the best compliments I could hope for, Tom... someone adding this type of code to their library. Thanks!
If you haven't done so already, here's a recent...
May 23, 2008 at 3:22 pm
ALZDBA (5/23/2008)
Jeff Moden (5/23/2008)
... or when parallism takes over. Even then, an Order By and a OPTION (MAXDOP1) will take care of that....
:ermm:
Just a little reminder of a nice...
May 23, 2008 at 9:25 am
tosscrosby (5/23/2008)
Jeff Moden (4/29/2008)
SQL ORACLE (4/29/2008)
You cannot delete duplicates directly from a table unless you would like to delete rows, which are duplicated.Any bets? 😉
Jeff, I am not doubting your...
May 23, 2008 at 9:00 am
And, I take it, line 153 is somewhere in the code you posted?
May 23, 2008 at 8:55 am
Viewing 15 posts - 50,311 through 50,325 (of 59,078 total)