to get rid of the fractional part of a date (time) i usually cast it to a float and then floor that value.

example:

 cast(floor(cast(GetDate() as float)) as datetime)

or in your case

and...

Hi Ryan,

Without going in to much detail...

Got claim item that have security events, maintenance events, lessor contributions and contract securities. They all have the same grouping of FK (not nullable) and...

Hi Ryan,

In my particular case i am actually using left outer join, but have two IDs to join too, one PK, and another a nullable FK.  So the join would actually...

Hi Ben,

I solved this problem by using the isnull function

JOIN... ON ISNULL(table1.nullable_ID, 0) = ISNULL(dbo.table2.nullable_ID, 0)

Hope this helps

Pieter

Hi Kazo,

To get rid of the time part in GetDate() i use the following statement:

select cast(floor(cast(GetDate() as float)) as datetime)

The result for this would be:

2006-04-13 00:00:00.000

And you should be able...