Hi Seth - Thanks for the reply - that's why we're re-writing the queries, because we know that the *= won't work. However we're also validating them as we...

...i've spoken with my boss and we're going to go with a CASE statement for now, combined with looking at the actual data. Depending on the change on the...

I'll just reply to everyone's points all at once...

Can't - or at least it's not up to me - I'd have to go to our...

...i did in fact get everything up and running. Now i have two days to figure this out - maybe that'll get my "Geek" status back for me 😛

Thanks...

...sometimes I wonder how I've earned my "Computer Geek" status at all...:ermm:

Using Perry's suggestion I tried going through the interface. I got to the Installation Rules, and it turns...

OK, so i have copied the DVD files to my C:\. Here's what I see:

C:\SQL\ia64, \x64, and \x86. I also have autorun.inf, setup.exe, and a couple of other...

does any one have *any* ideas?? I'm starting to get huge pressure about this report from my boss...

thanks

chris

Thanks anyway Jeffrey, I appreciate your time (and I did learn about Soundex, which is a cool feature....just not for this ;-))

have a great one

Chris

(edited for grammar)

Hi Sergiy - Yeah, I already thought of that; what I'm going to have to do is (I think) run a Monthly details report to go along with the counts....

Hi CirqueduSQLeil,

Your post was exactly what I needed to get me started. I took the code from your post and modified it to this:

Select table_name+'_'+column_name, 'insert into #Temp...

Hi Manu-J,

No, I wasn't able to; I didn't spend too much more time after I posted my edit as I had a lot of other stuff on the go...

...alrightie - thanks for the reply auaiomrn - i've gotten as far as finding the Information_Schema.columns view...

I know what a cursor is, but I've never used or created one. ...

Thanks Grant and Steve; what I am hoping for are specific things that VS2008 is able to do that VS2005 cannot. We do use VS2005 now, and my manager...

Thanks Steve and Lynn, I'm going to be taking your advice - I'm working on a plan right now of our "high priority" queries and will start on those.

thanks again...

Thanks Lynn! 😀

We don't have many self-joins so I may as well update them all, I was just curious.

Now, *= and =* joins are going to be another matter...