Thank you Eugene and GSquared.

Eugene, the NOT IN looks like a much better/easier/readable join.

GSquared i love your signature ROFL,LOL,ETC .... 😀

I don't think it can get any better.

This is a nice solution. However when we have hundred other files for similar process it will eventually lock a considerable memory forever.

I was thinking of having split the task...

I have tried the below query but it does not cover all the cases, especially when the pattern is like #[number][string]

The output of query is attached to this post.

SELECT

DataID

,Data

,LEN(Data) AS...

Thanks for the link, but i was looking for a non-clr solution.

I am trying hard but am not able to go further.

To start with i am first trying to get the below output, will drill down for more later

<Customers>

<Customer...

George thanks for the first link, it will help me in querying for xml datatypes.

Also thanks for the second link, will try it out and post my query here.

Thanks Gianluca for the quick reply.

this is good.

wish it had also given list of distinct matching words found in the object definition.

😀

still awaiting for a solution.

anybody out there please help...

Thanks Ken. Your solution worked perfect 🙂

Hi All,

I wonder if there is an option somewhere to consolidate each notification in a single mail rather than having one mail per job. Something like a digest mail.

Thanks Jack, Jeff and Jacob 🙂

I implemented it this way.

http://www.sqlservercentral.com/Forums/Topic465522-338-1.aspx?Highlight=split

http://www.sqlservercentral.com/articles/Datetime+Manipulation/61822/

[Code]

DECLARE @Delim CHAR(1)

SET @Delim = ','

;WITH L0 AS (SELECT 1 AS C UNION ALL SELECT 1), --2 rows

L1 AS (SELECT 1...