SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Insert Record
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

maddyslayer
Yak Posting Veteran

57 Posts

Posted - 03/12/2013 :  16:50:27  Show Profile  Reply with Quote
How do I get the master_customer_id where all the subscription codes' subscription state is Y?
Go to Top of Page

maddyslayer
Yak Posting Veteran

57 Posts

Posted - 03/13/2013 :  11:54:25  Show Profile  Reply with Quote
How do I insert a record with subcode='awd' for all customers other than those who currently have substate='N' for all subcodes?

Edited by - maddyslayer on 03/13/2013 11:55:54
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 03/13/2013 :  12:26:12  Show Profile  Reply with Quote
please dont open multiple threads for same issue. continue from other thread

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 03/13/2013 :  12:26:13  Show Profile  Reply with Quote
please dont open multiple threads for same issue. continue from other thread

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 2.08 seconds. Powered By: Snitz Forums 2000