That looks like a security issue to me. "Access denied" usually means they don't have the necessary login rights.

I just tried using your XML with the value XML method, and it seems to work as documented. I don't have your schema, so I had to simplify a...

Check the default trace on the server. See if a disable command is being issued.

I'd have one table with the item ID and it's default description, and another table with the PK on item ID and customer ID, and the customer-specific description. Then...

Try cast/convert on @tbl_num in the last line of your case statement. That should do it for you. Case statements go with the usual implicit conversion rules. ...

You're welcome.

Yes, Jack, that's what I already suggested on the other copy of this same question. 🙂

I would seriously rethink this solution. Customer-generated descriptions should, really, be in a separate sub-table.

Otherwise, you're likely to end up with two or more descriptions for the same item...

Instead of deleting and re-seeing, have you thought about using truncate?

This thread is a cross-post. Please reply to the other copy, in T-SQL forum.

(As an aside, it already has IsDate in it. That won't solve it.)

Hmm! I've never done that. Learn something new every day. I just tried it, on a server with just one instance, and got an error about RPC...

The derived table not being processed first is exactly what I was refering to. That's why I've sometimes had to resort to a temp table instead of a derived...

How are you planning on using this? Is it something that a web page or other application will use to look up the address(es) for a specific customer? ...

Can you do a reverse lookup on it? Find all the rows where postal code "like '[0-9][0-9][0-9][0-9][0-9]' or like '[0-9][0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]'", and then exclude those from your lookup? Those...

You can't use flow-control like If...Else in views. You can in procs and user-defined functions. Are you actually trying to do this in a view?