Could you please explain what you are trying to achieve? What is the business case for this query (now I'm starting to sound life Jeff Moden)? How are...

ifila (1/13/2010)

---

create TABLE #OutputEmails

(

Email1 nvarchar(1000),

Email2 nvarchar(1000),

Email3 nvarchar(1000),

Email4 nvarchar(1000),

Email5 nvarchar(1000),

Email6 nvarchar(1000),

Email7 nvarchar(1000),

Email8 nvarchar(1000),

Email9 nvarchar(1000),

Email10 nvarchar(1000)

);

INSERT INTO #OutputEmails SELECT Email1,Email2,Email3,Email4,Email5,Email6,Email7,Email8,Email9,Email10 FROM OutputResume3

where (contains (originalresume, '"livelink" and "java"'))

select count(DISTINCT (Email)) FROM

(

SELECT...

ifila (1/13/2010)

---

GilaMonster (1/10/2010)

---

It probably...

ifila (1/13/2010)

---

GilaMonster (1/10/2010)

---

It probably...

Maybe, but I'm willing to try and help him. And looking at was...

Maybe, but I'm willing to try and help him. And looking at was...

ifila (1/12/2010)

---

USE [microsoft525]

GO

/****** Object: Table [dbo].[OutputResume3] Script Date: 01/12/2010 22:58:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[OutputResume3](

[ID3] [int] IDENTITY(1,1) NOT NULL,

[OriginalResume] [nvarchar](max) NULL,

[Email1] [nvarchar](1000) NULL,

[Email2] [nvarchar](1000)...

Lynn Pettis (1/9/2010)

---

bitbucket-25253 (1/9/2010)

---

Take a look at this one

http://www.sqlservercentral.com/Forums/Topic844889-392-1.aspx

It is one of the worst I have seen on SSC in a long long time.

Lynn - I must compliment you on...

ifila (1/12/2010)

---

I did get a couple of suggestions.

Use

CREATE PARTITION FUNCTION

or

CREATE PARTITION SCHEMA

.....but as you all know i suck at SQL, so i really dont know exactly how to use this...

Okay, now it has been over 2 days. Have you gotten an answer to your question?...

Paul White (1/12/2010)

---

Lynn Pettis (1/12/2010)

---

Or, since this is SQL Server 2005, a DDL trigger on the three tables that dynamically rebuilds the view when ever one of the three tables...

BH-428850 (1/12/2010)

---

Yes, I knew what the problem is and that is has to do with duplicate columns not being unique. I figured I could use dynamic sql in order to...

tosscrosby-60625 (1/12/2010)

---

Obstinate - reminds me of my 15 year old daughter (and my other daughter when she was about the same age!!). They do mellow as they get older, thank...

The problem is duplicate column names between the tables. If the columns names in all the tables were guarantteed to be unique, you could get away with the *...

crookj (1/12/2010)

---

Darn - Missed ya by a day. We...