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...

I'm not sure he's doing backups at all. That's most likely to be what the problem is, and the reason I recommended getting a DBA or reading up on...

If you're not a DBA, then I strongly recommend you get one involved. If you don't, you could end up compromising availability (as you've already seen) or, worse still,...

Have you followed the advice given in the error message? What is the recovery mode for your database, and what backups do you do?

John

Have you tried CONVERT? Use REPLACE as well if you need to change spaces into hypens, and UPPER if the whole month portion needs to be in capitals.

John