Skip to Content
0
Former Member
Apr 23, 2014 at 11:22 AM

Query Generator Parameter Problem

35 Views

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