All is good. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] I solved it by inserting the list into a table and joining the prf table...
Hi Gaurav, You might have to work with me a bit here, I'm a bit of a neo at T-SQL. What is the code to get the list into the table? Thanks, Peter...
Hi Luis,<br /><br />Thanks for your response. @cBrandID will be any combinations of the numbers 1-5, in single quotes. So it could be just a '1' or a...
Didn't work. I tried:<br /><br />AND prf.Brand_id_int in (convert (int,@cBrandID))<br /><br />but still got this error:<br /><br />Syntax error...
Hello,<br /><br />I'm trying to pass a comma delimited list from a ColdFusion page to a stored procedure. <br /><br />I'm running the exec like...
Thanks to all who contributed to this thread.<br /><br />Most helpful! [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] [<img...
Hello,<br /><br />I'm trying add an if statement in a where clause but I'm getting an error:<br /><br />where<br />Pr.Submitted_Date_Time_dt >...
Separate names with a comma.
