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.
Author |
Topic |
taj
Starting Member
39 Posts |
Posted - 2013-07-04 : 04:07:36
|
Hi all,I want to create a SP,which takes the result from the select statement and update into other table.Below is the query which i tried and its incomplete,plz help me in fixing this prob.CREATE PROCEDURE SP_UPDATE_PATIENT_REGISTRATION_RENEW_DATE@PID BIGINTASBEGINUPDATE PATIENT_REGISTRATION SET RENEWAL_DATE_D = SELECT BD.BILL_DATE_DFROM BILL_DETAILS BD JOIN BILL_MASTER BM ON BM.BILL_NUMBER_V = BD.BILL_NUMBER_VJOIN PATIENT_PROFILE PP ON PP.PATIENT_ID_N = BM.PATIENT_ID_NWHERE SERVICE_CODE_N = 293 AND BD.BILL_SETTLED_C = 'Y'AND BM.PATIENT_ID_N=@PIDENDThank You |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-04 : 04:25:17
|
sounds like thisCREATE PROCEDURE SP_UPDATE_PATIENT_REGISTRATION_RENEW_DATE@PID BIGINTASBEGINUPDATE PRSET RENEWAL_DATE_D = BD.BILL_DATE_DFROM BILL_DETAILS BD JOIN BILL_MASTER BM ON BM.BILL_NUMBER_V = BD.BILL_NUMBER_VJOIN PATIENT_PROFILE PP ON PP.PATIENT_ID_N = BM.PATIENT_ID_NJOIN PATIENT_REGISTRATION PR ON PR.PATIENT_ID_N = PP.PATIENT_ID_NWHERE SERVICE_CODE_N = 293 AND BD.BILL_SETTLED_C = 'Y'AND BM.PATIENT_ID_N=@PIDEND ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|