>>Consider this table:
>>pk uniqueidentifier
>>fk bigint
>>clock datetime
>>
>>I need an SP that can do the following:
>>If there are zero records for that day, insert a record.
>>If there is one record for that day, insert a record.
>>If there are two or more records for that day:
>> - do nothing if the time falls between the min and max time for that day
>> - update the min time record if the passed clock is less than the min time for that day
>> - update the max time record if the passed clock is greater than the max time for that day
>>
>>This is what I've got. but I am not sure how to find the correct record (if needed) to update
>>

>>SELECT @count = count(*) FROM mytable
>>WHERE fk=@fk AND
>>YEAR(clock) = YEAR(@clock) AND
>>MONTH(clock) = MONTH(@clock) AND
>>DAY(clock) = DAY(@clock)
>>
>>IF @count<2 BEGIN
>>	// insert this is easy
>>END ELSE BEGIN
>>	// find the correct @pk to update
>>END
>>

>>
>>Any help appreciated.
>
>
>
>Not sure what you want:
>

>SELECT @count   = count(*),
>       @MinTime = MIN(DateTimeField),
>       @MaxTime = Max(DateTimeField),
>       FROM mytable
>WHERE fk=@fk AND
>YEAR(clock) = YEAR(@clock) AND
>MONTH(clock) = MONTH(@clock) AND
>DAY(clock) = DAY(@clock)
>
>IF @count<2 BEGIN
>	// insert this is easy
>END ELSE BEGIN
>    IF @MinTime -- Here I am not sure what you mean with "if the passed clock is less than the min time for that day"
>       BEGIN
>           UPDATE .....
>                  WHERE fk=@fk AND
>                  YEAR(clock) = YEAR(@clock)   AND
>                  MONTH(clock) = MONTH(@clock) AND
>                  DAY(clock) = DAY(@clock)     AND
>                  DateTimeField = @MinTime
>       END
>
>    IF @MaxTime -- Here I am not sure what you mean with "if the passed clock is greater than the min time for that day"
>       BEGIN
>           UPDATE .....
>                  WHERE fk=@fk AND
>                  YEAR(clock) = YEAR(@clock)   AND
>                  MONTH(clock) = MONTH(@clock) AND
>                  DAY(clock) = DAY(@clock)     AND
>                  DateTimeField = @MaxTime
>       END
>
>END
>

Good idea. I think the passed time is @clock variable.