[qoute]Just noticed that was a new one. I keep doing that these last few days (spewing out info on the wrong version)[/quote]

Yeah and another version coming this fall.

Michael,

You are correct. You have to go with derived tables on 2000 as CTE's were introduced in 2005.

Jeff,

Always appreciate some code review:P

Lynn,

Thanks for the kind words. I definitely have looked for help on this site, although usually for SSIS, Design, or Admin advice. I can usually put a hack...

Lynn,

All true, and are the reasons why I try to be very specific when I post a problem. Sometimes I am even a little too verbose.

BTW, my...

I'd tell you why if I knew the question. Well I was a little late on the submit. Anyway Matt is right it looks like it should work,...

the only way a tx log can grow is through use. At least as far as I know. I would profile the server to verify that there is no use...

Jeff Moden (2/26/2008)

---

darkins (2/26/2008)

---

Hey,

I am not the greatest TSQL guy (not even the not so greatest) so here is a question.

I have two tables. One has 1 "A" Record (table...

Lynn Pettis (2/26/2008)

---

Jeff,

Thanks for the comment. Sometimes it...

msaint (2/26/2008)

---

It was my hope to use this as a view so that clients who create their own reports with a variety of report writers would be able to derive...

Does the vendor still exist? Since they are suggesting a move to MySQL I assume they do, and since they do and they sold the product as working with...

I always assume that the OP posted in the correct forum and this is a SQL 7, 2000 forum. So I try to answer using methods available on that...

Here is what I would do:

Create View room_occupancy

As

With occupancy AS

(

Select

O.room,

O.room_date as check_in,

O.in_out as occupants,

IsNull((select min(room_date) from rooms Where room = O.room and in_out O.room_date), O.room_date + 1) as...

I would definitely call this a complex query as basically you want to "pivot" the data and SQL 7, 2000 do not do this natively. In Standard SQL a...

I'm not sure what you mean by this. Do you mean that you can't set the parameter to allow...

With only 1 row being returned you may want to use a datareader. It takes fewer resources than a dataset.