Query Parameter against a UDT
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!
Santiago Esteves replied
Hi, many thanks for responding. I want to do something like this
declare @code as nvarchar(15)
/* where T0.U_TGV_CODE_JURIS ='902'*/
set @code= /* T0.wtname */ '[%0]'