Hi,
(1)
I have two tables,
one contains current records,
2nd one contains history records.
Selection will be: if records cannot be found in current, then go to find in history.
Question: What's the best method in this case? I can only think that use IF..ELSE statement and dup whole set SELECT statements, it's quite dummy.....

(2)
I pass one parameter into stored prod,
Question: Can I accept that, if the passing parameter is " " blank, then select all records, else, select the specified record?
Is it the only method using IF..ELSE statement and dup whole set SELECT statement??
What can I do???

Pls HELP!!

Best Regards,
Eva ^.^