Srored Procedure Error [Resolved]

Posted by Raj.Trivedi under Sql Server on 11/20/2014 | Points: 10 | Views : 1273 | Status : [Member] [MVP] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

I am getting the following error when i trying to create the store procedure

Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

create proc GetDiscountforClient
(
@ClientId int
)
as
begin
declare @RowTransactionCount int;
declare @DiscountValue decimal(18,2);
set @RowTransactionCount = (Select Count(ClientId) from TransactionDetail where
ClientId = @ClientId)
if(@RowTransactionCount > 5)
begin
set @DiscountValue = (select DV.ActualValue,DV.DiscountId,DM.DiscountType
from DiscountValue DV
inner join DiscountMaster DM
on
DV.DiscountId = DM.DiscountId
where DV.DiscountId = 1)
end
select @DiscountValue 'DiscountValue'
end

Regard's
Raj.Trivedi
"Sharing is Caring"
Please mark as answer if your Query is resolved

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Bandi on: 11/21/2014 [Member] [MVP] Platinum | Points: 50

0	create proc GetDiscountforClient ( @ClientId int ) as begin declare @RowTransactionCount int; declare @DiscountValue decimal(18,2); set @RowTransactionCount = (Select Count(ClientId) from TransactionDetail where ClientId = @ClientId) if(@RowTransactionCount > 5) begin SELECT @DiscountValue = DV.ActualValue from DiscountValue DV inner join DiscountMaster DM on DV.DiscountId = DM.DiscountId where DV.DiscountId = 1) end select @DiscountValue 'DiscountValue' end Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Raj.Trivedi, if this helps please login to Mark As Answer. \| Alert Moderator

create proc GetDiscountforClient 
( 
@ClientId int 
) 
as 
begin 
declare @RowTransactionCount int; 
declare @DiscountValue decimal(18,2); 
set @RowTransactionCount = (Select Count(ClientId) from TransactionDetail where 
ClientId = @ClientId) 
if(@RowTransactionCount > 5) 
begin 
SELECT @DiscountValue = DV.ActualValue from DiscountValue DV  
inner join DiscountMaster DM on  DV.DiscountId = DM.DiscountId 
where DV.DiscountId = 1) 
end 
select @DiscountValue 'DiscountValue' 
end

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Raj.Trivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Goud.Kv on: 11/22/2014 [Member] [MVP] Gold | Points: 25

0	Good one Bandi... Thanks & Regards, Krishna Raj.Trivedi, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts