Aside from the psuedo Code, I have nothing yet. I will reuse this function over and over again. So I think the table valued function is the way...

Oops, I copy and pasted it myself, and I thought something looked odd.

Slooowww dowwwnnn!

Have a great day guys!

Thanks guys for your input.

I must try the COALSCE, I'm sure in the past I have been making things more difficult for myself than need be.

Thanks again!

Thanks jpipes,

I agree, after my post I tried the ISNULL function which WOULD be more efficient in this case. It gives me back what I expect.

Thanks again,

Chris

How do I bring the join in if I am not including a column in the select? Would I do a LEFT OUTER JOIN?

Sorry for the simplistic...

Ahh. Now that makes sense. Sometimes I'm out of touch with the app side.

That is exactly what is happening. Thanks!

Christine Aurora

I agree, which is why I asked. The powers that be, just passed down this schema change which required me to add a few columns to a table. ...

the key field data type is smallint, and I am migrating it (inserting) into a smallint field.

Here's the error message:

%ls statement conflicted with %ls %ls constraint '%.*ls'. The...

Thanks Greg!

Thanks jpipes, yes I left off the where and from clauses for these purposes. I'm only interested in the eror I'm getting from the CAE statement.

It really doesn't make...

Thanks for all your help and responses. I'll keep you posted on the progress.

Thanks for all your help and responses. I'l keep you posted on the progress.

The sproc performs an INSERT into a dbo.table if the @variable is NOT NULL. However, its not performing the insert (the value being passed is NULL. So it...

I am checking to see IF @variable IS NULL.

=============================================

Thanks for the article, it explained why it behaved differently when I turned ON/OFF ANSI_NULL.

=============================================

Is there anyway I can improve the performance...

Yes, IF the column is NOT NULL THEN an INSERT BEGINS.

However, my test case is passing a null, so no insert should take place but it takes an extra 7...