May 24, 2010 at 12:23 pm
i create store procedure is not work please Solve my problem
create proc Block
@date datetime,
@clientID int,
@clientName varchar(25),
@ProductName varchar(25),
@Quantiy int ,
@price int,
@TotalAmount int
as
declare @Qurey varchar(50)
set @Qurey ='Select Status from Clientprofile where ClientID'+@clientID
if @qurey='Disable'
begin
rollback
end
else
if @qurey='Enable'
begin
insert into DailyClientTranscation (Dates,ClientID,ClientNames,ProductName,Quantity,Price,TotalAmount)values
(@date,@clientID ,@clientName ,@ProductName ,@Quantiy ,@price ,@TotalAmount )
end
May 24, 2010 at 12:37 pm
In your stored proc you just have to use one insert statement
insert into DailyClientTranscation (Dates,ClientID,ClientNames,ProductName,Quantity,Price,TotalAmount)
Select @date,clientID ,@clientName ,@ProductName ,@Quantiy ,@price ,@TotalAmount from clientprofile
where clientID = @clientID and status ='Enabled'
-Roy
May 24, 2010 at 12:49 pm
This statement:
set @Qurey ='Select Status from Clientprofile where ClientID'+@clientID
isn't doing what you think it's doing. It's not executing the query, it's just setting the variable equal to the string. So @qurey isn't equal to either 'disable' or 'enable'.
Try:
select @Qurey = Status from Clientprofile where ClientID = @clientID
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy