i want to test my query on three different dates .Either it takes the dates during run time or pick three defined dates.
I am not sure if recursive will help in here as I have not used it before.
Can someone help me on this?
It's hard to help without knowing what you try to do.
You need to add more details including some sample data and expected result...
I want to run the following query with three random dates since last 6 months
now i want the dates to change everytime i run this query..like parameterised it somehow