Yeah, I purposely made my scenario generic, and I realize that there's a lot of "it depends" involved. (Lynn: to answer your question, it could be either -- almost...

GSquared (12/21/2009)

---

I'm not as familiar with ASP.NET as I probably should be, so this may or may not be relevant/correct.

In VBA, you can create an SQL connection object, and a...

Actually, now that I'm re-reading it . . .

Why are you building a dynamic query? Why not do this:

DECLARE @cn varchar(50)

DECLARE @value char(1)

SET @cn = 'MyColumnName'

SELECT TOP 1 @value...

Good thoughts. I have to admit that the issue of injection attacks didn't even occur to me.

I remember an instance where I'd prefer the embedded code direction (and I'm...

I think I have the gist of what you're asking. Can you supply some specific examples?

Okay . . . that wasn't made clear in your original post, and I did not get that at all. (Just for your future reference, you should make...

Just telling us what the output is supposed to look like doesn't help at all. Can you give us an actual example of how you want your output to...

Camden Yards and Coors Field are both great ballparks! I also like Safeco Field in Seattle. SkyDome (now Rogers Centre) is also another interesting ballpark as well.

I also...

I think you'd be better off doing it like this:

update table

set col1=value, col2=value+some value

Note: the "value" in col2 is (hopefully, obviously) the same one that you put into col1.

Ack . . . I just re-read the previous postings. Shows you what happens when I skim through posts rather than absorbing them!

I can definitely see your point...

How often do we refer to a "CPU" as an entire computer case when really all it is is a component inside?

Similarly, a lot of people refer to the words...

COLD!!!

Single-digit and negative Fahrenheit temps here in upstate New York!

Steve -- it was your user point level names that prompted me to start this thread in the first place! 🙂 (Love your editorials, BTW!!!)

My sister-in-law lives in Denver,...

I just tried running your query on one of my own tables that has dates, and didn't have a problem.

BTW, Grant is correct . . . you should avoid...

If my team wins, it's worth it! 😀