The feature to look for is CDC (Change Data Capture). Introduced in SQL server 2012, it required an enterprise license, but in newer versions it is available in other (cheaper)...

Eirikur's solution can be made even faster if you specify in your xquery that you will only ever accept one root report-node per xml document.

DECLARE @XML_DATA XML = '

<Report MerchantID="123456">

...

select

tsk.ID,

(select top (1) t.Tasks from dbo.Task t where t.ID = tsk.ID and t.preference = min(tsk.Preference)) as [Preference Task],

stuff((

...

Happy to inform you that the same error still occurs... :hehe:

You're welcome. Looking at the number of views of the script, you are probably one of the very few that actually understand why and when you need this :-D.

I...

We've experienced blockage in merge replication too. You need to be carefull not to set the retention period to high. Depending on the amount of changes coming through, the size...

You should design your process in such a way that it processes the effects of only one tables' changes at a time. So if your DWH table is the result...

I know, I'm a bit late to the table. But no: you're not the owner of the data in the _CT tables, the CDC mechanism is, so you should not...

Don't know, maybe because it is easier to read (once you've gotten used to the merge syntax), does the same thing in a single statement...

I've often applied a slight variation that I think has a minor optimization (based on the assumption that many times a row will exist, so that we can test if...

Same thing happens when you encounter a < or > in your text. You could nest your statement in even more replace statements, but your code isn't going to look...

Sean Lange (6/1/2016)

While your code works well for the entire set the...

You can however retrieve and later or on another server recreate logins giving the hashed password; i.e. even though you can't read it, the user will still be able to...

You should be very careful using xml for splitting or merging texts as there are many exceptions to deal with in xml. Some of the problems can be avoided using...

It may look easy, but still the solution provided was wrong.

Here's one that does give the requested answers:

declare @tbl table (

TagIndex int not null,

DateAndTime...