MS SQL AND QUERY INPUT
I am new to Dataminer and programming. We have a MSSQL 2008 database which I need to query.
Is there some way to create an input interface which would allow me change the data-time variable which is the only thing
that changes in the query? We use a "start-time" and "stop-time" variable.
That is: WHERE start-time > '2011-11-01 03:00:00' and start-time < '2011-11-01 04:45:00'
I would like to have two variables StartTime1 and StartTime2 such that I could use that as a variable instead of the having to
input the times. We have anywhere from two to nine areas where the time is referenced. Having a variable instead of needing to
change each entry would greatly speed up the process as I need to run queries on over six months worth of data with various start-stop times and durations.
Thanks in advance.
Is there some way to create an input interface which would allow me change the data-time variable which is the only thing
that changes in the query? We use a "start-time" and "stop-time" variable.
That is: WHERE start-time > '2011-11-01 03:00:00' and start-time < '2011-11-01 04:45:00'
I would like to have two variables StartTime1 and StartTime2 such that I could use that as a variable instead of the having to
input the times. We have anywhere from two to nine areas where the time is referenced. Having a variable instead of needing to
change each entry would greatly speed up the process as I need to run queries on over six months worth of data with various start-stop times and durations.
Thanks in advance.