Hi Howard,

I tried it but my enumerator configuration is empty. could it be because I don't hav a full version of visual studio installed?

Thanks Howard, i'm on it will let you know how it goes

Sorted, thanks guys

Hi,

Can I use it to get Min date as well?

That's the magic right there Howard thank you very much. It worked.

Hi,

when I include the app_status field in my select statement then in return all the status for that app_id, while I'm only looking for the status related to the max...

Thanks guys but what if I have two variables

Thank Susan, that works like magic

Hi Guys

thanks for the feedback.

The data in my table is as follows

ScenarioIDStartTimeStaffingRequirementActiveStaff

1 2009/12/27 00:00 ...

Thanks member will let you know how it goes

Guys thank you very much for your help. I chose to go with Ronalds cursor for one simple reason:

when I ran your one cold coffee the target table was not...

Thanks guys I'm already putting it to ractice will let you know how it goes

Thank you very much Ronald that's exactly what I was looking for.

Hi Guys

Thanks for the suggestions here's what I've been trying, please tell me what is wrong with the alter statementdrop table #part

declare @Column_Name Varchar(Max)

declare @Data_Type Varchar(Max)

declare @RowNum int

create table #PART...

Hi thanks for the feedback, I totaly agree with you but the problem is that changes to the tables are done by a different team from a production side and...