MODEL 01:

name email A B C D

aa john@test.com 0 0 1 1

bb rick@test.com 0 1 0 1

cc sally@test.com 0 1 1 0

dd aha@test.com 1 1 0 0

What would make...

Model 1. Doesn't require the parsing of the data that Model 2 would.

Congrats! ...

OMG

Also:

CREATE TABLE dbo.ATest(

TestId INT IDENTITY(1,1),

TestData TEXT

);

INSERT INTO dbo.ATest (TestData)

SELECT 'Row1' UNION ALL

SELECT 'Row1' UNION ALL

SELECT 'Row1' UNION ALL

SELECT 'Row2' UNION ALL

SELECT 'Row2'...

CREATE TABLE dbo.ATest(

TestId INT IDENTITY(1,1),

TestData TEXT

);

INSERT...

komal145 (5/18/2012)

---

Expected:

Entry_id pendeddate newinfodate ...

Welsh Corgi (5/18/2012)

---

I will be able to use your script for other situations.

Thanks for pointing out the issues with the code.

I liked your use of CROSS APPLY, etc.

I'm sorry that...

Welsh Corgi (5/18/2012)

---

I will be able to use your script for other situations.

Thanks for pointing out the issues with the code.

I liked your use of CROSS APPLY, etc.

I'm sorry that...

Elliott Berkihiser (5/18/2012)

---

You didn't indicate there was a witness, so this answer applies to a non-witnessed set-up. If the mirroring session is in High Protection mode and the mirror...

Welsh Corgi (5/18/2012)

---

What I need in the output is the Table Name, Column name, the Distinct Values & a record count.

TableName Column Name STATUS_OPEN ...

Mutt

Anyone care to join the party??

Welsh Corgi (5/18/2012)

---

I execute the following Statement:

Select 'DATED_TEXT','DATED_TEXT_RTF',DATED_TEXT_RTF, count(*) AS RecordCount From DATED_TEXT group by DATED_TEXT_RTF;

I get the following error:

Msg 306, Level 16, State 2, Line 582

The text,...

I think it is time for another party at the TitD. I may have found someone who has > 1 years experinece over 5+ years.