January 11, 2012 at 10:43 am
I was Grouping by City in a Report but the Column had Trailing spaces so I modified the Sp to Trim the spaces.
Is this the only option or are there other ways to handle this?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 11, 2012 at 11:33 am
This is something I would generally do in the SP when that option is available to me. However, you can also do it in the report using expressions. You can group on an expression that contains TRIM(YourColumnName) as well as make a similar expression for the display of the data.
January 11, 2012 at 11:36 am
Thanks!
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply