Re: STORED PROCEDURE

From: EB (no_reply_at_wanadoo{do_not_reply}.nl)
Date: 02/20/04

Next message: Vishal Parkar: "Re: How to findout Eliminated record by when use Distinct function"
Previous message: Hari: "Re: STORED PROCEDURE"
In reply to: Cairns: "STORED PROCEDURE"
Next in thread: Andrew J. Kelly: "Re: STORED PROCEDURE"
Messages sorted by: [ date ] [ thread ]

Date: Fri, 20 Feb 2004 14:04:10 +0100

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

Hi,

By itsself, this works fine, since it yields a result. So the problem must
be elsewhere. Please post more of your stored procedure.

Regards,
EB

Next message: Vishal Parkar: "Re: How to findout Eliminated record by when use Distinct function"
Previous message: Hari: "Re: STORED PROCEDURE"
In reply to: Cairns: "STORED PROCEDURE"
Next in thread: Andrew J. Kelly: "Re: STORED PROCEDURE"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Trying to debug an exception
... It yields the following ... I am trying to understand what the exception is actually ... > it an issue inside the stored procedure? ... I'd try running SQL Profiler while your program is running - that ...
(microsoft.public.dotnet.languages.csharp)
Form is read-only because of stored procedure
... I have a stored procedure that yields the records I want, ... attempt to edit those records in a form, I am unable to do so. ... UniqueTable/Resync stuff, but am not sure what to do with it. ...
(microsoft.public.access.forms)