If a transaction log falls in an empty database, does it make a sound?

Neither....

Is your integer column set up as an identity field and a primary key?

Sounds like indexing could help you out. (A bunch of folks on these forums know more...

rain

A little bit. Jeff's CASE example above is correct, if you want to go with that.

Otherwise, if I have time to digest your scenario...

Daniel Bowlin (11/3/2010)

---

tosscrosby (11/3/2010)

---

Me too....Although, I did hook up with an "old" friend last evening. She is gorgeous.....and at my age! So maybe this morning isn't...

What are you trying to do in SQL? I'm thinking that there might be a better way without using a CASE statement.

Can you give us an example of what...

Seconded :doze:

Wow, I won by 0.42!

Talk about close shaves!

You'd be surprised. Check out the thread that I...

My wife is fond of telling me that I'm always in the...

Nelson Williams-487553 (11/2/2010)

---

I find that irresponsible. Here we are on the government created Internet engaging in the free exchange of ideas and you don't want to take part.

I think...

Yeah -- this getting up while it's still dark thing is for the birds! 😛

Can't wait for Daylight...

Yep -- first thing this morning, before I came to work.

"I left my heart in San Francisco . . . "

Congrats, Giants!!!