Hi again, Phil.

You're right, of course. These tables were not under my control when they were created. I then worked for a different company. I can consider this setup a...

Hi Phil.

Many thanks for coming back on this. It drives me crazy...

It happens at least in VS 2019 and 2020, which I've checked. I have several tables with such an...

Hi there. Good article... but please, please, please, when you write SQL and alias tables, as it should be, also alias the columns used! It's absolutely frustrating and highly unhelpful...

You have to serialize the access to both tables at the same time, then get your max, do what you need and then commit the transaction letting others access it....

Please don't create questions in such a way that from one question one can deduce the correct answer(s) to the others. Thanks.

Please don't create questions in such a way that from one question one can deduce the correct answer(s) to the others. Thanks.

I know it's an old thread but... Let me tell you this: if a table is clustered, then it's enough to DISABLE the cluster. Nobody will be able to access...

Well, that doesn't solve the problem, to be honest. Even If I import the data to a staging table, it's still in the form of a.aaa+eAA, and there is no...

Mate, that won't work. Through BIDS Helper all you can change is a variable's NAMESPACE, not SCOPE.

Well, I have found the solution. In short:

[SqlFunction(IsDeterministic = true, Name = "ufn_RunningTotalForDecimal")]

[return: Microsoft.SqlServer.Server.SqlFacet(Precision = 18, Scale = 2)]

...

Hi there. Well, it works for the parameters but it doesn't for the outcome, which is marked as illegal when I try to decorate it with the facet... Any other...

Hi. I don't know if I get it right but I have read here

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx

and here

http://blogs.msdn.com/sqlcat/archive/2007/02/01/previously-committed-rows-might-be-missed-if-nolock-hint-is-used.aspx

that the NOLOCK hint can wreak havoc on the integrity of the...