Forum: MS SQL  Aug 2nd, 2006 |
| Replies: 13 Views: 3,959 Re: duplicate rows
i think this was the easyes way of the 2 options but it does work
thank you once again
lorraine1000 |
| Forum: MS SQL Aug 2nd, 2006 |
| Replies: 13 Views: 3,959 |
| Forum: MS SQL Aug 2nd, 2006 |
| Replies: 13 Views: 3,959 Re: duplicate rows
SELECT COUNT(*), sID1, sID2, sID3 FROM ITEM_T
WHERE sItemID NOT IN (400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418,
419, 420, 421, 422, 423, 425, 426,... |
| Forum: MS SQL Aug 2nd, 2006 |
| Replies: 13 Views: 3,959 Re: duplicate rows
ok this is going to be a bit long but i try and explain better
400
401
402
403
404
405
406
407 |
| Forum: MS SQL Aug 2nd, 2006 |
| Replies: 13 Views: 3,959 Re: duplicate rows
nope 760 761 762 should not be allowed :(
the IDs that should be allowed are these
400 thought to 429
706 thought to 749
with 720 to 723 missing
and 734 to 736 missing
and 739 to 744 missing |
| Forum: MS SQL Aug 2nd, 2006 |
| Replies: 13 Views: 3,959 Re: duplicate rows
hi i was wondering if you could help me a little more with this same code. where i have this
WHERE (sItemID = 760) OR
(sItemID = 761) OR
(sItemID = 762)
it would be easyer to do a full list not... |
| Forum: MS SQL Aug 2nd, 2006 |
| Replies: 13 Views: 3,959 |
| Forum: MS SQL Aug 2nd, 2006 |
| Replies: 13 Views: 3,959 Re: duplicate rows
i have tryed this already and i get this error
Server: Msg 156, Level 15, State 1, Line 7
Incorrect syntax near the keyword 'UNION'. |
| Forum: MS SQL Aug 2nd, 2006 |
| Replies: 13 Views: 3,959  duplicate rows
Hi
i having a few problems what i need to do is find duplicate rows in a mssql database i can do from one table but i need it to run across 2 tables
this is the code i useing to do one table
... |
