Re: [Hibernate] Using Temporary Tables for Large SQL Queries with IN CLAUSE

2004-12-31 Thread Max Rydahl Andersen
On Thu, 30 Dec 2004 18:35:59 -0800 (PST), Rajan Gupta <[EMAIL PROTECTED]> wrote: I did not understand the response, can u help elaborate. Thanks in advance eh ? I don't understand what is not to understand ,) You can execute that query with createSQLQuery as long as you return entitities. You ca

Re: [Hibernate] Using Temporary Tables for Large SQL Queries with IN CLAUSE

2004-12-30 Thread Rajan Gupta
I did not understand the response, can u help elaborate. Thanks in advance Rajan --- Max Rydahl Andersen <[EMAIL PROTECTED]> wrote: > On Thu, 30 Dec 2004 11:10:58 -0800 (PST), Rajan Gupta > <[EMAIL PROTECTED]> wrote: > > > Hello! > > We have a scenario where the user can select multiple employe

Re: [Hibernate] Using Temporary Tables for Large SQL Queries with IN CLAUSE

2004-12-30 Thread Rajan Gupta
I did not understand the response, can u help elaborate. Thanks in advance Rajan --- Max Rydahl Andersen <[EMAIL PROTECTED]> wrote: > On Thu, 30 Dec 2004 11:10:58 -0800 (PST), Rajan Gupta > <[EMAIL PROTECTED]> wrote: > > > Hello! > > We have a scenario where the user can select multiple employe

Re: [Hibernate] Using Temporary Tables for Large SQL Queries with IN CLAUSE

2004-12-30 Thread Rajan Gupta
I did not understand the response, can u help elaborate. Thanks in advance Rajan --- Max Rydahl Andersen <[EMAIL PROTECTED]> wrote: > On Thu, 30 Dec 2004 11:10:58 -0800 (PST), Rajan Gupta > <[EMAIL PROTECTED]> wrote: > > > Hello! > > We have a scenario where the user can select multiple employe

Re: [Hibernate] Using Temporary Tables for Large SQL Queries with IN CLAUSE

2004-12-30 Thread Max Rydahl Andersen
On Thu, 30 Dec 2004 11:10:58 -0800 (PST), Rajan Gupta <[EMAIL PROTECTED]> wrote: Hello! We have a scenario where the user can select multiple employeeID's that we need to show line items on in one shot. The number of items in the selection could possibly be 1000's. To execute such a query, we wo

[Hibernate] Using Temporary Tables for Large SQL Queries with IN CLAUSE

2004-12-30 Thread Rajan Gupta
Hello! We have a scenario where the user can select multiple employeeID's that we need to show line items on in one shot. The number of items in the selection could possibly be 1000's. To execute such a query, we would have to use an IN clause e.g. SELECT name, date, salary FROM EMPLOYEE WHERE empI