I believe you've successfully converted the Cross Join to an Inner Join with the criteria so, I think this will do the same thing...

[font="Courier New"]Select t1.UserId, t2.StatusDate LogoutDate, Min(DateDiff(n, t1.StatusDate,...

Florian Reischl (4/8/2009)

---

So here is my formatting function 😉

It's another concept than Lowell's but might also help in some cases. Keep in mind, if possible use CONVERT due to a...

Lowell (4/8/2009)

---

Florian thanks for your function;

one format, the ISO one, is really handy for me, as I have to do a lot of that conversions;

ISO8601 (XML) ...

Ells (4/8/2009)

---

I have a script that I use. Basically it loops through all the tables in a database and uses

exec sp_spaceused

This then returns

...

At the risk of rattling the rubble, that statement is 100% spot on. The original developer made a...

Ummm.... no.... to be as safe as possible with this method, you MUST include a FROM clause in the update and it must use a TabLockX and index hint that...

Way to go, Roy! I had a similar experience where I'd interviewed person after person after person for a Sr. Developer position. They all had degrees and certs...

Bob Hovious (4/7/2009)

---

He is a trophy. Stuff him and mount him on the wall. You could tell from...

AFIFM (4/7/2009)

---

No it is not. One of the legacy applications (A) uses 'Access_Level' as VARCHAR which only uses "1", "2", "3",....."8". The second application (B) uses the...

Ok... here we go. I copied your very fine test data code and added the answer to it...

[font="Courier New"]--Post to SQL Server Central

--===== If the test table already exists,...

Maxim Picard (3/27/2009)

---

You can find two excellent articles from Jeff Moden on cross tabs and pivots here that should help you tackle this challenge.

Cross Tabs and Pivots, Part 1...

Now we're cooking with gas! Well done, Joseph. Lemme see what I can do.

By the way... this is the kind of newbie I like to see...

http://www.sqlservercentral.com/Forums/Topic685148-338-1.aspx

The man's original post was absolutely typical of a newbie post. So were a couple of his...

Lynn Pettis (4/7/2009)

---

I did a little more reading, Jeff....

GilaMonster (4/7/2009)

---

Jeff Moden (4/7/2009)

---

I sometimes have a similar problem with age... most young folks look at my white beard and chuckle about what Santa Clause might know about databases. ...