Skip to Content
0
Former Member
Nov 09, 2012 at 11:20 AM

parameters for Views in Query generator

379 Views

Dear All,

Is it possible to give the parameters for views in Query genrator like [%0].

Example:-

declare @date datetime

declare @date1 datetime

set @date = (select docdate from oinm A where A.docdate = '[%0]' group by DocDate )

set @date1 = (select docdate from oinm A where A.docdate = '[%1]' group by DocDate)

select * from [Day-wise Cumlative of STK In - STK Out]

where Dates>= @date and Dates<= @date1

order by Dates

reagrds,

Shyam