STORED PROCEDURE

From: Cairns (stephensenterprises_at_hotmail.com)
Date: 02/20/04

Next message: thiru: "Re: How to findout Eliminated record by when use Distinct function"
Previous message: Hari: "Re: Reference to more than one table"
Next in thread: Hari: "Re: STORED PROCEDURE"
Reply: Hari: "Re: STORED PROCEDURE"
Reply: EB: "Re: STORED PROCEDURE"
Reply: Andrew J. Kelly: "Re: STORED PROCEDURE"
Messages sorted by: [ date ] [ thread ]

Date: Fri, 20 Feb 2004 04:36:08 -0800

I am receiving the following error message when producing this fied as part of a select statement in a stored procedure. Can anyone help me fix it.

Incorrect syntax near 'dateadd'.

dateadd(d,7*CONVERT(int,LEFT(CONVERT(decimal(4,1),DATEDIFF(dd,GETDATE(),'20030208')/7),2)),'20030208') as TestDate

Next message: thiru: "Re: How to findout Eliminated record by when use Distinct function"
Previous message: Hari: "Re: Reference to more than one table"
Next in thread: Hari: "Re: STORED PROCEDURE"
Reply: Hari: "Re: STORED PROCEDURE"
Reply: EB: "Re: STORED PROCEDURE"
Reply: Andrew J. Kelly: "Re: STORED PROCEDURE"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Error message assistance needed!
... update trigger or other stored procedure when calling the RAISERROR ... user-defined error message to the sysmessages table in the Master database. ... Have your DBA fix whatever is causing the error message problem in the ...
(microsoft.public.access.queries)
Re: Case statement issue
... except with a cursor other than the default ... > I have taken the sample of paging using a stored procedure from the ... > case statement, then the error message. ... > The for loop also seems to be a problem. ...
(microsoft.public.inetserver.asp.general)
Re: Case statement issue
... except with a cursor other than the default ... > I have taken the sample of paging using a stored procedure from the ... > case statement, then the error message. ... > The for loop also seems to be a problem. ...
(microsoft.public.inetserver.asp.general)
Case statement issue
... Windows enterprise 2003 OS with IIS version 6 on the server. ... I have taken the sample of paging using a stored procedure from the website ... case statement, then the error message. ... The for loop also seems to be a problem. ...
(microsoft.public.inetserver.asp.general)
RE: Word has stopped working opening on Vista
... I found a fix and so far everything is working. ... This worked for me with Vista ... then error message saying cannot find file. ... but the word startup problem has persisted. ...
(microsoft.public.word.application.errors)