Try this out for a size

😎

DECLARE @TXML XML = '<SEARCHREQUESTRESULT><DOCUMENTS><DOCUMENTDETAIL><DOCUMENTDATE/><CONSIDERATIONAMOUNT>0</CONSIDERATIONAMOUNT><BOOK/><PAGE/><REFERENCENUMBER>APPOINT TRUSTEE FOR POWER OF SALE</REFERENCENUMBER><NOTES/><RETURNEDTO/><PARTIES><PARTY><ID>940</ID><NAME>MARINER HOUSE COUNCIL OF CO-OWNERS INC</NAME><ADDITIONALNAME/><PARTYTYPEID>1</PARTYTYPEID><TYPE/><ADDRESS1/><ADDRESS2/><CITY/><STATE/><ZIPCODE/><ATTRIBUTE/><SESSIONID>0</SESSIONID></PARTY><PARTY><ID>941</ID><NAME>DOYLE</NAME><ADDITIONALNAME>PATRICK F</ADDITIONALNAME><PARTYTYPEID>2</PARTYTYPEID><TYPE/><ADDRESS1/><ADDRESS2/><CITY/><STATE/><ZIPCODE/><ATTRIBUTE/><SESSIONID>0</SESSIONID></PARTY><PARTY><ID>942</ID><NAME>BETTISON</NAME><ADDITIONALNAME>DENNIS R</ADDITIONALNAME><PARTYTYPEID>2</PARTYTYPEID><TYPE/><ADDRESS1/><ADDRESS2/><CITY/><STATE/><ZIPCODE/><ATTRIBUTE/><SESSIONID>0</SESSIONID></PARTY><PARTY><ID>943</ID><NAME>APFFEL</NAME><ADDITIONALNAME>DARRELL A</ADDITIONALNAME><PARTYTYPEID>2</PARTYTYPEID><TYPE/><ADDRESS1/><ADDRESS2/><CITY/><STATE/><ZIPCODE/><ATTRIBUTE/><SESSIONID>0</SESSIONID></PARTY><PARTY><ID>944</ID><NAME>SHABOT</NAME><ADDITIONALNAME>S BENJAMIN</ADDITIONALNAME><PARTYTYPEID>2</PARTYTYPEID><TYPE/><ADDRESS1/><ADDRESS2/><CITY/><STATE/><ZIPCODE/><ATTRIBUTE/><SESSIONID>0</SESSIONID></PARTY><PARTY><ID>945</ID><NAME>BAKER</NAME><ADDITIONALNAME>ETHAN</ADDITIONALNAME><PARTYTYPEID>2</PARTYTYPEID><TYPE/><ADDRESS1/><ADDRESS2/><CITY/><STATE/><ZIPCODE/><ATTRIBUTE/><SESSIONID>0</SESSIONID></PARTY></PARTIES><LEGALS/><LEGALDETAILS/><FEES/><ASSOCIATEDDOCUMENTS/><ID>752</ID><NAME>2014048673</NAME><DOCSTATE>A</DOCSTATE><RECORDEDDATETIME>8/27/2014 8:19:03 AM</RECORDEDDATETIME><TYPE><DOCUMENTTYPE><ID>583</ID><CODE>RESOLUTION</CODE><NAME>RESOLUTION</NAME><SESSIONID>0</SESSIONID></DOCUMENTTYPE></TYPE><PARTY1>MARINER HOUSE COUNCIL OF CO-OWNERS...

Quick suggestion for a solution, if I got the description right;-)

😎

;WITH BASE_DATA(

DEP_ACCOUNT_NO

,DEP_SERVICED_AMT

...

Quick thought, is it possible that you were connecting to a different server yesterday?

😎

Quick thought, can you change this to a stored procedure and set default values for the parameters?

😎

Quick thought, run db-compare on source and destination to rule out changes on either end, something definitely has changed, question is what.

😎

Setting the nocount on eliminates network jitter such as count of affected rows, generally a good practice.

😎

No problem there, temp tables are isolated by sessions, as long as they are not global (start with a double hash ##).

😎

Quick thought, looks like the browser service is not working.

😎

Good stuff, make certain you get the spelling right:-D

😎

klgould1 (9/17/2014)

---

Hoping someone maybe able to assist with this procedure.

I am trying to increase the price of an product by a user entered % for items with Dishwasher in the...

Maybe this article Migrating a Database to SQL Azure using SSDT will help

😎

nikhil.desai1 (9/19/2014)

---

Hi,

I our SQL server project we are using xp_cmdshell to generate .txt or .csv file. As per SQL sever hardening xp_cmdshell is a security risk. Is there any alternative...

Guess...

okbangas (9/20/2014)

---

I've searched a bit, and from what I can see, both Geometry and Gography stores the coordinates as IEEE 754 64-bit float internally, hence there is no difference in...

enriquemallon (9/20/2014)

---

I am trying to add a new user to an SQL Server 2012 database using SQL Server Management Studio. I right-click and select 'Add User' under Security -> Users,...