Hi Expert ,
I'm using below query to display only customer code for parameter selection but its displaying Vendor code too.
Kindly guide me.
Declare @Fromdate Datetime
Declare @frmcode nvarchar(max)
Declare @Tocode nvarchar(max)
set @Fromdate = (select MAX(T12.RefDate) From JDT1 T12 where T12.RefDate <= '[%0]')
set @frmcode = (select MIN(T13.cardcode) From ocrd t13 where t13.CardType='c' and T13.cardcode >= '[%1]')
set @Tocode = (select MAX(t14.cardcode) From ocrd t14 where t14.CardType='c' and T14.cardcode <= '[%2]')
Thanks
-Rajesh N