To make it more flexible, you might consider doing it like this:

SELECT 'databaseA', columnlist FROM databaseA.dbo.table UNION ALL

SELECT 'databaseB', columnlist FROM databaseB.dbo.table UNION ALL

SELECT 'databaseC', columnlist FROM databaseC.dbo.table UNION ALL

etc...

I...

Have you looked at extended events? I don't know if it's possible to do what you're trying to do, but it's worth investigating.

John

Why not just set all databases to have the increased timeout? Is there any reason for any database not to have it? If you can only set it...

sknox (4/10/2015)

John Mitchell-245523 (4/10/2015)

I would argue that either is correct. If you interpret "116...

Yes, putting a column from the outer table into your WHERE clause turns your outer join into an inner join. Try turning WHERE into AND so that it becomes...

http://www.connectionstrings.com/%5B/url%5D

John

Yes, that "Mobile Equipments" category has appeared from nowhere. But all you need is a LEFT JOIN between the two tables, so that all rows from the left hand...

No, it's not as simple as that, and the more you look at it, the more complications you'll see. What about tabs, carriage returns, schema names, comments and other...

I would argue that either is correct. If you interpret "116 characters" as a...

If you're determined do this, you'll need to write yourself a parser. As far as I know, Microsoft haven't published the code for their SQL parser, so you'd be...

I've been through an exercise like this across multiple servers before, although I was lucky enough that the type of operation wasn't a requirement as it is here. I...

You need the position of the final backslash and the final underscore and to take everything between the two. You can get the position by reversing the string and...

I try to make packages self-documenting, with plenty of annotations, and tasks named to be descriptive of what they do. If you number your tasks as well, you can...

You can either pull in a directory listing for the folder that contains the backup and use that to determine the most recent, or you can query msdb on Server...

I think it's so that the CTE definition doesn't get mistaken for an index hint or something similar.

John