Hi All,

I am a newbie to Hibernate.

How can I convert the following SQL into Hibernate Query Language(HQL):

SELECT a.register, c.descr as grpdescr,
requested=isnull(Sum(b.amt_requested),0),
allotted=isnull(Sum(b.amt_allotted),0)
into #temp_budget
FROM header a, line c where a.id=c.id

Any help greatly appreciated.

Thanks,

Sam

this isn't sql - this is any procedural language

HQL is (primarily) used for mapping returned values to java classes. That bit of SQL isn't returning any values. HQL is not appropriate in this case.

Just in case you weren't aware of this: don't use "select ... into ..." in production code. Because it creates a table at the same time as doing a select, it locks several important system tables (sysobjects, syscolumns, etc.) for the duration of the select. This essentially freezes your entire database for the duration of the query. You're far better off doing a create table then an insert ... select ...