Ok, I have a little more info...I now have it to where I can connect and execute the job and it works. There is a SQL account CACM that...

One more thought, in the Job, can I specify a user to run the exe as?

Ok, a little more info...hope this helps. I created a new exe and removed the call to the Web Service and the Job runs successfully. So what accounts...

Jeff - It doesnt require any input. I dont have the exe open a command box. It calls the service, updates the db and closes itself.

The .exe is on the same box that is running SQL

I am not a SQL admin by any means, but I know enough to be dangerous and that is not always a good thing I know. Which account are...

Sean, thanks for reading completely through my question to give your answer which was the solution. My original thought with the union was to join two result sets. ...

The result of the query is going to a List Box on a VB.net form (for what its worth). The preferred result will be everything that starts with VAL...

That helps! I was actualy thinking this morning I should just find a way to include it in the View. Thanks for all your help!!

I have 82 rows in my view. I need to now seperate which is BBB and which in non-BBB. The 82 rows is (for this) case FIXED, I...

Yes, that is the case. For example, I queried just my rows from the sub table (Trade_Goods_And_Services) and I have 9 rows. When I look at the results...

That worked for the BBB members. I am still getting too many records for the non-BBB members.

Thanks Lynn and Gail! That worked

For clarification and education, is the "where" not needed? and is there a case where it would be needed?

Once again thanks!

John