That is a requirement. But what is your question?

Try this:

CASE WHEN LEFT(t.DC,2) IN ('01', '02', '08', '21', '22', '30', '32', '40', '55', '62') 
THEN LEFT(t.DC,2) 
ELSE '01' 
END AS DC

--deleted

• This reply was modified 3 years, 8 months ago by Phil Parkin.

That's a bit trickier, but try this version and see whether it helps:

WITH ordered
AS
 (SELECT
      hs.Id
  ,   hs.SalesID
 ...

Your trigger will fail if more than one row is inserted or updated in a batch, so I suggest that you fix that.

What do you want TitleNormal to be updated...

Here's an example

DECLARE @Query VARCHAR(1000) = 'SELECT TOP (10) object_id, name FROM sys.columns';

DROP TABLE IF EXISTS #SomeTab;

CREATE TABLE #SomeTab
(
    object_id INT
   ,name...

Does this help? It uses the ROW_NUMBER function to perform the ordering and partitioning that you need.

DROP TABLE IF EXISTS #HectorSales;

CREATE TABLE #HectorSales
(
    Id...

• This reply was modified 3 years, 9 months ago by Phil Parkin. Reason: Improved code. Removed unnecessary CASTs and changed Unicode literals to varchars

The logical equivalent of

NOT (A AND B)

is

NOT A OR NOT B

so changing the AND in your query to...

It doesn't work the way you are hoping (ie, with some sort of table-name cursor).

If you write a query in that window, it will export the results of running that...

As this is specialised software, perhaps you should get support from the vendor?

One possibility is the use of SYNONYMs to help you in this.

Assume that the synonyms 'point' to tables in DB1 on day 1.

On day 2, DB2 is updated. If...

It's somewhat difficult to understand exactly what is going on here, because you've posted a fairly large chunk of code, most of which is not relevant to the problem you...

First of all, are you aware of issues with numeric precision when using FLOAT? If not, I suggest you reconsider – DECIMAL() is often a better choice.

If you put the...

This is as good as it...

• This reply was modified 3 years, 9 months ago by Phil Parkin.

You should be fine. Just make sure that you set things up in your SSDT Project Properties to target the right platform.