STORED PROCEDURE

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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)
feedback
... Error message and unknown file ... Can anyone tell me what this means and if there is a way to fix it ... Portable disk) and when I loaded it onto my computer and go to the external ... To identify what loads when you boot use Autoruns (freeware from ...
(microsoft.public.windowsxp.perform_maintain)