Loading

Inserting query based on a parameter from other table

Jes Sie

I have 2 tables namely:

tblRequest with fields id (PK,int), RequestedBooks (int), reason (nvarchar(500))

& tblResponse with fields id (int), BookDescription (nvarchar(50)), requestID(FK, int)

Now, if the requested books are only 3, how to make an insert statement for tblResponse that should only dispatch 3 books. Above that, It will deny the insert.

Thanks again, everyone.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kapil Singh Kumawat8y ago
Use the if else statement as sugggested by mahesh
Mahesh Sharma8y ago
declare @Count int = 0
select * into #MyTempTable from tblResponse

select @Count=count(*) from #MyTempTable

if(@count <3)
BEGIN
<>
END
Select * From tblResponse
drop table #MyTempTable