![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Here's a geek query for my SQL-loving friends (anyone? Bueller?)...
At work, we have a database we use to track many things (DOD regulations are
fun). Every month, I append and delete the entries for that month into
another table (I'd prefer a completely separate database but we're sad like
that and I have no choices about some things). This is done with two
queries which both ask for the beginning and end dates of the queries.
Since the beginning and end dates for both queries are the same, is there
some way to pass the data just once instead of typing the dates twice each?
Help?
At work, we have a database we use to track many things (DOD regulations are
fun). Every month, I append and delete the entries for that month into
another table (I'd prefer a completely separate database but we're sad like
that and I have no choices about some things). This is done with two
queries which both ask for the beginning and end dates of the queries.
Since the beginning and end dates for both queries are the same, is there
some way to pass the data just once instead of typing the dates twice each?
Help?