Can you answer this?

The task would become incredibly easy if you change seq data type to decimal(9,1)

Then you can place the moved step in between of any other steps, or in front of...

What is the PK on this table?

Do you really have the case when the source table does not have any kind of time stamp or an auto-incremental ID?

Query results are shown in some form of decimal representation.

What you see on the screen might be not the actual numbers in...

drew.allen (8/18/2016)

---

This is even in the Microsoft documentation.

Using decimal, float, and real Data

---

Avoid using float or real columns in WHERE clause search conditions, especially the = and <> operators. It...

ben.brugman (8/22/2016)

---

So my script does not produce the errors your script produces. So your conclusion based on your script and your error is not a valid conclusion. (Even if it...

There is no argument.

Bottle No.20 is the last bottle of...

SELECT ID

FROM TableA

WHERE DateDeleted IS NULL

AND EXISTS (SELECT * FROM TableB

WHERE TableB.DateDeleted IS NULL AND CONTAINS(*, @Input)

AND TableB.TableA_ID = TableA.ID

)

Does populating the table itself take not so long time?

I'd start from deciding on an optimal clustered...

I'd suggest to start from a basic "table partitioning" which was available even back in SQL2000 ages.

Make sure the clustered index and non-clustered index(es) are on different physical drives.

And none...

Exactly.

But the functions you use to figure out the days of...

Which task you intend to hand over?

And if you comment out the unnecessary last part from the GROUP BY it will even start returning the resultset which seems reasonable:

SET @Pattern2 = N'

SELECT transmission_natlang ,modeltrim_name , technical_item_name_natlang...

If only somebody would remember those proper programming technics which are considered nowadays so 20th century!

One of those ancient rules says - do not use in-code constants, always declare variables...