Gatekeeper (1/13/2010)

---

Whoops, wrong window on the copy and paste but makes me wonder if the initial FULL was done with the improper arguments. But had that been the case, wouldn't...

Gatekeeper (1/13/2010)

---

Today, one of my tests failed for checking database backups. I tried restoring via SSMS by selecting the FULL and most recent DIFF in the history and restore on...

A count of unique email addresses, I am assuming as well. Does the user have the option to restrict the date range on the search?

If so, I would also...

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