AnnaJames77
asked on
Multiplevel parameter using Splitlist error
in my stored procedure i use splitlist. but for some multiple selections it gives result. but if clicks select all it gives error INVALID LENGTH PARAMETER PASSED TO LEFT or SUBSTRING FUNCTION.
and (itemgroupid in (SELECT FieldName FROM SplitList(@itemgroupid,',' )) and (salesoriginid in (SELECT FieldName FROM SplitList(@salesoriginid,' ,')) and (CustomerCode in (SELECT FieldName FROM SplitList(@Cust,','))
and (dimension2_ in (SELECT FieldName FROM SplitList(@CC,','))
and (dimension3_ in (SELECT FieldName FROM SplitList(@Purpose,','))
and (itemgroupid in (SELECT FieldName FROM SplitList(@itemgroupid,','
and (dimension2_ in (SELECT FieldName FROM SplitList(@CC,','))
and (dimension3_ in (SELECT FieldName FROM SplitList(@Purpose,','))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.