Hello arun.sas,

If changing the sample data as follows:

ID groupid days_remaining

1 89 16

2 96 ...

Hello pushpa.kumari,

thank you for your reply, but your solution doesn't work if I change sample data as follows:

ID groupid days_remaining

1 89 ...

How do I mark your post as "Answered"?

Thanks!

According to the Forum Etiquette[/url], hier is the DDL query:

IF IsNull(object_id('tempdb..#reminder'),0) 0

DROP TABLE #reminder;

GO

CREATE TABLE #reminder

(

...