No Result set with a WHERE Clause.

Question

No Result set with a WHERE Clause.

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

What happens when you explicitely CAST your date as DATETIMES?

Or when you write WHERE... >= '20041214'....?

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

David.Poole SSC Guru Points: 76262 More actions · Answer 2

Put SET DATEFORMAT YMD at the beginning of your procedure

LinkedIn Profile

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Even better is to use a language independant format.

Here are some very good thoughts by SQL Server MVP Tibor Karaszi on this topic: http://www.karaszi.com/sqlserver/info_datetime.asp

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

TriggerMe SSChampion Points: 11752 More actions · Answer 4

I'm not sure what you mean by "What happens when you explicitely CAST your date as DATETIMES?" The B.TimeStampEntered Column is already a DATETIME DatType. Here is a sample for this column, 2001-07-04 14:15:39.633

And the SET DATEFORMAT to YMD did not achieve anyting either.

This has really blown me away. There must be something else werong but don't know where to look.

Kindest Regards,

TriggerMe SSChampion Points: 11752 More actions · Answer 5

I have sorted out this issue. It was a data quality problem between the UserEntered column and the LanUserId column ob the JOIN.

Thanks to all for your help.

Kindest Regards,