I am using a query and have isssue in doing multi select with an amount field.
Actually I want to have a parameter like this:
Select ANY Amount range (from the 3 shown):-
BETWEEN -8500 AND 8500
The query is simple with case statement to run for either one of the range selected.
But now I want to also run by multi selection on Ranges with an OR statement.
I am able to run for either of the range selected but I am not able to run for more than one range selected.
Any help on this.
Here is my sample code.
create table dbo.test
INSERT INTO test ( year,month,
View Complete Post