Thanks so much - works great!!

Having trouble to leave a response .... sorry for being late.

Happy being a part of this community!!:-)

OMG - thanks so much - I will try, looks pretty good.

OMG - thanks! I will give it a try and let you know.

Thanks so much for your time!

OMG - wow, thanks. I will give it a try and let you know.

Again, thanks

OMG - wow, thanks. I will give it a try and let you know.

Again, thanks

OMG - thanks. I will give it a try and let you know.

again, thanks so much!!

OMG - thanks. I will give it a try and let you know.

again, thanks so much!!

Lynn,

yes - exactly!

The period field in the table always contain the last day of a months - it's never like 6/24/2009 always 6/30/2009,

never 5/4/2008 always 5/31/2008 etc.

Thanks so...

Already, let me know if this makes better senses now:

A user selects a date, example 6/30/2009 - from this date I need to calucate 12 sums, as follows:

Sum1 = values...

Here my code ... hope it makes sense ... THANKS

_______________

@BaseDate & @period are parameters set in the beginning of the proc ...

/***** Calculate 12 months rolling wrvu's 12 months...

Thanks for your response - unfortunately it doesn't work for me - it returns all dates with 6/30 no matter what year.

I'll keep looking ...

yeah - got it, looks in visual studio I can't do spaces

'Field' = "NEW" - doens't work

but

'Field'="NEW' works

I am so used using spaces in my old sql analyzer.

Thanks for...

Thanks for the respsonse - did try SWITCH with the same result ... First value is returned correctly, else always the last value in the statement- the two in between...

My problem here - I am trying to label my status group as follows,

Reporting Services / Visual Studio only returns the first true value = "New Provider" for all...