[font="Verdana"]All I can say is... thank goodness it's only an April Fool's joke! If that's a primer, I'd hate to see the advanced stuff.[/font]

Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a number of subtle problems with database design in terms of...

[font="Verdana"]I suspect if you hit the FAQ (frequently asked questions) for this site, there will be some information on applying service packs.

You can download the instructions for applying the service...

[font="Verdana"]I'm not sure, but I think that it does so, yes.

It should be fairly easy to put together a test and run it across your different locales to see what...

[font="Verdana"]That's puzzling. The ProductLevel should give your service pack.

Either way, why does it matter? Service Pack 3 includes all of the previous service packs. So once you...

[font="Tahoma"]There's a fair amount of overlap, judging by the commentary on the Oracle-related threads.

I think maybe it's something worth considering. Of course, there's that whole "time" issue.

[/font]

[font="Verdana"]I've met people who did all of their word processing in Excel because that's what they knew how to drive. Who needs Microsoft Word when you can use SQL...

[font="Verdana"]Kavi,

This is...

[font="Verdana"]Nothing that can't be fixed with a recent copy of the Shorter Oxford Dictionary. All however many volumes of it! ...

[font="Verdana"]No, we are just holding our collective breaths until...

[font="Verdana"]... a much under-valued database design philosophy in my books. The crux of the issues being around the "row by row" approach to changes in the...

RBarryYoung (3/31/2009)

---

Given all that we have learned about your situation, I think that the best/only reasonable course of action is, instead of matching logon/logoff based on employee number, match them...

[font="Verdana"]Thanks for the replies: certainly appreciated.

I've had over a day to think about this now, and here's an update to what I've come up with.

It turns out that overlapping sessions...

[font="Verdana"]Hey Ramesh,

Yes, I was thinking I could do something better with ranking functions, but my brain just wasn't going there....

Florian Reischl (3/30/2009)

---

Hi Bruce

I have had a similar business case. I used the @@SPID for a lookup into the system view dm_exec_sessions.

You can use the session_id and the login_time as...