I guess the app is bombing out because the data type conversion error has severity level 16.

If it's possible for a value greater than smallint can hold to be passed...

I think all you can really do here is check @@error to see if it is non-zero after the procedure call and then use the value of @@error to interrogate...

Thanks for the additional info. First off, you will need to select any columns in the order by clause in each UNION select statement. It's important that you...

The XML you provide shows data in a relational structure. You say all of the data is stored in a single table. How does the relational data map...

How is the data structure shown in your XML example represented in the trms_units table? A bit more info about the data might help.

It's true that this question can be answered with a small amount of research - I did the same thing. However, the point of the question isn't always knowing...

Could you move the work of the select statement to a stored procedure and include the update stuff there, thus keeping the work that needs to be done together, then...

Doh! Of course - why do it your own long-winded way when there is a T-SQL function?!

No worries! If you can't solve your other problem, it may be worth posting a code snippet to see if anyone can help.

You're absolutely right! It was only when I re-read the question that I realised I had completely (and blindly!) assumed the middle part of that. Maybe I'm just...

Well, I answered the question correctly but reading these posts am kind of embarrassed not to have thought more about it and got it wrong instead ...

But I guess re-reading the wording of the question, it's a matter of interpretation

It doesn't say create a PK clustered index. It says drop the PK clustered index and create a clustered index on the LAST_ORDER_DATE column. There's no mention ...

If what you need is to check only the final character to see if it's numeric, you could do something like this:

if (right(@var_or_column_here, 1) like '[0...

Afraid for the moment I've exhausted my ideas - indexed views are definitely not my are of expertise, but I'll let you know if I have a flash of inspiration....