Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dev@nlkss
134 Posts |
 Posted - 2009-03-30 : 02:50:32
|
| Hi All,In my procedure i accept a multi value parameter and which is used with IN operator.This parameter is compared with "Int" datatype column.but When i execute from report am getting error as conversion failed. I dont know what datatype to be declared for report parameter and SP parameter.Thanks in advance.$atya.Love All Serve All. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-31 : 13:20:05
|
| you should use varchar for parameter.also use where ','+@parameter + ',' like '%,' + cast(intcolumn as varchar(10)) + ',%'as filter rather than in |
 |
|
|
|
|
|
SSRS Multi Value Parameter