No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
 | Hi, Is it possible to have a subquery within a case statement and perform greater than / less than comparisons on the value returned in the subquery? i.e. [code] select case (select price from product) when < 100 then 'cheap' when < 150 AND > 101 then 'fairly expensive' else …  |
| | Hi, I have the following query, which does not return any results. [ICODE] select (sum(t.minutes) / 60),d.fiscalmonthnum from kpifntime t inner join kpiddate d on t.datekey=d.datekey inner join kpidacts a on t.activitykey=a.activitykey inner join kpidfees f on t.feeearnerkey=f.feeearnerkey where a.activitycode in (11,12,13,14,15,16,17,18) and d.fiscalmonthnum=11 and d.fiscalyearnum=2009 and t.feeearnerkey=520 group by …  |
| | Hi, I've having a bit of difficulty with an update statement. The following select statement returns 34 records... [CODE] select b.* from budget as b inner join ntime t on b.feeearnerkey=t.feeearnerkey inner join date d on t.datekey=d.datekey inner join acts a on t.activitykey=a.activitykey where a.activitycode in (11,12,13,14,15,16,17,18) and b.fiscalmonth=d.fiscalmonthnum and … |