When I Run that query, I get the below error...

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the nvarchar value '20VM' to data type int.

Ok, Here's more info..

This value is our PC Domain Name and in the name we indicate the MMYY in which it was built. We are on a 48 Month...

Hi Lowell..

When I ran the modified query, I get the following error...

OLE DB provider "SQLNCLI11" for linked server "DBServer1" returned message "Deferred prepare could not be completed.".

Msg 8180, Level 16,...