Big!

Lowell (4/11/2012)

---

that was my first thought too, either a login trigger, or using the built in applications login tracking, which writes to the SQL log:

but the OP said he want's...

Glad you found the solution.

Although as an aside, enabling the SQL Browser service on the server should mean you don't need to create the aliases on your client machines.

Could Logon triggers be used?

Get them to write to an auditing table and then query that for the information you require?

As Lowell says though, after the initial login event you...

Koen Verbeeck (4/4/2012)

---

Nope! It existed since SQL 2008 (R2?). Everybody just ignored it 😀

Surprised this QotD didn't hit 100% correct answer,...

Ah, thought MDS was only introduced with SQL 2012!

Just move the Where clause conditions into the join conditions, should do it.

;with calendar as

(select distinct calendarmonth, calendarYear, fiscalYear, fiscalMonth

from #calendar)

select

c.calendarMonth,

...

Ah, I missed him yesterday, went to see Christian Bolton instead.

David Morrison afterwards was good though.

No one in particular, just any fellow SSC-ers who might be here!

All too busy I guess!

Went for 3, as I thought 4 was the total number you could have..

Oh well, learnt something 🙂

L' Eomot Inversé (3/26/2012)

---

Gazareth (3/26/2012)

---

The sspI restriction enzyme is so named because it's used to cut the sspI gene from the genome. The gene itself appears to encode for a...

I enjoyed that! 😎

L' Eomot Inversé (3/26/2012)

---

If there's a genetic chemistry biologist amongst the readers, maybe he can tell us what sspI stands for when it's a restriction enzyme - I can't, I...

Ha, I was going to mention it, but this can be caused by one or more of your joins causing multiple rows to be returned for the values you're summing.

This...

Thanks.

You were on the right track with the changes you quoted above, but if you weren't removing SBTI.Amount & SBTI.Quantity from the GROUP BY clause, then you would have ended...