You can't do this quite like your'e trying to do it. If you fixed the syntax error you'd come out with a string like one of these:

dbo.OP_Tariff.SpecialtyCode = NULL

or

dbo.OP_Tariff.SpecialtyCode...

What you're describing is old style join syntax. It is the same thing as a join, but it's not seen much anymore because JOIN's are much easier to read....

Please provide sample data and table structure. Displaying data *vertically* is not normally an issue, as that's how tables are usually constructed in the first place. So we'll...

Have you run it with NOT as a select statement to see what is returned?

How many records are in your test data set?

The logic of 1 = case ......

You can't group by productPrice, as a single product could have more than 1 price and you're going to get a count of how many products were sold at each...

Please post your table structure and sample data the way I do here in the future. See the article in my signature on How to post sample data if...

Right, and what is your question? By your error message, the table either does not exist, or you do not have permissions to it.

A lot of times these issues...

Honestly, even though you posted in the wrong forum, you're still better off not re-posting. The other thread has ideas already thrown out and discarded, and more information about...

We may not be all be psychic, but apparently some of us are detectives in our spare time :P.

Please refer to the link in my signature on how to provide sample data and table structure for this request. You aren't giving us any sample data to work...

I have a trigger that is almost identical with the RAISERROR of 16, and I had to add an explicit ROLLBACK TRAN before the return. I was of the...

laurav (12/18/2008)

---

Thank you Garadin.

I suppose I really dont have the conceptual piece down like I thought I did... I am creating a trigger on the entire table, and it...

Not quite.

I think you're looking for something more like this:

CREATE TRIGGER dbo.Chg_Elec_Consent_for_Termed

ON Employee

AFTER UPDATE

AS

UPDATE CONSENT

SET ElectronicConsent = 'N'

FROM inserted i...

Thanks for the feedback John, glad we could help.

SELECT name FROM sysobjects WHERE xtype = 'U'