Need Store Procedure

Question

Need Store Procedure

Analyst_SQL 3,576

i have data in below table

Create table #tbl_ContD  (D_ID int,CID int,C_Weight int, I_ID int)  
  
insert into #tbl_ContD values (10001 ,20153,200,54)  
  
insert into #tbl_ContD values (10022 ,20153,300,null)  
  
insert into #tbl_ContD values (10033 ,20153,400,15)

i want to filter record using below query .

select Top(1) D_ID,C_weight   from #tbl_ContD where CID=20153 and I_ID is null

then insert above record D_ID and C_Weight into #tbl_Issuance_Rags like below

Create table #tbl_Issuance_Rags (R_ID int,D_ID int,R_Weight int,R_Date date,R_QTY int,E_Date date,R_Belt varchar)  
  
  
insert into #tbl_Issuance_Rags values (1111,10022,300,'2022-11-15',1,'2022-11-15','G')

Accepted answer

0 additional answers

Your answer

Answer 1

Viorel 122.5K

Check an interpretation:

insert #tbl_Issuance_Rags(R_ID, D_ID, R_Weight, R_Date, R_QTY, E_Date, R_Belt)  
select Top(1) 1111, D_ID, C_Weight, getdate(), 1, getdate(), 'G'  
from #tbl_ContD   
where CID = 20153 and I_ID is null

If it works, define a stored procedure.

Analyst_SQL 3,576 Reputation points

2022-11-16T05:37:25.52+00:00

@Viorel

i want more on thing ,that after inserted record into #tbl_Issuance_Rags then R_ID get update in table #tbl_ContD I_ID col
Viorel 122.5K Reputation points

2022-11-16T09:56:47.147+00:00
It is not clear why two different questions were merged; probably it was done accidentally.

In order to update the row, consider something like this:

update top(1) #tbl_ContD set I_ID = 1111 where CID = 20153 and I_ID is null

Note that if TOP(1) is required, then an ORDER BY is probably necessary in your statements.
Analyst_SQL 3,576 Reputation points

2022-11-17T05:50:55.487+00:00

thanks

Share via

Need Store Procedure

0 additional answers

Your answer