You may consider
WITH TMP(My72, cFrom, cTo, dValueFrom, dValueTo) as
(SELECT CAST(:My72 as integer), US1.dValue, US2. dValue FROM RDB$DATABASE
LEFT JOIN dSetValue('Current Year', 'From') US1 ON (1=1)
LEFT JOIN dSetValue('Current Year', 'To') US2 ON (1=1))
SELECT
FROM TMP t
CROSS JOIN tDevelopment
Bhavbhuti,
> I have a SELECT statement which needs to have a WHERE clause adapt if a
> variable has a value or not:
>
> WHERE CASE WHEN 72 <> 0 THEN tDevelopment.iID = 72
> ELSE (CAST(tDevelopment.tDT AS DATE) BETWEEN (SELECT US1.dValue
> FROM dSetValue('Current Year', 'From') US1
Hi,Greetings For The Day.
I am using vb.net which has a grid of 100,000 records and 30 columns have to
insert in a firebird table. The insertion will take place if product id does
not exist else record to be update.But inside the loop while executing
ExecuteNonQuery control does not come back wa
Hi all
I have a SELECT statement which needs to have a WHERE clause adapt if a
variable has a value or not:
WHERE CASE WHEN 72 <> 0 THEN tDevelopment.iID = 72
ELSE (CAST(tDevelopment.tDT AS DATE) BETWEEN (SELECT US1.dValue
FROM dSetValue('Current Year', 'From') US1)
AND (
Hi,Greetings For The Day.
I am using vb.net which has a grid of 100,000 records and 30 columns have to
insert in a firebird table. The insertion will take place if product id does
not exist else record to be update.But inside the loop while executing
ExecuteNonQuery control does not come back wa