We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
declare @array as table(statement float) -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; IF @StatementDocNo = 0 BEGIN SELECT 0 AS [Amount Due] END ELSE BEGIN -- Insert statements for procedure here insert into @array SELECT DISTINCT -- select top 10 * from umcr2100 isnull(util..UMCR2102.umAmount1,0) AS [Discounted Amount Due] FROM util..UMCR2100 INNER JOIN util..UMCR2102 ON util..UMCR2100.umStatementDocNo = util..UMCR2102.umStatementDocNo WHERE (util..UMCR2100.umStatementDocNo = @StatementDocNo) AND umDescription1 LIKE 'Total Amount Due%' IF @@ROWCOUNT = 0 BEGIN SELECT 0 AS [Amount Due] END ELSE BEGIN select * from @array END END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.