1. SELECT r.*, t.RTypeName FROM ROOM r, RType t
WHERE r.RTypeID = t.RTypeID AND
NOT r.RoomID IN (Select RoomID FROM SALES WHERE SalesDate <= ? AND NOT DEAD)


2. CREATE TEMPORARY TABLE "sample" AS SELECT r.*, t.RTypeName FROM ROOM r,
RType t
WHERE r.RTypeID = t.RTypeID AND
NOT r.RoomID IN (Select RoomID FROM SALES WHERE SalesDate <= ? AND NOT DEAD)

1st quesy works but 2nd sql in SP does not work.

Is this a bug or limitation?

Tomas
Its a limitation presently. I also had the problem and I think Tim said it'll be something that's going to be sorted.

For now you'll need to DECLARE a VARCHAR build the string and then execute it.

Roy Lambert [Team Elevate]

Tomas,

<< Is this a bug or limitation? >>

It's a known limitation in that CREATE TABLE doesn't allow parameters.  It's
on the list for fixing in one of the first few 2.0 minor releases.

--
Tim Young
Elevate Software
www.elevatesoft.com