Hello I want to insert for same ID multiple values in a table.
For example:
STOCKID Serial
HP 1234232
STOCKID Serial
HP 3325235
STOCKID Serial
HP 3325235
What I have tried:
SELECT TOP (1000) [ID] >>PRIMARY KEY Auto increment
,[URUNID] >>
,[MODELID]
,[URUNSERINO]
,[SERIPROBLEM]
FROM [Stok-Kargo_Takip].[dbo].[SERI_NO_TABLO]
INSERT INTO SERI_NO_TABLO(URUNID,MODELID,URUNSERINO,SERIPROBLEM)
VALUES (@URUNID,@MODEL,@SERIAL,@SERIPROBLEM)
ID URUNID MODELID PROBLEM
1 PDA_MC9190 MC-9190 323464343 fmsdmfofodsfsd
2 PDA_MC9190 MC-9190 6364643643 amsokasndosando
3 PDA_MC9190 MC-9190 63464643 knfjdsnfjdsnfjdsn
I just want to see this result, when I insert from 3 textboxes for serials and 3 textboxes for problem explain with button click at the same time.
I tried with while loop but it goes to endless loop. I hope somebody can help me. Thank you