Link to home
Start Free TrialLog in
Avatar of W.E.B
W.E.B

asked on

SQL 2008 Update

Hello,
can you please help,
please refer to my initial question.

https://www.experts-exchange.com/questions/28074967/SQL-2008-Dates.html?anchorAnswerId=39017396#a39017396

If you can help with the update part,
much appreciated,
Avatar of W.E.B
W.E.B

ASKER

Any help is appreciated.
ASKER CERTIFIED SOLUTION
Avatar of Sharath S
Sharath S
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of W.E.B

ASKER

Hello,

I get error
Warning: Null value is eliminated by an aggregate or other SET operation.

Thanks,
Warning: Null value is eliminated by an aggregate or other SET operation

If you are getting the results you expect, ignore them.  That is basically saying you didn't put in IsNull statements to account for blank rows.
Avatar of W.E.B

ASKER

ok,
it is updating some records but not the correct ones,
how do I see what has been updated?
You should be able to just delete the update statement and run it to see what results you are getting.

From there work backwards to correct the query.
Avatar of W.E.B

ASKER

Hello,
it is not updating,
here are sample results before and after I run the update. (same results)

WaybillNumber      scanin      new_scanin      new_scanin_str      row_ref      ScanInMax
0469187001       NULL       NULL               NULL                            1      NULL
0480882001       NULL      NULL               NULL                            2      NULL
0490733001       NULL      NULL               NULL                            3      NULL
0490733002       NULL      NULL               NULL                            4      NULL
0490733003       NULL      NULL               NULL                            5      NULL
0490733004       NULL      NULL               NULL                            6      NULL
0490733005       NULL      NULL               NULL                            7      NULL
0490733006       NULL      NULL              NULL                            8      NULL

thanks,
Avatar of W.E.B

ASKER

Thank youuuuuuu