It's not as straightforward as it first seems. Have a look at this link for one way to do it.

I have to say I don't know whether the backups are tested or not. The Ops guys we were going to speak to about getting rid of the secondaries...

Cheers John.

The backups are on the same drive as tempdb and I didn't think that was a good idea. If we stop the backups then tempdb will obviously be...

Ed Wagner (10/5/2016)

---

Sean Lange (10/5/2016)

---

Eirikur Eiriksson (10/5/2016)

---

george sibbald (10/5/2016)

---

Lynn Pettis (10/5/2016)

---

george sibbald (10/5/2016)

---

well that's me done. I retire today so this will be my last post.

I made it into the...

Again, you're welcome.

This place has helped me out no end in the past. I'm glad I can pass on something of what I've learned here. Please...

1) Yes; the UNION operator can combine multiple queries with the same output columns but different sources. In this case we're returning the user ids from 5 different tables....

You're welcome, I'm happy to help. Do you understand what it does?

As a disclaimer, I've only Googled using a CTE in an SSRS dataset rather than actually doing it...

rkelly58 (10/4/2016)

---

Please can anyone help, I have 5 SQL tables (T1, T2, T3, T4, T5) which contain just 2 fields: UserID and Timestamp

I need to read each table and pulls...

/*****************************************

Create some sample tables based on a guess

******************************************/

CREATE TABLE #T1

(

UserIDVARCHAR(6)

,DATEDATE

)

CREATE TABLE #T2

(

UserIDVARCHAR(6)

,DATEDATE

)

CREATE TABLE #T3

(

UserIDVARCHAR(6)

,DATEDATE

)

CREATE TABLE #T4

(

UserIDVARCHAR(6)

,DATEDATE

)

CREATE TABLE #T5

(

UserIDVARCHAR(6)

,DATEDATE

)

/*

Populate the tables

*/

INSERT INTO #T1 VALUES

('User01',CAST(GETDATE() AS DATE))

,('User02',CAST(GETDATE() AS DATE))

INSERT INTO #T2 VALUES

('User01',CAST(GETDATE()...

Brandie Tarvin (9/30/2016)

---

So what's...

[ModenAnswer]

A column found on one of our tables. I absolutely promise we are not responsible for any cold calls received by members of the Thread.

Option 3 produces 9.000000 for me...

Thanks for the responses folks.

It turns out that the cause was more simple than I feared. Allowing for aging out of anything older than a few days...

I've had chance to look over what I did before and it's more a case of over-complicated in places rather than shocking. It only actually looks a mess, rather...

Christmas Day and New Year's Day always fall on the same date but the holiday may not actually fall on that day. In the UK, Christmas Day and Boxing...