Derek Dongray (2/4/2009)

---

philcruz (2/4/2009)

---

vw_UnsubscribedEmails is

CREATE VIEW [dbo].[vw_UnsubscribedEmails]

AS

SELECT email, dateCreated, source

FROM dbo.unsubscribedEmails

UNION

SELECT email, NULL...

Lynn Pettis (2/4/2009)

---

Just curious (since we don't have the DDL for the tables, sample data for the tables, or expected results based on the sample data), what happens to your...

I want to filter out any sourceContacts that have a matching email in the customer table. Due to the LEFT JOIN, if there is no match by email then...

If use the initial query as a subquery and then filter by customerID IS NULL, i.e.

SELECT qry.sourceContactID

FROM

(

SELECT

...

Well, I'm executing the MDX query directly from Management Studio so I know the exact statement. I did try running profiler to see if it would give me the...

No, the password hasn't changed.

Is there a way to get a more detailed error message?

Yes, we are using full text search.

fyi, I updated the scripts to work on SQL Server 2005.

http://philcruz.com/blog/2006/04/more-intelligent-backup-and-restore.htm

I update the scripts to work on SQL Server 2005.

http://philcruz.com/blog/2006/04/more-intelligent-backup-and-restore.htm

I found the problem. The database was originally a SQL2000 db that was being replicated. It still had some tables like sysarticles. I dropped those tables and...

Soon after I posted I realized having orderdetailid and productid in the group by was causing the multiple rows. I made the changes like you describe and it works now....

Perfect. Thanks!

Nevermind. Turns out I was restoring a replicated version of the db that had the identity set to false. The restore of the backup of the primary db is...