I want to say thank you to everybody that has contributed to this post expecially to ALZDBA unfortunately i can not use his solution, i want to thank mrpolecat his...

i mean ALZDBA's cursor solution does not work, i need another solution that works. I am sure many of us receive newsletters and we don't see other recipients email addresses....

If you read through from the beginning of the post you will understand that i did not say my proc did not work, the problem is I DON'T WANT OTHER...

Are you saying this procedure will work for me, i find it hard to grapple with. I am new to sql server.

I am sorry but it is not working.

It is not working, i tried to execute the procedure it won't still work.

I need to get this done, can somebody help please.

Thanks

You can have a look at my stored procedure.

CREATE PROCEDURE dbo.proc_happyBirthday2

AS

BEGIN

SET NOCOUNT ON

-- if you have more...