Remi - I cannot afford to not be friends - once I've learned everything you have to teach then maybe....<;-)

As for fearing the look of others...most people on scc are...

Hey - no gender based remarks s'il vous plait!

You get me started on those and you will LOSE big time! You may be the master of t-sql but us women...

problem is solved for now!

ps:It's more fun following other posts than starting your own because you (at least I) learn so much more that way! <;-)

Remi - I never posted my problem (I HATE asking for help - big drawback! 🙁

I just followed some of your reponses to "other" posts and figured out my solution...

I second that - this is a display issue, not a storage one!

Remi - on an aside I wanted to tell you that I was struggling with a query for...

Here's a link to something similar - except in this case it was the first occurence not the max...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=191860#bm192527

Are these the only columns you have - no primary key or ID column ?!

You're passing only a string value to convert - you need to first change it to datetime type...try this:

select convert(char(10), cast('2004-12-22 11:36:02.000' as datetime), 101)

sorry about the double post - something went funky just as I was posting the reply...

If you're selecting from a single table then you do:

select cityname = case

when cityID is null and RegionID is null then ''

else cityname

end

from listingtable

you can tweak this to...

If you're selecting from a single table then you do:

select cityname = case

when cityID is null and RegionID is null then ''

else cityname

end

from listingtable

you can tweak this to...

tscott - I'm still a little confused - if you're designing new tables and views each (tax) year to tweak something - why aren't you just "creating" instead of "renaming"...

I hope you aren't counting them Remi - you'll run out of fingers and toes long before I stop adding to my oops list...

ps: Unless you're using a 'select count(*)'...

You're right about that loyalty!

I made the mistake of submitting an article to the company newsletter about the +s of telecommuting where I said that I would take a telecommuting...

Kelly - thanks for sharing the location - so if Tulsa is going from "for the most part very conservative" to trials successful enough to motivate other departments that's great...