Yes it works fine. Thanks a lot Cheers

thanks a lot for that. it works well except for the part where it shows month as 13 for january and 14 for febraury and so on. it wud be...

slight correction. it should return for the current year + 1 and not for any input parameter .

example current year is 2009, so it should return a list like...

slight correction. it should return for the current year + 1 and not for any input parameter .

example current year is 2009, so it should return a list like...

slight correction. it should return for the current year + 1 and not for any input parameter .

example current year is 2009, so it should return a list like...

My problem is something along this lines. . I want a stored procedures that

1) takes input as year. returns a list of last ten years including input year +1

example, input...

Ok thanks a lot for sharing. Thanks again for your time.

Thanks a ton for your time brother !!

Last thing, I want the Nickname to be inserted as well into the profiles_display table. How can i do tht..

Thank a lot guys for your replies, but got some problems

Bru, the number of institutions won't change anytime sooner but new profiles will be added. Your solution doesn't work when...

SQL SERVER 2005. Can someone show me how to do it ..Thanks