I have 4 columns in a sql table Offer.

```
id (PK auto increment), name , org , TourCode Varchar(MAX)

```

TourCode contains comma separated codes e.g (AVG123,JGH12 etc ).

I have 40000 TourCode available as comma separated values 

I have to write a query to insert 4000 rows in Offer table with each row containing 10 tour code separated by comma. 
For all the 4000 rows the value of name and org remains same e.g. "ABC" , "Amazon"

e.g.

```
DECLARE @TourCodes VARCHAR(4000);
SET @TourCodes =  'AVG123,JGH12,AVasfG123,JGsdfH12,AVsdgG123,JsdgGH12 , A34G123,J56gGH12, A34G1df23,JgfGH12 ,......'

Output:
╦══════════╦════════════╦═══════════════════╗
║ name     ║ org        ║TourCode           ║
╠══════════╬═══════════ ╬═══════════════════╣
║      ABC ║     Amazon ║AVG123,JGH12       ║
║      ABC ║     Amazon ║AVasfG123,JGsdfH12 ║
║      ABC ║     Amazon ║AVsdgG123,JsdgGH12 ║
║      ABC ║     Amazon ║A34G123,J56gGH12   ║
║      ABC ║     Amazon ║A34G1df23,JgfGH12  ║

```

What should be my best approach.

I am using SQL Server .
Thanks in advance.