Hi and welcome to the forum.

This error message...

bobba (9/21/2014)

---

I've got a TempDB database approximately 40 GB (SQL 2008 EE). I've been instructed to add some data files to it. That process seems pretty straight forward...

Outer apply acts as a left outer join, otherwise...

Spamming has definitely reached new heights, forums are fobar, points and threads dropping like flies, something must be done to stop this. First thought is that no one ever posts...

Quick amendment to the code, only unpacking the hyphened serial values

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SerialNumber VARCHAR(1024) = '1000-1010,1230,1234,1235,1236,1239,1244,1250-1260';

-- Return only the requested serial numbers

;WITH E1(N) AS (

...

selpoivre (9/19/2014)

---

Thanks for this solution.

Is this possible i get old dated wan and new dated wan according to activation_date column.?

Activation date of both wan compared then old dated wan...

k.kavitha236 (9/21/2014)

---

Hello,

Could some one suggest me the transformation i need to use in SSIS. Please find the excel sheet attached

I want to know how many times Response 1 has occured...

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.

😎