March 8, 2023 at 3:02 am
Table:SchoolTeacher
TeacherName Zip City State
------------ ---- ------ ------
Sam 12345 NJ NewYork
Pat 12345 NJ NewYork
Peter 12588 Spring MD
School:
SchoolLocationID Zip City State
-------------- ------- ----- -----
105 12345 NV NewYork
105 12345 NJ NewYork
106 12345 NJ NewYork
107 12588 Spring MD
BusinessRule:
1) Match should be done on Zipcodes if it matched then a single teacher assigned to only one schoollocation ID
and the remaining teacher cannot be assigned to same school locationID.
2) If Zipcodes doesn't match then do City match and if it is matched then assigned teacher to location ID then exclude the matched locationID for next teacher assignment.
Expected output:
TeacherName Zip City State SchoolLocationID
------------ ---- ------ ------ -------------
Sam 12345 NJ NewYork 105
Pat 12345 NJ NewYork 106
Peter 12588 Spring MD 107
Thank you for your help in advance !!
March 8, 2023 at 7:07 am
Some observations:
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
March 8, 2023 at 12:46 pm
I'm perfectly happy to help with homework.
Help.
So, where are you stuck? What have you tried that didn't work? Show me your work, and I'll be happy to toss in some pointers.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply