|
|
|
Supreme Being
Group: Forum Members
Last Login: 9/30/2008 4:39:37 PM
Posts: 105,
Visits: 84
|
|
Can a variable be used inside a case statement like so:
SELECT (CASE WHEN Year_id = :v_Year_id THEN 1 END)
FROM ......
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/4/2008 3:57:27 AM
Posts: 5,
Visits: 43
|
|
You can use paramenter in macro,for example:
create macro testm(iday char(10)) as
(select case when date=:iday then 1 else 0 end;);
usage:
exec testm('2008-03-29');
|
|
|
|