Not too surprising, on the Denali deodorant.

"Denali" is the Athabaskan name for Mt McKinley in Alaska, and means "The High One". (Which could be taken all kinds of amusing...

The submenu XML column isn't named. That's what's causing the error. Can't have an unnamed column in an XML query.

Add something like "AS Submenu" after the close-parentheses for...

Without tables involved, it's procedural code either way you slice it.

I find the Case version more readable, but that's a personal opinion, not something that can be backed up with...

You don't need to truncate a log file if you back it up.

Per MSDN:

Note

After a typical log backup, some transaction log records become inactive, unless you specify WITH...

You're welcome.

And, theoretically, if you turn notifications back on automatically due to a successful run, you'd probably want to send an e-mail alerting you to that. "Alerts re-activated after successful...

The way you did is just fine.

The T-SQL Pivot function is nearly useless, in my opinion. Don't bother with it.

BrainDonor (10/26/2011)

---

I thought we'd hijacked that thread enough, so I've moved over here:

Ninja's_RGR'us (10/26/2011)

---

BrainDonor (10/26/2011)

---

Available now over there, but not over here. By the time it was shipped over I...

Duplicate post.

Please post replies at: http://www.sqlservercentral.com/Forums/Topic1196314-1291-1.aspx

How does the table tell the query which one goes first, which one goes second? Will there ever be a third, fourth, et al?

Or does the sequence not matter?

Ping each server first.

Then, if up, check the state of the SQL service. You can do this through WMI.

Then check database statuses.

If you use...

Sample of TVP-use:

USE ProofOfConcept;

GO

CREATE TYPE TVPtest AS TABLE (Val VARCHAR(100));

GO

CREATE FUNCTION dbo.ConcatString

(@Vals_in AS TVPtest READONLY)

RETURNS VARCHAR(1000)

AS

BEGIN

RETURN STUFF((SELECT ';' + Val

FROM @Vals_in

FOR XML PATH(''), TYPE).value('.[1]','varchar(1000)'), 1, 1, '');

END;

GO

DECLARE @Vals AS...

As far as a variable number of parameter values, if you're actually on SQL 2008, as suggested by the forum this question is in, have you looked into Table Value...

Modify the query as follows:

SELECT @concat = STUFF((

SELECT ';' + value AS [text()]

...