troubleshooting Question

SQL View - Pass over variables

Avatar of Gareth_Pointon
Gareth_Pointon asked on
ASPMicrosoft SQL Server 2005SQL
53 Comments1 Solution291 ViewsLast Modified:
Hi,

I have built a complex SQL view that checks for users that are not in certain tables on certain dates.

This is working OK when I manually add the date rage "From" and "To" in to the SQL View....
I'm Using a between function for two date like this:

 (start BETWEEN '2013-01-01' AND '2013-20-04') AND (stop BETWEEN '2013-01-01' AND '2013-20-04')

What I would like to do now is to Call this View from my ASP page and use two variables for the from and to dates.

Can this be done ?

Thanks
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 53 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 53 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros