A
Afshaan Shaikh
Guest
Hi,
How can we pass a group of dates(i.e. entire date column) in the between clause of SQL Query.
Example:
SELECT VAL FROM ANALOG WHERE TIME BETWEEN COL1_TIME AND COL2_TIME ORDER BY TIME.
Here COL1_TIME and COL2_TIME are nothing but columns of some other table which i have passed into a multi-value parameter in SSRS,
I am trying to pass an entire group of times in between clause.
How can i retrieve the data using the above query?
I also tried using filters which did not work.
Could you please suggest the best possible solution to meet our requirement.
Please help!
Continue reading...
How can we pass a group of dates(i.e. entire date column) in the between clause of SQL Query.
Example:
SELECT VAL FROM ANALOG WHERE TIME BETWEEN COL1_TIME AND COL2_TIME ORDER BY TIME.
Here COL1_TIME and COL2_TIME are nothing but columns of some other table which i have passed into a multi-value parameter in SSRS,
I am trying to pass an entire group of times in between clause.
How can i retrieve the data using the above query?
I also tried using filters which did not work.
Could you please suggest the best possible solution to meet our requirement.
Please help!
Continue reading...