RE: [firebird-support] Select statement

Regards, Nols Smit [Non-text portions of this message have been removed]

RE: [firebird-support] Select statement

No need for three COALESCEs if you want to multiply: and coalesce(p.total_revenue*p.exchange_rate*p.cgsshare_pct,0) = 0)) There are cases where these variables may have null values. Regards, Nols Smit . [Non-text portions of this message have been removed]

[firebird-support] Select statement

and Date_Closing is between DateA and DateB and Value is null ? Regards, Nols Smit [Non-text portions of this message have been removed]

RE: [firebird-support] Select statement

or p.TOTAL_REVENUE = 0) or (p.EXCHANGE_RATE is null or p.EXCHANGE_RATE = 0) or (p.CGSSHARE_PCT is null or p.CGSSHARE_PCT = 0)) Is it possible not to use the UNION? Regards, Nols Smit [Non-text portions of this message have been removed]

RE: [firebird-support] Select statement

This seems to do the SQL job: With Recursive RecurseCGS as ( Select ID from CGS_Structure where ID = :ID_RootCGS Union all Select Child.ID from CGS_Structure Child, RecurseCGS Parent where Child.Parent_ID = Parent.id ) Select * from ( select p.ID, p.BIZTYPE_DESCRIPTION,

RE: [firebird-support] List of users in a role

Thanks for the info. How do I include the First, Middle and Last Names in the select statement? Regards, Nols Smit. [Non-text portions of this message have been removed]

[firebird-support] Help needed wit a Select ... Group By

But then I have to execute the SQL again for the next bookyear up to the current one. Is it posible to create one SQL select statement where I can have the result as: GENDER_NAME, RACE_NAME, FOP_NAME, NUMBER_2008_2009, NUMBER_2009_2010, NUMBER_2010_2011, NUMBER_2011_2012 Regards, Nols Smit

RE: [firebird-support] Securities

using IBExpert to control the securities) Regards, Nols Smit [Non-text portions of this message have been removed]

[firebird-support] Document managent systems using FireBird

Hi, I' looking for information about OpenSource or commercial document management systems using FireBird. The system must be able survive in a corporative environment (many groups of users and very large number of documents). Regards, Nols Smit [Non-text portions of this message have been

[firebird-support] Roles and connection pooling

restricted) roles? Regards, Nols Smit [Non-text portions of this message have been removed]

RE: [firebird-support] Roles and connection pooling

function of IBExpert to inspect the connection activities. Regards, Nols Smit [Non-text portions of this message have been removed]

[firebird-support] Merge results of recursive CTE with results of non-recursive CTE

of the lookup tables are tree-structures. If I filter data using only one tree-structure (as a lookup table) then a recursive CTE is easy to use but I can not figure out how to use a combination in one executeable block of SQL. Regards, Nols Smit [Non-text portions of this message have been removed]

RE: [firebird-support] Re: Merge results of recursive CTE with results of non-recursive CTE

by BizType_Description, Loc_Description Now I wondered if it's possible to have one block of executable SQL? Regards, Nols Smit [Non-text portions of this message have been removed]