Henrico Bekker (9/29/2016)

---

So the "Situation":

The export report formatted (XML) from the Baseline Analyzer for SQL is unusable into a report, and must be viewed in the Baseline Analyzer, so...

You may want to incorporate deadlock handling into your code, perhaps using something like the following snippet I wrote to handle deadlock processing in one of our procedures:

-- The following...

Pingala (9/28/2016)

---

Thanks. We implemented the RETRY to avoid deadlock. However, I am surprised how a queued DELETE got a deadlock in the first place if SQL Server does queued operations...

This is a code snippet I have used where I currently work to handle deadlocks:

-- The following snippet is for building deadlock handling.

declare @ErrorNumber int,

...

mw112009 (9/28/2016)

---

A picture pf the text ( a portion of it ) is attached ( I can not give you the entire file due to security reasons )

As for...

Luis Cazares (9/28/2016)

---

Sorry Gianluca, I'm just trying to bring the young padawan into the...

PLC - Programmable Logic Controller.

valeryk2000 (9/27/2016)

---

Thank you. However the task may be more complicated: in some cases there is more than 2 IDs (check 10011580, 10014918, just for example, in my table posted @...

drew.allen (9/27/2016)

---

Okay, is it just me? I've seen two different people post sample data where the datetime data is given in hex and converted to datetime. It's not...

If you could add some sample data to your tables above that would help.

valeryk2000 (9/27/2016)

---

I do not know what would be the better way to present a simple table with 7K+ records (Excel file). The table has 2 columns, ID and Arrival DateTime....

mister.magoo (9/27/2016)

---

Lee Hopkins (9/27/2016)

---

I have a script that gives me a string of the columns and types.

I wan to use this result to create a declared table

DECLARE @listStr VARCHAR(Max)

SELECT @listStr...

I was right, I had the lowest winning score and would have lost to everyone else.

ScottPletcher (9/27/2016)

---

Lynn Pettis (9/27/2016)

---

ScottPletcher (9/27/2016)

---

So you want to go from DBA-level SQL to developer-level...

Try this one:

declare @collist nvarchar(max),

@schema nvarchar(128),

@table nvarchar(128);

set @schema = N'dbo';

set @table...