I am getting 2 resultsets depending on conditon, In the second
conditon i am getting the above error could anyone help me..........
CREATE proc sp_count_AllNewsPapers
@CustomerId int
as
declare @NewsId int
set @NewsId = (select NewsDelId from NewsDelivery where
CustomerId=@CustomerId )
if not exists(select CustomerId from NewsDelivery where
NewsPapersId=@NewsId)
begin
select count( NewsPapersId) from NewsPapers
end
if exists(select CustomerId from NewsDelivery where
NewsPapersId=@NewsId)
begin
select count(NewsDelId) from NewsDelivery where
Customerid=@Customerid
end
GO