If you're just doing this to follow along with an exercise, set the value of the variable by typing it into the pane. If you're doing it with the...

Well, then you need an identity column in your table and a cast-iron process for making sure the data goes into the table in the same order that you receive...

That will bite you very hard at some point. What happens when someone creates a clustered index on p2p? The rows will (or are most likely to) go...

So you want to fetch the unique identifier for the user that's running the report? This relies on users running the report using their own Windows credentials. You...

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...