Steve Jones - SSC Editor (9/22/2014)

---

There was no chance to get the log...

Handful of posts missing, did you break the log chain;-)

😎

There are some other topics missing, some points also went missing, all happened more or less at the same time.

😎

Not certain what is causing the problem, nothing in the code should limit the length apart from the maximum 2Gb limit of the varchar(max). Consider the following example

😎

GO

SET NOCOUNT ON;

/*...

Thank you Gail for this nice piece!

It in fact highlights a constant battle, challenging pinhole view, missing metrics, personal opinions etc., things which far to often, but wrongly, drive optimization...

serg-52 (9/22/2014)

---

abhas (9/18/2014)

---

Yes Erirukar,

There are more rows for CanNum as below: and in such case its failing. I want to compare only latest two.

I can Add one more column into...

The browser service's...

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...