Yep, it's LEFT OUTER. I found where I had to reference it before.

Thanks guys....

In answer to your question, I would say that it's nothing more than a matter of preference. If either of the developers are telling you that theirs is "faster" or...

Ahmad Osama (3/26/2008)

---

I have chosen...

I understand and would agree with that statement, but I'm too...

Thanks Michael, that clears it up a bit.

And the spids have finally dropped out of activity monitor. The transaction logs are now running as normal. So for now, it's ok.

It's...

Steve Jones - Editor (3/26/2008)

---

I haven't dealt with this in a clustered environment, but there are times when SPIDs seem to get stuck. Can you failover to the other side...

Jeff Moden (3/25/2008)

---

Just my 2 cents on this one... I've found that the WHERE NOT IN that Barry used is usually more performant than outer joins. The speed difference...

Depending on what your actually trying to accomplish, you might want to look into the new WINDOWED funstions like SUM() OVER (PARTITION BY ...)

i.e...

DECLARE @t TABLE (code INT, descr VARCHAR(10),...

You're already doing it in some other cases, like the quest_name line ...

but anyway ...

set @phone=ISNULL((select phone from guest where account=@account and room=@room_code group by phone),'')

Are the UserNames unique? This appears to be the case in your example.

DECLARE @t TABLE (UserName VARCHAR(25), StartTime DATETIME, UserID INT)

INSERT @t

SELECT 'Sally', '2008-03-24 10:09:13', 89...

FYI, I only asked what you've tried to make sure this wasn't homework. It still may be, but you've shown that you've put forth effort.

So ....

SELECT

*

FROM

...

Which does the ItemTypeID relate to? TableMain or TableDetail? You shouldn't have it in all three tables. It's redundant. If it applies to the row, then put the type id...

What have you tried?

I missed that "one row" requirement. ARGH!!!

SELECT

MIN(START_DT) AS START_DT

,MAX(END_DT) AS END_DT

FROM (SELECT

DENSE_RANK()...

ok, that was written with the assumption that there would be only one row per range.

-- create some test data

DECLARE @t TABLE (START_DT DATETIME, END_DT DATETIME)

INSERT @t

...