Using JOIN for multi-value parameter pads comma delimited list with spaces

• fwremers

  Old Hand

  Points: 341

  More actions

  May 13, 2010 at 1:56 pm

  #232592

  My column is a char(10) but some of the values are less than 10. I've tried some string functions like RTRIM to my query but it doesn't like that. My query runs okay from the Data tab but when I go to Preview it complains.

  select RTRIM(status_code) from status_codes where delete_ind = 'N'

  I've also tried to use Replace but that doesn't seem to make much difference either. Has anyone else had this problem? If so, how did you work around it?

  <QueryParameter Name="@status">

  <Value>=JOIN(Parameters!status.Value,",")</Value>

  </QueryParameter>

  <QueryParameter Name="@status">

  <Value>=Replace(JOIN(Parameters!status.Value,",")," ","")</Value>

  </QueryParameter>

  Thanks,

  fwremers

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  May 13, 2010 at 3:52 pm

  #1167219

  You haven't said what happens when you use RTRIM...so I will guess that the lack of a column name is upsetting it...

  select RTRIM(status_code) AS status_code from status_codes where delete_ind = 'N'

  If that doesn't work, you could try

  select CONVERT(varchar(10),RTRIM(status_code)) AS status_code from status_codes where delete_ind = 'N'

  Don't forget to refresh the fields from the data tab as well.

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]