I can't help it... I gave her a derived table with which she can do a group by on. I have no idea if it will work (no easy access...

Is it possible to do this? (Jeff's gonna kill me for this one - RBAR hall of shame I suspect).

select * from (

SELECT

...

Oh man... not 5 minutes after I posted that question did I realise what I was missing.

The article I was reading was transaction log truncation.

Turns out what I'm missing...

My posted query isn't going to work. Didn't realise that you can't use an outer reference in a group by clause in SQL Server 2005.

Barry - sorry to hear about your back 🙁 Get well soon!

Whoa! How does that work?

arup_kc (8/18/2009)

Sorry for late replying, actually I was out of net for last 3 weeks. I have seen the comments. I do agree that I had some misconceptions, which are...

Yow! But why would you want to?

Dave Ballantyne (8/17/2009)

Steve Jones - Editor (8/17/2009)

Maybe the poster of the solution honestly believed that...

Both are good points.

Most of the questions I see are either about:

a. transaction logs, setup questions, etc.

b. how to maintain the database, or

c. why doesn't my query run...

Cheers Lynn and Dave 🙂

The most valuable one I've read was Jeff Modem's, where he gave a pretty decent explanation of what you need to post so that people can...

I'm curious as to what would be seen as a dumb question that is acceptable, and a dumb question that isn't acceptable?

Obviously, the question I saw earlier (how do I...

But... but... why use TSQL at all? Am I missing something?

You can't do an outer join from the where clause...

Very interesting - I've never thought of it that way before. But absolutely, that makes total sense.

You'll have to forgive the newbie questions, but I am the eternal learner 🙂