>I wrote another UDF to convert a comma delimited list of string values to a table. When I call it, I get "Invalid object name 'TranCodes'". The error is occuring on the last query:
>
>
>
>DECLARE @sTransTypeCodes varchar(50)
>SET @sTransTypeCodes = 'PR,PD'
>
>
>
>SELECT *
> FROM Transactions
> WHERE sTrans_Type_CD IN
> (SELECT DataItems FROM TranCodes)
>
I prefer JOIN syntax :
SELECT *
FROM Transactions
INNER JOIN (SELECT DataItems FROM udfParseCommaListToTable(@sTransTypeCodes, ',') AS TranCodes
ON Transactions.sTrans_Type_CD = TranCodes.DataItems
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
