I got mine as incentive along with my subscription to SQL Server Mag.

What about letting the members decide in a poll on having that stars (and rankings) again or not?

Would...???

Hm...obviously I haven't finished my first response...and now it's too late.

Ceteris paribus I will be there at the end of May.

And hey, we're all equal... with some being more equal

Is this a typo in if exists (select 1 ...?

To check for existence of an object I use something like

IF OBJECT_ID(N'[dbo].[FUNWITHNULLS]') > 0

DROP TABLE FUNWITHNULLS

GO

Would

Take a look at INSTEAD OF triggers in BOL

Wow, good catch Bill. Didn't notice the difference before.

However I think colors won't change unless you are a site co owner. I guess that's why Andys' and Steves' boxes are green.

I...

Let's face it. You're right

Btw, how did other members manage to get this question mark or other icons next to the subject?

Is it a...

Thanks, and yes, this one I meant.

Couldn't remember where I downloaded it

Yes, would be interesting to hear why the statement can't be changed.

If that's a third party app, I wouldn't hesitate to contact the vendor.

Just a thought!

Would there be any...

Interestingly when you link the SQL Server table back into an Access db and run a statement like

INSERT INTO....(TRUE)

from within Access, the rows will be inserted correctly.

Hi David,

I always suspected you mixed avatar and profile picture

The if update() works perfectly for me. Are you sure @TriggerVal is correctly assigned a value.

This http://www.sqlservercentral.com/columnists/jtravis/understandingthedifferencebetweenisnull.asp might be interesting for you

Haha, now I understand

You want the same syntax like VB

If something = True...

The addendum = True isn't necessary at all. *Might* make it...

Can you post the code you have so far?