Is my participle dangling? :w00t:

Gail: Wow....

Lynn: Good luck, because merit doesn't always triumph in this crazy world

Jason: The "Today" show carried footage of a naked jogger today, and...

Asked and answered.

Steve should publish a book: "Best of The Thread" or possibly "Worst of The Thread".

I'm sorry to say I don't see another approach at this time.

No problem. 🙂 Craig, I learned from your explanation.

Have a great evening, guys.

Craig, I created tables A-F in my sandbox database and the queries posted would not run.

Msg 4104, Level 16, State 1, Line 10

The multi-part identifier "f.id" could not be bound.

I...

Yet again, I will attempt to explain....

Gus:

The reason I said use CASE is that you might have cases where the join to T2 succeeds but some other T2.column value is NULL anyway.

In that...

... and a recitation of all parameters for DBCC TIMEWARP.

Are you sure about your syntax?

Where is the join to F in either query? What are using to join to C in the second...

We are just expecting that the user's locations will be acceptable if they are within a range of the lat/long of the store, hence I thought using the buffer around...

Lisa, just this once, I will urge you to reconsider.

Queries against spatial indexes using a geography datatype will run much slower. Geography is...

Let's call it a great team effort and cross the finish line with hands joined in victory. 😀

Thank you.

You are defining your course titles as NCHAR, which means they are padded with blanks on the right to the specified length. NVARCHAR might be a...