Possibly the stop_execution_date stays NULL if the job is cancelled or interrupted? That would mean any such jobs will appear in your result set until the cancelled execution is...

Common Table Expressions.

John

No, it fails two tests of being a primary key, namely that there can only be one in a table, and that each of its values must be unique. ...

Luis Cazares (2/2/2016)

---

A bit simpler than the code posted by John. The FROM part is only generating sample data and it's not really a part of the solution.

SELECT *,

...

WITH AllHours AS (

select name, SUM(CASE WHEN CallType IN ('Y', 'C', 'E') THEN 0.0

...

Create your new drive - call it H or something. Stop replication. Take the databases offline. Copy everything from G to H. Take G offline and...

I think you're confusing column names with variables. Either way, this should get you started:

DECLARE @BaseDate date;

SET @BaseDate = '19000101';

WITH SampleData ([Year], TempQuarterlyPeriod) AS (

SELECT 2000, 1 UNION ALL

SELECT...

Have a look at the CAST and CONVERT topic in Books Online. You may have to do a bit of manipulation on your string, for example adding a year...

I have an SSIS package that does all this. It chooses ten databases at random from the whole estate and restores them one by one from the latest full,...

There's only one row in Table1. If you want your result set only to have one row, how do you decide whether to take English or French?

John

No, COALESCE returns the first non-null value from the list of arguments (or NULL if all the arguments are null). If you post some table DDL and a few...

Yes, different version, different edition, different server collation, different sysadmins, different firewall rules, and so on. Or maybe you need to have two databases with the same name.

John

COALESCE(Table2.ExampleA,Table1.ExampleA)

John

Simon

That's how SQL Server works. It grabs as much memory as you allow it, and doesn't give it back unless the operating system asks for it. If you...

Jeff Moden (1/26/2016)

---

John Mitchell-245523 (1/25/2016)

---

If you're using SSIS, you don't need to restrict yourself to T-SQL solutions. You'll probably find it easier to run a simple Powershell (or other...