For those interest, here is the CASE query actual execution plan, where the optimiser has swapped out the CASE statement for the COMPUTED columns automatically.

Eirikur Eiriksson (1/19/2016)

---

Jacob Wilkins (1/19/2016)

---

Throwing in the CASE using Eirikur's wonderful setup yielded this on one million rows on my machine (tangentially, I'm embarrassed that Eirikur's laptop is faster than...

Thanks for testing Orlando.

I wonder how the performance of each method will depend on how many "date columns" are present as well, whether having 20 columns vs 10 columns is...

You are probably best off using FOR XML PATH for this in my opinion.

Select

-- Make IdDoc an Attribute by prefixing with @

R.IdDoc [@IdDoc]

...

Just noticed "and the column header it belongs to", so:

SELECT MA.MaxDate, MA.ColName

FROM <mytable> AS MT

CROSS APPLY (

SELECT TOP(1) VA.LName, VA.LDate

FROM (VALUES('L1',MT.L1),('L2',MT.L2),('L3',MT.L3)....) VA(LName, LDate)

ORDER BY...

You can also use APPLY

SELECT MA.MaxDate

FROM <mytable> AS MT

CROSS APPLY (

SELECT MAX(VA.LDate)

FROM (VALUES(MT.L1),(MT.L2),(MT.L3)....) VA(LDate)

) AS MA(MaxDate)

Excuse any slight syntax errors, I have typed this away from...

Don't get confused into thinking that a CTE materialises the query inside it, it is just a query format structure and what you have there is a horrible mess.

I...

Jeff Moden (1/8/2016)

---

Hugo Kornelis (1/8/2016)

---

Jeff Moden (1/7/2016)

---

Technically correct because only an rCTE can be an rCTE but the rather...

No matter which output route you take, why not simply create a set with

key (order id?)

line (order line number/row_number())

data (nvarchar(max) fixed width data)

Insert the headers, all with [line] =...

You could try running SSMS with the /log switch.

This will write a log to your local user profile under %AppData%\Microsoft\AppEnv\10.0 called ActivityLog.xml

If you save the attached XSL file in the...

Instead of opening the report in report builder, download the rdl and open it with...

Try the dropdown list at the top of the properties window.

If that fails, open the report xml and search for it there.

We use an SSRS "dashboard" for this, also an overnight SSRS report which lists any individual job step errors.

These are based on querying the agent logs in msdb.

pete.ciskanik (12/17/2015)

---

I have a staging table of customer names, numbers, and sales data etc. I've been trying to write a stored procedure that inserts everything into that staging table. One...

YSLGuru (12/14/2015)

---

SELECT T. Col1, T.col2

FROM TABLE T

WHERE 1 = 1

There is a space after T. and before Col1 without the use of brackets and yet this works for some reason....