Eugene Elutin (2/16/2012)

sturner (2/16/2012)

CTE or not, a syntax error is a syntax error. I'm happy the OP resolved his issue but...

I revised my code and created a simple CTE and that solved the problem.

WITH CTE

AS

(SELECTResCalc.CONVNO,

CASE

WHEN ResCalc.ACCDESC IN('Beef','Pork','Chicken') THEN 'Meat'

WHEN ResCalc.ACCDESC IN('Shrimp', 'Fish','Crab','Lobster') THEN 'Seafood'

WHEN ResCalc.ACCDESC IN('Orange','Apple','Pear','Plum')...

sturner (2/16/2012)

bet you left the...

I was able to solve the problem by using a simple CTE.

Thanks for the suggestions.

I tried it and it did not work.

Thanks for...

I tried it and I get a syntax error.:-D

Thanks for the reply.

This is what the CASE looks like:

SELECTCOUNT(ResCalc.CONVNO) AS RecordCount,

CASE

WHEN ResCalc.ACCDESC IN('Beef','Pork','Chicken') THEN 'Meat'

WHEN ResCalc.ACCDESC IN('Shrimp', 'Fish','Crab','Lobster') THEN 'Seafood'

WHEN ResCalc.ACCDESC IN('Orange','Apple','Pear','Plum') THEN 'Fruit'

WHEN ResCalc.ACCDESC...

Rings a bell.:-)

Thanks Lowell!

Thanks Lowell. I had created the Linked Server and used a Login on the AS400.

I just wanted to make sure that I did not forget anything before the Users tested...

Thanks, I was not concerned about the mappings, just the login.

I've dropped Linked Servers before and it did not drop any Logins.

And Gals;-)

You have to run the script for each database.

Also I get an error when running the script.

Msg 911, Level 16, State 1, Line 33

Could not locate entry in sysdatabases for...

It's nice but it converts ' to ‘ when you copy & paste.

I tried replacing but I still had errors.

Thanks for the link.

Please confirm that if I delete the Linked Server it will not Drop the Remote Login.

Sorry I was not clear how about using NOT EQ.