| 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 |
Query for Insert And Select Data from Sql Severe Database
Hello Guys,
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
PnklPosted Aug 19, 2014, 3:12 AM
Understand that this table like Sql DB Table and When I Search then my where condition is ' Itemcode=243 and ContainerCode=ABC-05' then result will be come as
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
if you hv ans then reply me with exmpl
Thanks.....
Riddhi ValechaPosted Aug 18, 2014, 6:56 AM
Then in SQL Server, you will have to call a function.
Tirthak ShahPosted Aug 18, 2014, 4:16 AM