Skip to Content
0
Former Member
Sep 11, 2008 at 07:05 AM

Query Parameter against a UDT

142 Views

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!