You might want to have a look at Jeff's "Running Total" article. You'll find several solutions including a comparison. Depending on the number of rows you're dealing with...

How does this statement match with your first post?

Please...

A TRY ...CATCH block might help.

It's more than unlikely to get those values, since there are several ways to assign a default value to a parameter (e.g. as part of the CREATE PROCEDURE statement, using...

Without seeing your table defs and a description of your business case it's hard to tell...

There are several versions around how to deal with such a scenario. Some are better...

You should add the following two options to import unicode data:

CODEPAGE = 'RAW'

DATAFILETYPE = 'widechar'

That should help you to import your Swedish character (as long as the...

You need to be careful with DATEPART(wk,...) since it depends on the setting of DATEFIRST. Furthermore, it always starts with...

Please havea look at ROW_NUMBER(). Use it with 'phone_number' ordered desc and select the results with rwn=1.

[sarcasm ON] Since you marked it as "urgent" I replied the fastest way I...

You're very welcome 😀

Sorry for answering late...

A great resource is Jacob Sebastian's blog.

And, if you don't find the answer there: post your question here on SSC. I've learned a lot and I'm...

You might find an answer by searching Jacob Seabstian's blog.

If not, please post a (fake) sample of your current data nd your expected result.

We might be able to help...

The problem is you're updating all rows with your first statement, since there is no WHERE condition that would limit the number of rows affected.

Another option to get the result...

Hi Wayne,

here's what I came up with (side note: I added an ID column to your original table to keep the order the data were inserted):

;WITH CTE AS

(

SELECT p_or_l,...

I'm not sure if this is the best place to ask for issues with a 3rd party product...

You should check a website/forum related to that software.

You might consider using GETUTCDATE() instead.

But you need to take care of the different time zone you're in.