Posted by Psychobudgie on 11/16/06 17:01

Hi,

I have written a stored procedure which includes a DATEPART command, i.e.

DATEPART(weekday, <date>)

The result when ran from SQL Query Analyser is as expected . i.e. Sunday
returns 1, Monday 2, etc

When the same proc is called from within the Access 2000 project Sunday
is returned as 7, Saturday as 6 instead of 1 and 7 respectively.
Basically the same stored proc returns different data depending on from
where it has been called.

This is causing some issues obviously as the resulting tables and
reports are showing incorrect data when presented in Access 2000.

Has anyone else experienced this before or have any idea what may cause it.

Regards,

PB

• Next in forum: Re: SQL to calculate surrounding suburbs
• Prev in forum: Re: General advice needed regarding MS Access, MS SQL Server, MySQL/PostgreSQL
• Thread view: strange results when calling a sql stored proc from within an Access 2000 project

[Reply to this message]