insert - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

insert

Author

Topic

mana
Posting Yak Master

102 Posts

Posted - 2015-01-23 : 07:29:06

Hello

i have the following code and i want to insert the new data in
Reporting.dbo.Nacharbeitmanagement_From_AQISdatabase
from AQIs.dbo.v_Nacharbeits_Forcast
sometimes it works fine. but sometimes it will be more data than i expect inserted. can you help me please?
why the data will be insertd more than i expect?
thank you

insert into Reporting.dbo.Nacharbeitmanagement_From_AQISdatabase(Auftrag, Datum_Offline, Seriennummer, Benennung, Land, Letzter_Platz, AVG_RepZeit_Offen, AnzFehler_Offen,
AVG_RepZeit_Total, AnzFehler_Total)
SELECT a.* FROM
(SELECT Auftrag,Datum_Offline,Seriennummer,Benennung,Land,Letzter_Platz,round(AVG_RepZeit_Offen/60,0) as avg1,
AnzFehler_Offen,round(AVG_RepZeit_Total/60,0) as avg2,AnzFehler_Total
FROM AQIs.dbo.v_Nacharbeits_Forcast
) AS a
left outer JOIN Reporting.dbo.Nacharbeitmanagement_From_AQISdatabase b
ON a.Auftrag = b.Auftrag
WHERE b.Auftrag IS NULL

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-23 : 08:36:12

Perhaps your join predicates are not restrictive enough. Really, it's hard to tell from what you have posted. If you post some of your input data (from AQIs.dbo.v_Nacharbeits_Forcast and Reporting.dbo.Nacharbeitmanagement_From_AQISdatabase ), the rows you expect to be inserted and the rows that are actually inserted, it will be easier to analyze.

mana
Posting Yak Master

102 Posts

Posted - 2015-01-23 : 08:42:08

Hello

thank you for your responce
i didn't check exactly which data are different. i just realised that 1 row should be inserted but instead of one row 2 rows will be inserted and finally the number of rows in
Reporting.dbo.Nacharbeitmanagement_From_AQISdatabase
is more than AQIs.dbo.v_Nacharbeits_Forcast and i can't understand why it happens
can you help me pleasE?
i don't have another idea
Thank you

quote:
Originally posted by gbritton

Perhaps your join predicates are not restrictive enough. Really, it's hard to tell from what you have posted. If you post some of your input data (from AQIs.dbo.v_Nacharbeits_Forcast and Reporting.dbo.Nacharbeitmanagement_From_AQISdatabase ), the rows you expect to be inserted and the rows that are actually inserted, it will be easier to analyze.

mana
Posting Yak Master

102 Posts

Posted - 2015-01-23 : 13:38:49

Hello

do you know how i can delete the rows those i don'T need from the table that don't want to have them there.
thank you

quote:
Originally posted by gbritton

Perhaps your join predicates are not restrictive enough. Really, it's hard to tell from what you have posted. If you post some of your input data (from AQIs.dbo.v_Nacharbeits_Forcast and Reporting.dbo.Nacharbeitmanagement_From_AQISdatabase ), the rows you expect to be inserted and the rows that are actually inserted, it will be easier to analyze.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-23 : 15:35:00

I can't help without some of your data as I requested before

mana
Posting Yak Master

102 Posts

Posted - 2015-01-25 : 07:08:40

hello

here are the data that are inseted from AQIs.dbo.v_Nacharbeits_Forcast
to Reporting.dbo.Nacharbeitmanagement_From_AQISdatabase

i coudn't attach the file, can you tell me please where i can attach the excel file?

Auftrag Seriennummer Benennung Datum_Offline Land Letzter_Platz AnzFehler_Offen round_avgtotal AnzFehler_Total Offene_NA_Punkte Offene_Detail_Reifen_db priority KategorieProblemfzg BeschreibungProblemfzg bei uns geplannt am AVG_RepZeit_Offen
559461 ZFBP50133 SWB_GARU_T4 14-Jän-15 DEUTSCHLAND NACHARBEIT 8 4 15 ... ... 2 1
560303 ZEEV50022 APH_CVT_T4B 11-Dez-14 DEUTSCHLAND NACHARBEIT 18 13 52 ... ... 3
561221 ZFEP50001 SWB_CVT_T4B 13-Jän-15 FRANKREICH NACHARBEIT 30 17 57 ... ... 1 5
561228 ZFEP50002 SWB_GARU_T4B 21-Jän-15 FRANKREICH BV-05 31 7 35 ... ... 1 6
561544 ZFBP50338 SWB_CVT_T4 22-Jän-15 ITALIEN NACHARBEIT 2 2 8 ... ... 4 0
561545 ZFBP50356 SWB_CVT_T4 23-Jän-15 ITALIEN BV-05 11 2 17 ... ... 4 2
561787 ZEBP57845 SWB_GARU_T4 16-Dez-14 DEUTSCHLAND NACHARBEIT 5 2 10 ... ... 1
561910 ZFBP50259 SWB_GARU_T4 20-Jän-15 ITALIEN ROLLE-NACH 9 5 12 ... ... 4 3
561938 ZFBE50368 Maxxum/Profi_MED_T3 23-Jän-15 AUSTRALIEN ROLLE-NACH 4 1 8 ... ... 0
562025 ZEBV57743 APH_CVT_T4 11-Dez-14 DEUTSCHLAND NACHARBEIT 5 4 18 ... ... 1
562031 ZFBS50321 CCM_CVT_T4 21-Jän-15 DEUTSCHLAND BV-05 10 3 11 ... ... 2
562035 ZFBS50245 CCM_CVT_T4 20-Jän-15 FRANKREICH NACHARBEIT 10 3 17 ... ... 4 2
562037 ZFBS50002 CCM_CVT_T4 08-Jän-15 FRANKREICH NACHARBEIT 1 5 22 ... ... 4 1
562098 ZFBS50064 PUMA_GARU_T4 12-Jän-15 GROSSBRITANIEN NACHARBEIT 2 6 15 ... ... 4 0
562109 ZFBP50187 SWB_GARU_T4 15-Jän-15 FRANKREICH NACHARBEIT 1 2 9 ... ... 1 0
562110 ZFBE50288 Maxxum/Profi_MED_T3 21-Jän-15 AUSTRALIEN BV-05 15 5 21 ... ... 3
562119 ZFBF50206 APH_GARU_T4 16-Jän-15 OESTERREICH NACHARBEIT 3 4 16 ... ... 2 1
562121 ZFBE50362 APH_GARU_T4 23-Jän-15 BELGIEN NACHARBEIT 7 3 16 ... ... 4 0
562147 ZFBP50260 SWB_GARU_T4 20-Jän-15 SCHWEDEN CASE NACHARBEIT 3 2 12 ... ... 4 0
562156 ZFBS50123 CCM_CVT_T4 13-Jän-15 SCHWEDEN CASE NACHARBEIT 4 4 12 ... ... 4 1
562206 ZFBE50280 Maxxum/Profi_MED_T4 20-Jän-15 IRLAND NACHARBEIT 1 1 10 ... ... 2 0
562218 ZFBP50322 SWB_GARU_T4 22-Jän-15 IRLAND ROLLE-NACH 6 4 13 ... ... 4 2
562229 ZFBS50164 CCM_CVT_T4 15-Jän-15 ITALIEN NACHARBEIT 3 4 13 ... ... 4 3
562230 ZFBS50235 CCM_CVT_T4 19-Jän-15 ITALIEN ROLLE-NACH 8 2 11 ... ... 4 2
562241 ZFBP50198 SWB_GARU_T4 16-Jän-15 FINNLAND NACHARBEIT 1 4 17 ... ... 2 0
562245 ZFBP50122 SWB_GARU_T4 13-Jän-15 IRLAND NACHARBEIT 4 1 7 ... ... 2 0
562246 ZEBW57939 APH_CVT_T4 07-Jän-15 OESTERREICH NACHARBEIT 6 5 22 ... ... 4 1
562268 ZFBW50112 APH_CVT_T4 13-Jän-15 DEUTSCHLAND NACHARBEIT 2 4 14 ... ... 4 0
562273 ZFBT50158 CCM_CVT_T4 14-Jän-15 DEUTSCHLAND NACHARBEIT 2 4 20 ... ... 4 1
562274 ZFBT50120 CCM_CVT_T4 13-Jän-15 DEUTSCHLAND NACHARBEIT 5 3 17 ... ... 4 1
562276 ZFBT50088 CCM_CVT_T4 12-Jän-15 DEUTSCHLAND NACHARBEIT 19 4 20 ... ... 4 4
562277 ZFBP50255 SWB_GARU_T4 19-Jän-15 BELGIEN ROLLE-NACH 7 3 9 ... ... 4 2
562296 ZFBS50098 PUMA_GARU_T4 13-Jän-15 FRANKREICH NACHARBEIT 1 2 11 ... ... 4 0
562297 ZFBS50118 PUMA_GARU_T4 13-Jän-15 FRANKREICH NACHARBEIT 15 5 19 ... ... 4 3
562301 ZFBS50175 CCM_CVT_T4 15-Jän-15 FRANKREICH NACHARBEIT 6 4 14 ... ... 4 1
562304 ZFBS50261 CCM_CVT_T4 20-Jän-15 FRANKREICH NACHARBEIT 1 3 6 ... ... 4 0
562306 ZFBS50181 CCM_CVT_T4 15-Jän-15 FRANKREICH NACHARBEIT 2 4 5 ... ... 4 0
562309 ZFBS50217 PUMA_GARU_T4 16-Jän-15 FRANKREICH BV-05 16 3 20 ... ... 4 2
562310 ZEBV57825 APH_CVT_T4 16-Dez-14 DEUTSCHLAND NACHARBEIT 5 3 12 ... ... 1
562321 ZFBS50193 CCM_CVT_T4 15-Jän-15 DEUTSCHLAND NACHARBEIT 3 3 14 ... ... 4 1
562323 ZFBS50084 CCM_CVT_T4 12-Jän-15 DEUTSCHLAND NACHARBEIT 5 3 15 ... ... 3 1
562334 ZFBS50246 PUMA_GARU_T4 19-Jän-15 GROSSBRITANIEN ROLLE-NACH 10 3 12 ... ... 4 2
562335 ZFBS50290 PUMA_GARU_T4 21-Jän-15 GROSSBRITANIEN ROLLE-NACH 6 1 8 ... ... 4 1
562337 ZFBS50269 PUMA_GARU_T4 20-Jän-15 GROSSBRITANIEN ROLLE-NACH 7 1 10 ... ... 4 1
562338 ZFBS50220 PUMA_GARU_T4 19-Jän-15 GROSSBRITANIEN NACHARBEIT 7 4 15 ... ... 4 2
562339 ZFBS50250 PUMA_GARU_T4 19-Jän-15 GROSSBRITANIEN NACHARBEIT 5 1 8 ... ... 4 1
562340 ZFBS50289 PUMA_GARU_T4 21-Jän-15 GROSSBRITANIEN ROLLE-NACH 14 3 15 ... ... 4 3
562341 ZFBS50381 PUMA_GARU_T4 23-Jän-15 GROSSBRITANIEN ROLLE-VOR 6 1 9 ... ... 1
562342 ZFBS50201 CCM_CVT_T4 16-Jän-15 NIEDERLANDE NACHARBEIT 10 2 11 ... ... 4 2
562343 ZFBS50234 CCM_CVT_T4 19-Jän-15 NIEDERLANDE NACHARBEIT 3 3 13 ... ... 4 1
562348 ZFBP50279 SWB_GARU_T4 20-Jän-15 SPANIEN NH NACHARBEIT 5 2 9 ... ... 4 1
562349 ZFBP50315 SWB_GARU_T4 21-Jän-15 SPANIEN NH NACHARBEIT 10 3 15 ... ... 4 2
562351 ZFBP50212 SWB_CVT_T4 16-Jän-15 SPANIEN NH NACHARBEIT 1 1 7 ... ... 4 0
562352 ZFBP50249 SWB_CVT_T4 19-Jän-15 SPANIEN NH NACHARBEIT 1 3 15 ... ... 4 0
562360 ZFBE50355 Maxxum/Profi_MED_T4 22-Jän-15 GRIECHENLAND NACHARBEIT 3 4 10 ... ... 2 0
562361 ZFBP50372 SWB_GARU_T4 23-Jän-15 UNGARN ROLLE-NACH 3 1 8 ... ... 0
562362 ZFBS50309 PUMA_GARU_T4 21-Jän-15 UNGARN ROLLE-NACH 8 1 12 ... ... 2 1
562364 ZFBS50328 PUMA_GARU_T4 22-Jän-15 UNGARN ROLLE-NACH 10 2 13 ... ... 2 1
562368 ZFBP50129 SWB_CVT_T4 14-Jän-15 FINNLAND NACHARBEIT 6 8 19 ... ... 2 1
562369 ZFBP50317 SWB_CVT_T4 21-Jän-15 GROSSBRITANIEN ROLLE-NACH 11 2 15 ... ... 2 2
562371 ZFBE50302 Maxxum/Profi_MED_T4 21-Jän-15 GROSSBRITANIEN ROLLE-NACH 3 2 11 ... ... 2 1
562374 ZFBE50265 Maxxum/Profi_MED_T4 20-Jän-15 IRLAND NACHARBEIT 2 2 9 ... ... 4 0
562375 ZFBE50326 Maxxum/Profi_MED_T4 22-Jän-15 IRLAND ROLLE-NACH 7 2 12 ... ... 2 0
562378 ZFBP50211 SWB_GARU_T4 16-Jän-15 SPANIEN NH NACHARBEIT 3 3 12 ... ... 2 1
562379 ZFBS50237 CCM_CVT_T4 19-Jän-15 SPANIEN NH NACHARBEIT 5 2 13 ... ... 2 0
562400 ZFBP50268 SWB_CVT_T4 20-Jän-15 GROSSBRITANIEN NACHARBEIT 1 2 14 ... ... 2 0
562402 ZFBE50227 Maxxum/Profi_MED_T4 19-Jän-15 IRLAND NACHARBEIT 2 5 21 ... ... 2 0
562404 ZFBP50294 SWB_GARU_T4 21-Jän-15 IRLAND ROLLE-NACH 6 1 9 ... ... 2 1
562405 ZFBE50314 Maxxum/Profi_MED_T4 21-Jän-15 IRLAND ROLLE-NACH 3 1 8 ... ... 2 0
562406 ZFBE50337 Maxxum/Profi_MED_T4 22-Jän-15 IRLAND ROLLE-NACH 6 3 12 ... ... 2 1
562407 ZFBP50375 SWB_GARU_T4 23-Jän-15 GRIECHENLAND ROLLE-NACH 4 1 4 ... ... 2 1
562411 ZFBE50292 Maxxum/Profi_MED_T4 21-Jän-15 GROSSBRITANIEN ROLLE-NACH 5 4 11 ... ... 2 0
562415 ZFBH50252 PUMA_GARU_T3 19-Jän-15 AUSTRALIEN NACHARBEIT 1 2 10 ... ... 0
562416 ZFBH50325 PUMA_GARU_T3 22-Jän-15 AUSTRALIEN ROLLE-NACH 12 3 15 ... ... 0
562417 ZFBH50285 PUMA_GARU_T3 20-Jän-15 AUSTRALIEN NACHARBEIT 4 4 15 ... ... 0
562418 ZFBH50364 PUMA_GARU_T3 23-Jän-15 AUSTRALIEN ROLLE-NACH 8 1 11 ... ... 1
562426 ZFBP50258 SWB_CVT_T4 20-Jän-15 AUSTRALIEN NACHARBEIT 1 2 14 ... ... 0
562428 ZFBP50253 SWB_GARU_T4 19-Jän-15 FRANKREICH NACHARBEIT 1 4 9 ... ... 2 0
562430 ZFBP50281 SWB_GARU_T4 20-Jän-15 FRANKREICH NACHARBEIT 1 3 13 ... ... 3 0
562431 ZFBE50335 APH_GARU_T4 22-Jän-15 DEUTSCHLAND NACHARBEIT 3 1 8 ... ... 2 0
562435 ZFBS50256 CCM_CVT_T4 20-Jän-15 GROSSBRITANIEN ROLLE-NACH 8 2 14 ... ... 3 1
562437 ZFBE50343 Maxxum/Profi_MED_T4 22-Jän-15 UNGARN NACHARBEIT 1 3 12 ... ... 2 1
562449 ZFBE50275 Maxxum/Profi_MED_T4 20-Jän-15 N.ZELANDA BV-05 4 4 7 ... ... 1
562455 ZFBE50197 Maxxum/Profi_MED_T4 16-Jän-15 POLEN NACHARBEIT 3 3 6 ... ... 2 2
562456 ZEBS57940 CCM_CVT_T4 07-Jän-15 POLEN NACHARBEIT 1 8 28 ... ... 3 0
562459 ZFBE50323 APH_GARU_T4 22-Jän-15 GROSSBRITANIEN ROLLE-NACH 7 2 11 ... ... 2 1
562460 ZFBS50238 CCM_CVT_T4 19-Jän-15 GROSSBRITANIEN NACHARBEIT 1 3 18 ... ... 4 0
562461 ZFBS50242 CCM_CVT_T4 19-Jän-15 GROSSBRITANIEN ROLLE-NACH 12 2 15 ... ... 4 1
562462 ZFBS50283 CCM_CVT_T4 20-Jän-15 GROSSBRITANIEN ROLLE-NACH 11 3 15 ... ... 4 1
562463 ZFBS50296 CCM_CVT_T4 21-Jän-15 GROSSBRITANIEN ROLLE-NACH 13 2 16 ... ... 4 2
562466 ZFBE50349 Maxxum/Profi_MED_T3 22-Jän-15 AUSTRALIEN ROLLE-NACH 5 2 9 ... ... 1
562467 ZFBE50359 Maxxum/Profi_MED_T3 23-Jän-15 AUSTRALIEN NACHARBEIT 2 3 12 ... ... 0
562469 ZFBT50303 CCM_CVT_T4 21-Jän-15 OESTERREICH ROLLE-NACH 9 2 14 ... ... 1
562472 ZFBR50320 SWB_CVT_T4 21-Jän-15 OESTERREICH NACHARBEIT 2 2 17 ... ... 4 0
562473 ZFBS50241 CCM_CVT_T4 19-Jän-15 ISRAEL ROLLE-NACH 15 9 27 ... ... 2 2
562478 ZFBE50233 Maxxum/Profi_MED_T4 19-Jän-15 FRANKREICH NACHARBEIT 1 3 14 ... ... 3 0
562480 ZFBS50295 CCM_CVT_T4 21-Jän-15 NIEDERLANDE ROLLE-NACH 5 4 9 ... ... 4 1
562481 ZFBS50272 CCM_CVT_T4 20-Jän-15 NIEDERLANDE BV-05 8 2 36 ... ... 4 1
562492 ZFBV50282 APH_CVT_T4 20-Jän-15 DEUTSCHLAND NACHARBEIT 14 3 15 ... ... 4 1
562493 ZFBV50298 APH_CVT_T4 21-Jän-15 DEUTSCHLAND NACHARBEIT 2 1 8 ... ... 4 0
562494 ZFBV50308 APH_CVT_T4 21-Jän-15 DEUTSCHLAND NACHARBEIT 2 2 10 ... ... 4 0
562496 ZFBV50240 APH_CVT_T4 19-Jän-15 DEUTSCHLAND NACHARBEIT 1 2 8 ... ... 4 0
562497 ZFBV50254 APH_CVT_T4 19-Jän-15 DEUTSCHLAND NACHARBEIT 1 3 12 ... ... 4 0
562498 ZFBV50257 APH_CVT_T4 20-Jän-15 DEUTSCHLAND NACHARBEIT 1 2 15 ... ... 4 0
562499 ZFBV50236 APH_CVT_T4 19-Jän-15 DEUTSCHLAND NACHARBEIT 1 3 20 ... ... 4 0
562500 ZFBW50300 APH_CVT_T4 21-Jän-15 DEUTSCHLAND NACHARBEIT 2 3 17 ... ... 4 0
562502 ZFBW50311 APH_CVT_T4 21-Jän-15 DEUTSCHLAND NACHARBEIT 2 2 13 ... ... 4 0
562503 ZFBW50332 APH_CVT_T4 22-Jän-15 DEUTSCHLAND NACHARBEIT 4 2 14 ... ... 4 0
562504 ZFBW50347 APH_CVT_T4 22-Jän-15 DEUTSCHLAND BV-05 9 2 12 ... ... 4 2
562505 ZFBW50351 APH_CVT_T4 22-Jän-15 DEUTSCHLAND NACHARBEIT 4 1 11 ... ... 4 0
562506 ZFBS50244 CCM_CVT_T4 19-Jän-15 DEUTSCHLAND ROLLE-NACH 11 3 14 ... ... 4 2
562507 ZFBS50277 CCM_CVT_T4 20-Jän-15 DEUTSCHLAND ROLLE-NACH 2 1 7 ... ... 4 0
562508 ZFBS50264 CCM_CVT_T4 20-Jän-15 DEUTSCHLAND BV-05 6 1 7 ... ... 4 1
562509 ZFBS50327 CCM_CVT_T4 22-Jän-15 DEUTSCHLAND ROLLE-NACH 9 2 11 ... ... 4 2
562512 ZFBP50286 SWB_CVT_T4 20-Jän-15 FRANKREICH ROLLE-NACH 6 2 9 ... ... 2 1
562513 ZFBP50318 SWB_CVT_T4 21-Jän-15 FRANKREICH NACHARBEIT 2 2 11 ... ... 4 0
562514 ZFBP50306 SWB_CVT_T4 21-Jän-15 FRANKREICH NACHARBEIT 8 3 14 ... ... 4 1
562515 ZFBP50324 SWB_CVT_T4 22-Jän-15 FRANKREICH NACHARBEIT 4 4 16 ... ... 4 0
562516 ZFBP50336 SWB_CVT_T4 22-Jän-15 FRANKREICH NACHARBEIT 2 2 10 ... ... 4 0
562517 ZFBP50342 SWB_CVT_T4 22-Jän-15 FRANKREICH NACHARBEIT 2 1 11 ... ... 4 0
562518 ZFBP50365 SWB_CVT_T4 23-Jän-15 FRANKREICH ROLLE-NACH 3 1 8 ... ... 4 1
562520 ZFBP50369 SWB_CVT_T4 23-Jän-15 FRANKREICH ROLLE-NACH 1 1 5 ... ... 4 0
562527 ZFBS50266 CCM_CVT_T4 20-Jän-15 FRANKREICH ROLLE-NACH 5 1 8 ... ... 4 0
562528 ZFBS50270 CCM_CVT_T4 20-Jän-15 FRANKREICH ROLLE-NACH 10 3 11 ... ... 4 3
562529 ZFBS50273 CCM_CVT_T4 20-Jän-15 FRANKREICH NACHARBEIT 7 2 9 ... ... 4 1
562530 ZFBS50310 CCM_CVT_T4 21-Jän-15 FRANKREICH ROLLE-NACH 14 2 14 ... ... 4 2
562531 ZFBS50312 CCM_CVT_T4 21-Jän-15 FRANKREICH ROLLE-NACH 6 1 11 ... ... 4 1
562532 ZFBS50287 CCM_CVT_T4 20-Jän-15 FRANKREICH ROLLE-NACH 8 2 11 ... ... 4 1
562533 ZFBS50331 CCM_CVT_T4 22-Jän-15 FRANKREICH ROLLE-NACH 10 3 15 ... ... 2 2
562534 ZFBS50330 CCM_CVT_T4 22-Jän-15 FRANKREICH ROLLE-NACH 4 1 5 ... ... 4 0
562539 ZFBP50354 SWB_CVT_T4 22-Jän-15 DEUTSCHLAND ROLLE-NACH 4 1 8 ... ... 4 1
562540 ZFBS50297 CCM_CVT_T4 21-Jän-15 SPANIEN NH ROLLE-NACH 9 2 15 ... ... 4 1
562541 ZFBS50301 CCM_CVT_T4 21-Jän-15 SPANIEN NH ROLLE-NACH 7 1 10 ... ... 4 1
562542 ZFBS50305 CCM_CVT_T4 21-Jän-15 SPANIEN NH ROLLE-NACH 11 2 19 ... ... 4 2
562543 ZFBS50307 CCM_CVT_T4 21-Jän-15 SPANIEN NH NACHARBEIT 8 2 12 ... ... 4 0
562544 ZFBS50350 CCM_CVT_T4 22-Jän-15 SCHWEDEN CASE ROLLE-NACH 10 1 11 ... ... 3 1
562545 ZFBV50267 APH_CVT_T4 20-Jän-15 SCHWEDEN CASE ROLLE-NACH 6 2 9 ... ... 3 1
562546 ZFBV50339 APH_CVT_T4 22-Jän-15 SCHWEDEN CASE ROLLE-NACH 6 1 7 ... ... 3 0
562547 ZFBE50247 APH_GARU_T4 19-Jän-15 DEUTSCHLAND NACHARBEIT 1 3 13 ... ... 2 0
562548 ZFBS50333 CCM_CVT_T4 22-Jän-15 SCHWEDEN CASE ROLLE-NACH 10 2 14 ... ... 2 2
562552 ZFBV50284 APH_CVT_T4 20-Jän-15 SPANIEN NH NACHARBEIT 1 2 13 ... ... 2 0
562554 ZFBS50352 PUMA_GARU_T4 22-Jän-15 POLEN NACHARBEIT 3 2 12 ... ... 3 0
562559 ZFBS50348 CCM_CVT_T4 22-Jän-15 LITAUEN ROLLE-NACH 18 5 29 ... ... 2 4
562563 ZFBV50304 APH_CVT_T4 21-Jän-15 FRANKREICH NACHARBEIT 1 3 18 ... ... 3 0
562565 ZFBE50319 Maxxum/Profi_MED_T4 21-Jän-15 FINNLAND ROLLE-NACH 6 2 11 ... ... 2 1
562566 ZFBE50377 Maxxum/Profi_MED_T4 23-Jän-15 GROSSBRITANIEN ROLLE-NACH 6 3 11 ... ... 2 1
562569 ZFBP50313 SWB_GARU_T4 21-Jän-15 SPANIEN NH NACHARBEIT 1 1 8 ... ... 3 0
562570 ZFBH50334 CCM_CVT_T3 22-Jän-15 AUSTRALIEN ROLLE-NACH 15 6 23 ... ... 4
562581 ZFBW50271 APH_CVT_T4 20-Jän-15 OESTERREICH NACHARBEIT 5 2 14 ... ... 1 1
562582 ZFBW50263 APH_CVT_T4 20-Jän-15 OESTERREICH NACHARBEIT 3 4 13 ... ... 2 1
562583 ZFBS50341 CCM_CVT_T4 22-Jän-15 LITAUEN BV-05 22 5 25 ... ... 2 5
562584 ZFBP50329 SWB_GARU_T4 22-Jän-15 LITAUEN BV-05 15 3 19 ... ... 2 3
562588 ZFBP50360 SWB_GARU_T4 23-Jän-15 SCHWEDEN CASE ROLLE-NACH 18 5 24 ... ... 2 4
562589 ZFBE50380 Maxxum/Profi_MED_T4 23-Jän-15 ITALIEN ROLLE-NACH 3 1 5 ... ... 1 1
562593 ZFBE50276 APH_GARU_T4 20-Jän-15 POLEN NACHARBEIT 3 3 9 ... ... 3 0
562596 ZFBS50373 CCM_CVT_T4 23-Jän-15 GROSSBRITANIEN ROLLE-NACH 12 2 15 ... ... 2 2
562598 ZFBS50345 CCM_CVT_T4 22-Jän-15 TUERKEI ROLLE-NACH 9 1 11 ... ... 2
562599 ZFBS50340 CCM_CVT_T4 22-Jän-15 TUERKEI ROLLE-NACH 12 3 17 ... ... 3
562600 ZFBE50230 Maxxum/Profi_MED_T4 19-Jän-15 FRANKREICH ROLLE-NACH 2 8 22 ... ... 3 0
562603 ZFBP50262 SWB_CVT_T4 20-Jän-15 POLEN NACHARBEIT 1 3 7 ... ... 3 0
562605 ZFBR50274 SWB_CVT_T4 20-Jän-15 POLEN NACHARBEIT 2 3 15 ... ... 3 0
562606 ZFBT50353 CCM_CVT_T4 22-Jän-15 POLEN BV-05 11 2 12 ... ... 3 2
562609 ZFBV50371 APH_CVT_T4 23-Jän-15 ITALIEN ROLLE-VOR 3 0 4 ... ... 4 0
562610 ZFBS50358 CCM_CVT_T4 23-Jän-15 ITALIEN ROLLE-NACH 10 5 14 ... ... 1 3
562611 ZFBS50370 CCM_CVT_T4 23-Jän-15 ITALIEN ROLLE-NACH 7 1 12 ... ... 4 1
562630 ZFBT50367 CCM_CVT_T4 23-Jän-15 DEUTSCHLAND ROLLE-NACH 5 2 13 ... ... 4 1
562631 ZFBT50378 CCM_CVT_T4 23-Jän-15 DEUTSCHLAND ROLLE-NACH 6 1 7 ... ... 4 1
562633 ZFBV50376 APH_CVT_T4 23-Jän-15 DEUTSCHLAND ROLLE-NACH 3 1 5 ... ... 4 0
562654 ZFBV50357 APH_CVT_T4 23-Jän-15 FRANKREICH BV-05 4 1 14 ... ... 2 0
562655 ZFBV50379 APH_CVT_T4 23-Jän-15 DEUTSCHLAND ROLLE-NACH 4 4 10 ... ... 1
562664 ZFBS50366 CCM_CVT_T4 23-Jän-15 DEUTSCHLAND ROLLE-NACH 4 1 9 ... ... 1
562680 ZFBF50374 Maxxum/Profi_MED_T4 23-Jän-15 DEUTSCHLAND ROLLE-NACH 6 3 11 ... ... 2 2
562699 ZFBS50361 PUMA_GARU_T4 23-Jän-15 SPANIEN NH ROLLE-NACH 8 1 11 ... ... 3 1
562704 ZFBP50344 SWB_GARU_T4 22-Jän-15 LITAUEN ROLLE-NACH 5 4 8 ... ... 2 1
562710 ZFSJ01013 APL_32X32 14-Jän-15 OESTERREICH NACHARBEIT 3 6 23 ... ... 4 0
562711 ZFSJ01007 APL_32X32 12-Jän-15 OESTERREICH NACHARBEIT 23 9 32 ... ... 4 5
562716 ZFBP50363 SWB_GARU_T4 23-Jän-15 LITAUEN ROLLE-NACH 6 2 12 ... ... 1
562732 ZFBS50291 CCM_CVT_T4 21-Jän-15 GROSSBRITANIEN ROLLE-NACH 8 1 9 ... ... 4 1
562733 ZFBS50293 CCM_CVT_T4 21-Jän-15 GROSSBRITANIEN ROLLE-NACH 11 3 14 ... ... 4 1
562734 ZFBS50299 CCM_CVT_T4 21-Jän-15 GROSSBRITANIEN ROLLE-NACH 11 2 18 ... ... 4 1
562737 ZFBP50248 SWB_CVT_T4 19-Jän-15 GROSSBRITANIEN NACHARBEIT 4 0 8 ... ... 4 0
562738 ZFBP50278 SWB_CVT_T4 20-Jän-15 GROSSBRITANIEN ROLLE-NACH 6 0 6 ... ... 4 0
562742 ZFBS50346 CCM_CVT_T4 22-Jän-15 IRLAND ROLLE-NACH 12 2 14 ... ... 2
562760 ZFSH01011 APL_32X32 14-Jän-15 N.ZELANDA NACHARBEIT 1 8 21 ... ... 0
562762 ZFSH01017 APL_32X32 16-Jän-15 N.ZELANDA NACHARBEIT 4 3 17 ... ... 1
562763 ZFSH01019 APL_32X32 19-Jän-15 N.ZELANDA NACHARBEIT 7 7 23 ... ... 2
562783 ZFSH01014 APL_32X32 15-Jän-15 FRANKREICH NACHARBEIT 6 5 23 ... ... 3 1
562811 ZFSJ01021 APL_32X32 20-Jän-15 OESTERREICH NACHARBEIT 5 4 23 ... ... 4 1
562857 ZFSH01020 APL_32X32 19-Jän-15 BELGIEN NACHARBEIT 12 4 15 ... ... 4 3
562893 ZFSJ01018 APL_32X32 16-Jän-15 DEUTSCHLAND NACHARBEIT 5 2 12 ... ... 2 1
562896 ZFSJ01028 APL_32X32 22-Jän-15 DEUTSCHLAND ROLLE-MAN 12 3 17 ... ... 4 3
562897 ZFSH01022 APL_32X32 20-Jän-15 DEUTSCHLAND NACHARBEIT 5 3 19 ... ... 2 1
563041 ZFSH01029 APL_32X32 22-Jän-15 ITALIEN BV-05 8 2 11 ... ... 1 1
563063 ZFSH01030 APL_32X32 23-Jän-15 DAENEMARK NH BV-05 20 5 26 ... ... 4 4
563195 ZFSJ01031 APL_32X32 23-Jän-15 OESTERREICH ROLLE-NACH 7 2 8 ... ... 2 2

quote:
Originally posted by gbritton

I can't help without some of your data as I requested before

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-25 : 10:01:19

OK .. is that the data that should be inserted or is it more than should be inserted? If more, which specific rows in your sample should NOT have been inserted.

BTW, the best way to post data like yours is as follows:
1. CREATE TABLE statement
2. INSERT INTO statements

That makes it easy for others to recreate your situation.

mana
Posting Yak Master

102 Posts

Posted - 2015-01-26 : 04:03:32

hello

it is more than should be inserted
i know it just from the number of rows those should be inserted
for example 197 Auftrag should be inserted but instead of 197 , 200 Auftrag will be inserted
Can you help me pleasE?

quote:
Originally posted by gbritton

OK .. is that the data that should be inserted or is it more than should be inserted? If more, which specific rows in your sample should NOT have been inserted.

BTW, the best way to post data like yours is as follows:
1. CREATE TABLE statement
2. INSERT INTO statements

That makes it easy for others to recreate your situation.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-26 : 09:58:22

I cannot do much unless you post samples of your input data that results in the incorrect number of rows being inserted.

BTW, the best way to post data like yours is as follows:
1. CREATE TABLE statement
2. INSERT INTO statements

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources