SQL Unable to create temporary stored procedures

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Unable to create temporary stored procedures

Author

Topic

ahaile
Starting Member

25 Posts

Posted - 2009-09-14 : 16:38:10

I am trying to create a temporary stored procedure using a query designer in SQL 2000 database. I am told I have full access to temporary database.

Here is my query:

CREATE procedure #TEST
AS
select top 40 * from employee
where hire_date '1/23/2008' and '1/25/2008'

And I get below generic error:

TITLE: Microsoft Report Designer
------------------------------

An error occurred while retrieving the parameters in the query.
Server was unable to process request. ---> ERROR:
line: 0
column: 16
near: CREATE procedure
reason: syntax error, unexpected NAME, expecting INDEX

------------------------------
ADDITIONAL INFORMATION:

Server was unable to process request. ---> ERROR:
line: 0
column: 16
near: CREATE procedure
reason: syntax error, unexpected NAME, expecting INDEX (Pangea)

------------------------------
Any assistant greatley appreciated.

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-09-14 : 16:52:55

quote:
TITLE: Microsoft Report Designer

Where are you writing the query?
Are you using Query Analyser? (or whatever it was called in SQL 2000)

ahaile
Starting Member

25 Posts

Posted - 2009-09-14 : 16:58:47

microsoft visual studio query designer (Microsoft Report designer)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources