I am a learning-as-I-go person without formal training. I have been working with Access databases for about 10 years, and have begun working with SQL in the last 5 years or so. The system in user here is a 2K3 server (8xXeon 2.8Ghz, 12GB RAM,
1TB HDD) running SQL Server 2005 (32bit). I am trying to develop a SQL query (view) which looks for values of one table' field at specific times based on a table of those times. When I use a datetime variable, that particular value at
that particular datetime will be returned. When I try to replace the variable with the datetime result of a second query(view), no data is returned. The code is below.
SET NOCOUNT ON
DECLARE @StartDate DateTime
DECLARE @EndDate DateTime
SET @StartDate = '2010-09-30 04:59:00' -- Need to replace this value with the the list of 'PriVolCk' datetimes
View Complete Post