Migration to SQL Server: Help Please!

  • Thread starter Thread starter Arch
  • Start date Start date
A

Arch

I am trying to convert this query into T-SQL in SQL
Server. I could not figure out the correct syntax for
parameters in SQL Swever.
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
 
SQL Server doesn't support parameter prompts like Access queries. You can
create a stored procedure which allows parameters. Check Books On Line.
 
Back
Top