Search results

How can I make a query that will take a field that I already have set to record the last contact date and check it against today's date to give me the span between the two?

I am writing an application in vb.Net that pulls data from a table in a SQL Server, loads it into an array, and then checks certain fields against another array that I pulled in from an excel file. I am doing this because certain users are unable to simply import the excel file and query the...

I have a rather large table that I need to run a stored procedure on to get the records in which there is a date span greater than two years. In other words, I want all the records after 12/1/2005 in which there was not an order (not a record) placed previously for over two years. How should I...

I work with an online ordering system that uses an Access front end and a SQL Server backend. My predecessor set up our sales report based on a Sub-Procedure. It is my inderstanding that using sub-procedures is faster because it runs within the SQL server, though sometimes not the first time...