Actually I only want to run this little app on the Local Area Network.

Thanks for all your help guys, my bodd helped me figure it out. I did not want to go to my boss about it, but I finally had to break down and go...

I just read the "Help Us Help You" page, so I'm going to generate some samples of the data and put it someplace where you can get it...

Thanks for your...

Yes, literally 1000's of them have a NULL value in the claimstatus field.

And NO, none of the fields in claimstatusid have (empty string) in a field.

Thanks,

David

OK, I want to pull all the data from each of the fields mentioned in the SELECT statement from the tables mentioned in the FROM statement but only the records...

Gee Whiz... well, I guess I'm in the right part of the forum... Newbies! HAH!! And I thought I was doing something great.

Anyway, I want to see all records from...

OK, what I am trying to do is see if there are any location codes in gentiva1407 that are not in gentiva1206, and if so, return all the data that...

OK, thanks for that piece of advice.

But now I am getting this error message:

Server: Msg 8114, Level 16, State 5, Line 1

Error...

OK, this is what I just tried to run,

UPDATE MasterRegis SET

subcompanyname = eui_director_list.concept,

street = eui_director_list.f4,

streetline2 = eui_director_list.f5,

locationdesc = eui_director_list.city,

state = eui_director_list.state,

zipcode = eui_director_list.zip,

division =...

This is the query I ended up with:

update MasterRegis

set subcompanyname = eui_director_list.concept, street = eui_director_list.f4, streetline2 = eui_director_list.f5, locationdesc = eui_director_list.city, state = eui_director_list.state, zipcode = eui_director_list.zip, division = eui_director_list.division,...

Thanks guys... I updated the field to NULL.

Great advice guys, and thanks for your patience with me. Should I install SQL Personal, or a ful copy of SQL Server?

Once again, thanks allot.

Dave