Nice. Below are the stats based on changing it to the link Luis provide. Though one single call isn't noticeable to the eye, I would imagine if you are doing...

I work in healthcare and we use close to this same code at a claim level instance. So for one claim for a single visit, it can have up to...

This may help also

;WITH DiagWithRowNum AS

(

SELECT

VisitGuid,

DiagnosisText,

ROW_NUMBER() OVER (Partition By...

I created an operator with multiple names and then just send it using the below? There may be some limitations (maybe) but I'm not sure what all you'll be using...

Can you provide your restore script?

Hey John, just finished up testing it. I had to make a couple of minor changes. Based on various filenames and some having 2 or more "_", I ended up...

Wow! Thanks John. I did not even think about isolating it that way. So far it looks like it does what is expected. Great Job! I am going to run...

When this latency occurs, have you verified that there is nothing blocking at the Subscriber?

4 years Army 101st - Infantry. RAKKASAN!

When we patch we do patch the subscribers first also, then the publisher (which is where our distributor is as well). The below article mentions patches for replicated databases also....

Remove DISTINCT. Hope this helps

SELECT company, min(ID)as ID

INTO DistinctCompanies

FROM companies

GROUP BY company

You'll get an error msg similar to this "Cannot rename the table because it is published for replication."

If you truncate the table, then you will lose all the data to include anything that may not be in your current production file. Is that what you really want...

LOL. You all make my day sane if there is a such thing as "sane". http://forums.pentaho.org/showthread.php?t=68857

I am not disregarding the foundation. If I have made that impression, I apologize. I am merely debating the comment that GOTO should never be used.