set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[STPGridList_SoodAll] @__StartDate char(8)='00/00/00', @__EndDate char(8)='99/99/99', @FormCaption nvarchar(1000) output AS if @__StartDate='' set @__StartDate='00/00/00' if @__EndDate='' set @__EndDate='99/99/99' if not (@__StartDate='00/00/00' and @__EndDate='99/99/99') set @FormCaption='<' + @__EndDate + '~' + @__StartDate +'>' SELECT AmountIn, AmountOut, Remain, Title FROM dbo.FunTarazSoodKol(@__StartDate, @__EndDate)