Hello All:
Normally when you do paramter like
/*select from OINV t0*/ declare @docdate as datetime /* where */ set @docdate = /* t0.docdate */ '[%0]' select @docdate
But I have tried to use a parameter against UDT instead of SBO native table.. I am not sure if this is doable...Has anyone done something like this before?
/*select from dbo.[@JP_WHSPSR] t0*/ declare @wareperson as nvarchar(50) /* where */ set @wareperson = /* t0.Name */ N'[%0]' select @wareperson
Anyone can help I greatly appreciate it!