Yes, Master database first, then the remainder.

Wrong topic.

Out-Gridview -PassThru is very interesting. Definitely a consideration for some of my scripts 🙂 Even I don't use the back up solution, I've definitely learned something today.

It seems that the word wrapping goes a bit odd at the end of a line. When you have a word that is long enough to go on to a...

I almost wonder if the Format menu should be always displayed, rather than only when you hover over.

We have a hard enough time getting people to post their SQL in...

If you're using two tablixes, you could set them to be hidden depending on the parameter value.
For example, if the tablix for 5 could have a hidden expression value...

The only problem I have with the convert function is...

DECLARE @Date VARCHAR(10);

SET @Date = '20151025';

--Assuming format is always yyyyMMdd

SELECT CAST(LEFT(@Date, 4) + '-' + LEFT(RIGHT(@Date,4),2) + '-' + RIGHT(@Date,2) AS DATE);

You should change the format of the date, for...

How do we determine how these value should be paired?

In your example you had:

14522345 30245123

Why not any of these?

14522345 31451831

14522345 32452632

14522345 31458142

What's the logic there?

richlion2 (1/11/2017)

---

Thom A (1/11/2017)

---

To export from SQL Server to Excel, you'll need to use the ACE 32bit drivers (The JET drivers are the older drivers and are no longer supported)....