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