Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Query help

Author  Topic 

maddyslayer
Yak Posting Veteran

57 Posts

Posted - 2013-03-13 : 16:54:12
How do insert a new record with cus_code = 'A' and code_state='Y' for each customer? Duplicates are not allowed.

list_id cus_id cus_code code_state

1 20 x Y
2 20 y y
3 20 z y
4 20 p N
5 21 x N
2 21 y y
3 21 z y
4 21 p N

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2013-03-13 : 16:57:13
can a mod please kick this member?

The same question always in a new post with no response to given solutions!

dear maddyslayer: that's not how it works!


Too old to Rock'n'Roll too young to die.
Go to Top of Page
   

- Advertisement -