September 7, 2011 at 9:54 am
So i have a report currently running that for some reason if i hit select all its not getting any results back from the stored proc. HOWEVER, if i go in and individualy pick the values i know i need then the results will come back. Obviously this is not how it should work. I've had this problem in the past where i just did a trim on the values that are being used from the dropdown that are being passed into the main stored proc.
I even tried this on a small scale where a value i had on the very end had a trailing space and nothing got returned and when i took out the space, i got the values i expected to get.
My problem is that i put in an RTRIM on the proc to take off the trailing spaces and i still get no results when selecting all.
Should i be impleminting a LTRIM along with the RTRIM to get the results? or is there some other issue here i'm missing?
September 7, 2011 at 11:56 am
Alright, well i tried putting the LTRIM on there as well and that didn't make a difference. So what could be causing this to happen? The parameter is declared as a varchar(max) and then i use a parse function to put that CSV list into a table then join that table on the main proc to only select those that are chosen. Would there be some reason why its not doing this correctly?
September 7, 2011 at 11:59 am
Nevermind, i figured it out. There's a problem with my parse function! Whoops!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply