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
 General SQL Server Forums
 New to SQL Server Programming
 store procedure match field

Author  Topic 

rajnidas
Yak Posting Veteran

97 Posts

Posted - 2013-10-31 : 06:09:31

hi everyone,

i need some store procedure script , from two table i want to pickup matching field and insert into main table ,give some sample store procedure coding...

if 1st table as cheque no and 2nd table as cheque no - matching then data would be inserted in to maintable
i need help pls.... using two table

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-31 : 06:17:07
have a look at sql joins and make a start

http://www.w3schools.com/sql/sql_join_inner.asp


------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

rajnidas
Yak Posting Veteran

97 Posts

Posted - 2013-10-31 : 06:39:14
thank you so much its working

very simple to understand ....
Go to Top of Page
   

- Advertisement -