A single column Unique constraint can have only one Null value (unless you use the filtered index version of a unique index) which some debate is not a constraint).

And if you remove the top 8?

tbmabry (1/3/2013)

---

Ok, I know you are sick of me. I know I am just going crazy over this. I have to get this done and can't figure this out...I can't...

Two quick methods include replication and logshipping.

And here is the MS Reference (note the careful wording of One Null Value per Column is wrong if you run the test code I provided in the previous link)

http://msdn.microsoft.com/en-us/library/ms191166(v=sql.105).aspx

There...

Here is the example

http://www.sqlservercentral.com/Forums/FindPost1398825.aspx

dineshbabus (1/3/2013)

---

I think few days back same conversation happened... Unique constraint is different from unique index. While creating unique index we can create with filter and that will allow more...

The script referred to as option #1 is the first script in Dwain's first response on this thread.

That...

How many connections? Do you have a high volume of transactions or jobs running currently?

Is CmdExec agent job type an option?

dwain.c (1/3/2013)

---

SQLRNNR (1/3/2013)

---

dwain.c (1/3/2013)

---

tbmabry (1/3/2013)

---

Ok, thanks. I found one of them that is making it blow up. It is that the note only has earl@dcande.com with nothing else so no...

dwain.c (1/3/2013)

---

tbmabry (1/3/2013)

---

Ok, thanks. I found one of them that is making it blow up. It is that the note only has earl@dcande.com with nothing else so no space before...

Try this

WITH presel AS (

SELECT s.FirstName, s.LastName, c.CustomerNo, h.OppNo, ' ' + n.Note AS Note

FROM SalesLink_SalesRep s

INNER JOIN SalesLink_Prospect_SalesRepCustomerXrf c

ON c.SalesRepId = s.SalesRepId

INNER JOIN Opportunity_Header h

ON c.CustomerNo = h.CustomerNo

INNER JOIN...

I have to disagree with the correct answer(s). The question asks for 4 correct answers yet 5 are presented. This causes a bit of a guessing game.