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 udfParseCommaListToTable(@sTransTypeCodes, ',') AS TranCodes
SELECT *
FROM Transactions
WHERE sTrans_Type_CD IN
(SELECT DataItems FROM TranCodes)
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people