I found the solution.

I had to change to:

declare @rows_deleted int

declare @rows_inserted int

declare @currSTRM varchar(4)

declare @TSQL varchar(8000)

set @currSTRM=(select OS_CURR_STRM from SIS.dbo.PS_OS_TERM_INFO_VW where ACAD_CAREER='GRAD')

--begin tran

-- Delete all rows from local table

--delete from...

Thanks for the information. Do you recommend I utilize cursors or a while statement to loop through and assign?

MMartin1 (2/25/2016)

---

This does make more sense. How do you handle situations when all professors are maxed out and can take no more assignments? Create a new professor? If you provide...

MMartin1 (2/25/2016)

---

I would still not mind knowing how this applies to a real world situation. Or are we just solving a fun programming problem? I read you that you want...

Steve Jones - SSC Editor (2/25/2016)

---

That doesn't make sense. Breeds or colors.

How do you decide that item A (Pitbull) becomes Item B (Boxer)? I am guessing you assume that the...

I appreciate everyone's help and patience.

To begin I have temp table that has all the data (the dummy canine table). The breed was previously assigned to each record. ...

This is dummy data. I can not post the actual production data. The idea is that if a certain value is in the table more than a certain number of...

Original data

AppIDBreedage

101Pitbull2

102Boxer4

103Pitbull1

104Pitbull5

105Boxer2

106Pitbull2

107Boxer8

108Pitbull1

109Pitbull3

110Boxer8

Expected output

AppIDBreedage

101Pitbull2

102Boxer4

103Pitbull1

104Pitbull5

105Boxer2

106Pitbull2

107Boxer8

108Pitbull1

109Boxer 3

110Boxer8

I am attempting to update the temp table not delete the records or insert new ones.

The age column is not important. Just need to find a way to level the groups out.

Thank you! I edited my original post and added the INSERT statements.

are you referring to the the insert statement for the data from the child_TBL and Health_TBL? I am using the select into #table.

example: SELECT App_ID, LEFT(Major, CHARINDEX('-', Major)-1) AS...

Thank you for all the assistance so far. I made some updates to my original post. I did have a syntax error from an extra comma that I removed.

I added the DDL statements to create tables. I apologize for not supplying all the needed information. I am new to this site but will make sure in the future...

I added the DML statements that I am using to insert into the temp tables.