Great article, just what I needed. Thanks

I made a slight modification in the CSD2 variant, just for security, to avoid ererroneous data, when the procedure is executed on an earlier...

I also tried it and got 1,1 Another untested question:hehe:

At least got my point by writing this reply 🙂

OK, So you don't want to use a cursor? Even better!

You don't need to use a tally table either. I came up with this solution. I created a List table...

The question is very unclear. I guess it should be:

We have server ABC and installed two instance on it ABC\First and ABC\Second. we setup the Transactional replication from ABC\FIRST to...

Wow,:w00t:

Thanks Chris. Your query is much faster then mine: 3 seconds compared to more than a minute on my database.

I had been thinking about your second suggestion as well, but...