Thank you for your suggestion! You stated the following, "You can then insert all of your current items within a frame, which is grouped on a client. Then set...

The insert statements are on my original post. The example I showed you is an example of what I want the output to look like. Would you give me an...

I provided the ddl on the original post. here is sample data:

SELECT [lockID] = 4336

,[schoolID] = 134

,[serialNumber]...

This not the third time I asked a question. In this question, I found out what the issue is and I want to find a resolution.

I like your idea of using the output clause from the insert statement. However, I will still have the same problem of trying to obtain the unique lockid value and...

I used this loop since I was trying to determine how to solve my problem.

Here are ddls of a few tables you wanted to see. I want each row in the locker table to have a unique value contained in the last 506 records...

Since the data is duplicated for each school per school year, you are just saying that I should create duplicate rows for the previous school year and change the schoolid,...

The school year is used. These 3 tables are joined to the following tables to determine what the school year is.

Note: I did not list the following 2 tables...

I have this school years data and I am making a copy of it for the previous school year. Basically the schoolid for this current school year changed from last...

This is only a one time update. I am sorry I did not mention that earlier. I basically just need to place existing data into the tables for the...

I tried this and this does not help.

What other sql options are you thinking that would work?

I did not include all my question since I was trying to determine what was wrong with my original sql. I...

would you show me the sql for the statement that you made:

'If you alias both tables (in the outer query and in the inner query), you can easily join them...

What other data type would you recommend? That is large but not as large as varchar(max) is?