A
Arch
I am trying to convert this Access query into T-SQL in SQL
Server. I could not figure out the correct syntax for
parameters in SQL Server. Do I need to declare it as a
veriable?
The following is SQL from Access 2000. Please help me
convert this to SQL Server so the parameters would work.
DistManager is a table and ProjectsAwarded is a query
which is already in SQL Server.
SELECT -------
FROM -------
WHERE ((tblDistManager.DistManagerID)=[Please Enter The
District #]) AND (([qryProjectsAwarded].ProjectID) Is
Null) AND (([qryProjectsAwarded].AwardDate) Is Null) AND
(([qryProjectsAwarded].AwardApprvl) Is Null)
Thank You very much in advance.
Arch.
Server. I could not figure out the correct syntax for
parameters in SQL Server. Do I need to declare it as a
veriable?
The following is SQL from Access 2000. Please help me
convert this to SQL Server so the parameters would work.
DistManager is a table and ProjectsAwarded is a query
which is already in SQL Server.
SELECT -------
FROM -------
WHERE ((tblDistManager.DistManagerID)=[Please Enter The
District #]) AND (([qryProjectsAwarded].ProjectID) Is
Null) AND (([qryProjectsAwarded].AwardDate) Is Null) AND
(([qryProjectsAwarded].AwardApprvl) Is Null)
Thank You very much in advance.
Arch.