April 15, 2010 at 1:35 am
Dear all,
i am working on table
for example table contains the following columns
id int
itemID int
isActive char(1)
i want to find the duplicate records on itemID column condition is isactive =1
Thanks in Advance
Srikanth
April 15, 2010 at 3:21 am
Have a read for a comprehensive one! 🙂
http://www.sqlservercentral.com/Forums/Topic899000-338-1.aspx
---------------------------------------------------------------------------------
April 15, 2010 at 8:10 am
Nabha (4/15/2010)
Have a read for a comprehensive one! 🙂http://www.sqlservercentral.com/Forums/Topic899000-338-1.aspx
And another: http://www.sqlservercentral.com/articles/T-SQL/68376/[/url] 😉
The discussion reveals some alternate methods as well.
_________________________________
seth delconte
http://sqlkeys.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply