Viewing 15 posts - 241 through 255 (of 621 total)
Now, it just so happens that yesterday was my birthday, and I know I never disclosed it. I thought for a moment I had encountered some one with uncanny...
December 22, 2009 at 11:03 am
Greg Snidow (12/22/2009)
Lynn Pettis (12/22/2009)
set @MemberCount = @@rowcount; -- How many members with out download codesset rowcount @MemberCount; -- SQL Server 2000
Lynn, that's a neat little trick I never thought...
December 22, 2009 at 10:35 am
Lynn Pettis (12/22/2009)
set @MemberCount = @@rowcount; -- How many members with out download codesset rowcount @MemberCount; -- SQL Server 2000
Lynn, that's a neat little trick I never thought of. ...
December 22, 2009 at 10:27 am
I think Lynn's solution meets all your needs then. I did not see it until after I started working on it.
December 22, 2009 at 9:02 am
mrpolecat (12/21/2009)
update downloadcode set...dlcdateissued = getdate
mrpolecat, I don't see a column 'dlcdateissued' in either of your tables. Is it supposed to be dlcdatereceivied[SIC]? When I change it to...
December 22, 2009 at 8:31 am
ehlinger (12/21/2009)
December 22, 2009 at 6:48 am
ehlinger, I apologize for any confusion, but I just took the time to finish reading Jeff's article, and I realized I have omitted two important aspects; locking the table, and...
December 21, 2009 at 11:53 am
ehlinger (12/18/2009)
The misspellings of the name is correct because I'm matching on the dm fields.
Okay, well if that is the case, this simpler version should help. I put the...
December 21, 2009 at 8:22 am
Yeah, I was not too clear on which columns would determine a dupe, so I thought I would just include them all, and then the OP can comment out what...
December 18, 2009 at 2:11 pm
Just checkin in here. I took your records for Jon Menneke, and duplicated them, but changed the birthday and primary_id, just to simulate what I was talking about by...
December 18, 2009 at 1:47 pm
mrpolecat (12/18/2009)
one more step from Greg's code is to update the #mergelist table mergeid with the identity from the dups table joined on the double metaphone fields
DOH! I totally missed...
December 18, 2009 at 12:34 pm
ehlinger, you don't need a cursor. You could try something like this...
IF OBJECT_ID('TempDB..#Dupes','u') IS NOT NULL
DROP TABLE #Dupes
SELECT DISTINCT
...
December 18, 2009 at 10:08 am
mak101 (12/17/2009)
I wanted it something like that in one query.
Ok, here is where a little explanation may come in handy. If you look at my solution, the one comment...
December 18, 2009 at 8:40 am
Lynn Pettis (12/17/2009)
EmpName Reg TourStart TourEnd FOrdDate FOrdType FtOrdAmt LOrdDate LOrdType LOrdAmt
John West 8/15/09 - 8/17 B 57K 9/17 A 78K
Mike South 9/1/09 11/15/09 9/4 A...
December 17, 2009 at 12:15 pm
mak101, while I agree with Lynn's assessment that you need to try it yourself first, I also can see where to someone new to SQL, this problem would be difficult...
December 17, 2009 at 9:20 am
Viewing 15 posts - 241 through 255 (of 621 total)