Is it possible to pass a table column value as a parameter for my User Defined function Coz mine doesnt work.
here's the function:
CREATE function [dbo].ufn_GetRefRange
(@RefType varchar(200)
, @RefValueFrom varchar(200)
, @RefValueTo varchar(200))
returns @tblRefRange table (RefValue varchar(200))
as
begin
Insert @tblRefRange(RefValue)
Select RefValue
from [dbo].tbl_Reference tr1
where rtrim(ltrim(RefType)) = rtrim(ltrim(@RefType))
and [Order] between
(select [order] from tbl_reference tr2
where rtrim(ltrim(tr1.RefType)) = rtrim(ltrim(tr2.RefType))
and RefValue = @RefValueFrom)
and
(select [order] from tbl_reference tr3
where rtrim(ltrim(tr1.RefType)) = rtrim(ltrim(tr3.RefType))
and RefValue = @RefValueTo)
order by [order]
return
end
here's how i call it. it returns a syntax error
Select top 500 * from [dbo].tbl_pds tpd
where (Select top 1 MktSeg from tbl_CDs where AcctNo = rtrim(ltrim('10200')))
-- in (select RefValue from ufn_GetRefRange(''MktgSeg'',tpd.MktgSegFrom,tpd.MktgSegTo))
but it works when i use this
-- in (select RefValue from ufn_GetRefRange(''MktgSeg'','A1','A3'))
Pls help thanks