You need clustered index on tblcommunicationsSent.accountID.

There may be other columns included into that index but accountID must be the first one.

And if it suppose to be Excel days then ...

And if it suppose to be ...

So, question remains: what it suppose to be?

First you need to define the rule for your conversion.

07/17/2007 5:16:00 PM must become - what?

07/17/2007 8:20:00 PM must become - what?

I did not say solution is bad.

I objected Jeff's statement that it's perfect.

In row 1 you are trying to insert value 'EMPLSTS' into varchar(5) field.

You need to use FIRSTROW = 2.

Not really.

Try '00000000000000'

Suggestion is already posted.

Ben,

next time please try to be more specific.

People were trying to help you with server's domain name, but you're happy with Peter's solution which provides user's domain name.

So, people...

Option B) is preferrable.

But it may be done in shorter way:

WHERE (RecordId = @RecordId OR RecordGuid = @RecordGuid)

If both @RecordId and @RecordGuid are NULL no rows will be returned.

> even advanced mathematics is based on elementary (not school) principles.

Probably.

But elementary mathematics does not operate with such thing as infinity.

That's you don't know how to deal with it.

...

Someone is mentoring instead of providing requested solution.

Isn't it you Peter?

1 > undefined = undefined

1 > infinity = false

Now you tell me if what they are saying at this link is true.

Really?

Distanse between them will become smaller and smaller on every approach.

Until it will become "extremely small", "extremely close" to zero.

But it's not zero, as you stated.

So, who is right?

Lynn, believe me, there is a whole world of math beyond the level of primary school arithmetics.

You just don't know about it, but it's there.

Lynn, you're so bad.

You cannot even get how bad and low you are.

Don't tell anybody that n/0 = undefined, not infinity.

Because it's a shame to be so ignorant as you...