Thank you.

Ok, i will have to re-write it for this sample data. I will do it but meanwhile anyother takers

actually, i tried but its not that simple as you say, thank you for the reponse.

grouping does not produce correct results in this case.

Ok, thank you for taking the time to answer.

Logic flows based on "Student Type" and "Color",

there are 4 types of possible "Student Type" and "Color" combinations.

1. asianbrown

2....

Attachment included, thank you

Sweet, thank you

Thank you. i will do it going forward

apologize for the formatting, attached a spreadsheet with good formatting

ok, here it goes again.

prod server name is example: PRODSQL1 with IP 10.20.30.40

dr server name is example: DRSQL1 with ip 10.20.30.50

Both exist and...

yes, the volume lables and the file system layout is going to be exactly the same.

thanks for the quick reply.

Yes it is going to be the default instance.

We are replicating everything. system/user database files.

i am not sure of what your solution is. What changes...