I interpret it as meaning the path to the Customer_1.csv file, something like "c:\MyCSVs". There's a section on page 5 Downloading the example code. Can you find the...

Ah yes, this is a classic gaps and islands problem. Have a read through this, and see if it helps.

John

I'm not sure that's a legal operation. From Books Online (emphasis mine):

The OUTPUT clause is not supported in the following statements:

* DML statements that reference local partitioned views, distributed...

Pedro

Just multiply speed in KB/s by time in seconds to get the number of KB you can transfer in that time.

John

If your maintenance plan only backs up a single database, and is appropriately named with the name of the database, it should be fairly easy. Sysjobhistory will tell you...

So, if you're interested in RunLogID 5, you want all rows that have the same RootRunLogID (which is 1 for RunLogID 5)? Try this:DECLARE @runLogID INT = 5;

WITH cte_RunLogandChildren...

Yes, you can add a second instance. Install it the same way you did the first (although bear in mind there may be reboots and therefore you'll need to...

If you're looking for the new value, use the Inserted virtual table, as you have done. For the old value, use the Deleted virtual table.

John

Tony

If developers are involved on...

Tony

If you're running so many ad hoc queries, that points to something missing in the application. Is there a pattern to the kind of modifications that you're being asked...

Steve

Great job on posting tables and sample data! Is this what you're looking for?WITH cte_RunLogandChildren AS

(

-- Anchor

SELECT rl.RunLogID

,rl.LogLabel

,rl.ParentRunLogID

,rl.RunLogID AS RootRunLogID

FROM dbo.RunLog rl

WHERE rl.ParentRunLogID...

Grant Fritchey (11/30/2016)

---

Is abc.name from a table or is it from some code? If it's a table, sure, I guess you leave it be. If it's code, I'd rather see...

There's no user input...

Yes, in most cases replacing loops with set-based code is a good thing. There's nothing wrong with your code as written. You can also write it something like...

Your original request was for comments from those who have encountered this problem before. I haven't, but I'd say all you need to do is make any necessary changes...