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/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_28074967.html#a39017396

If you can help with the update part,
much appreciated,
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
W.E.B

8/22/2022 - Mon
W.E.B

ASKER
Any help is appreciated.
ASKER CERTIFIED SOLUTION
Sharath S

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
W.E.B

ASKER
Hello,

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

Thanks,
Jim P.

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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
W.E.B

ASKER
ok,
it is updating some records but not the correct ones,
how do I see what has been updated?
Jim P.

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.
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,
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
W.E.B

ASKER
Thank youuuuuuu