Query for Insert And Select Data from Sql Severe Database

Question

Hello Guys,

 

Container Code	BOX No	Item Code
ABC-05	225/1	1, 5, 6, 7, 9, 10, 11, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40,41, 42, 43, 44, 45, 51, 52, 53, 54, 55, 56, 231, 232, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244
ABC-05	225/2	58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85,86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109,110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130,131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151,152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165
ABC-05	226/1	449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 492, 493, 494, 495, 496, 497

 

I want to store data in this manner in Sql Server Database and don’t duplication ‘Item code’ under one ‘Container Code’

How to checking this item code already exist or not in same container code and

How to select ‘container code’, ’Box No’ from one Item Code

So Guys you can help me how to implement this in sql server Or in C#.net