Pirate92 (1/23/2013)

---

SELECT C.FIRSTNAME,C.LASTNAME,A.ADDRESS1,A.ADDRESS2,A.CITY,A.STATE,A.POSTALCODE,A.COUNTRY,

C.WORKPHONE,C.EMAIL,EH.ENROLLSTATUS

FROM SYSDBA.EVXENROLLHX EH

INNER JOIN SYSDBA.EVXEVENT E ON EH.EVXEVENTID = E.EVXEVENTID

INNER JOIN SYSDBA.EVXEVTICKET ET ON EH.EVXEVTICKETID = ET.EVXEVTICKETID

INNER JOIN SYSDBA.CONTACT C ON ET.ATTENDEECONTACTID = C.CONTACTID

CASE

WHEN DESCRIPTION LIKE 'Shipping%' THEN...

There is no such thing as SQL 2010. Are you perhaps talking about Visual Studio 2010? If so, is it a database project? You probably could deploy...

mbova407 (1/22/2013)

---

Good question but this real doesn't have to do with the data type bit but instead about reading double negatives

IF NOT EXISTS (SELECT 1 WHERE @BIT IS NOT...

There is no such thing as SQL Server 2010. I believe you are referring to SQL 2008 R2.

In either case, you won't be able to detach and attach, or...

mtassin (1/18/2013)

---

You can still get it wrong like I did...

SQL 2008R2 RTM - No...

You can still get it wrong like I did...

SQL 2008R2 RTM - No rows...

Blah... I hate to get it wrong because I absentmindedly clicked on False and didn't pay attention and clicked submit when I was trying to select True.

Lol... -1 point for...

Good question Wayne. Thanks!

I must concur... that's a neat function that I had missed. I got this one right because there was...

Hugo Kornelis (1/11/2013)

---

P.S. The article by Pinal Dave that is referenced only compares anti-semi-join with NOT IN, not with NOT EXISTS; they are not always equivalent (when NULL values can...

Thanks for an easy one

mbova407 (1/10/2013)

---

I would have thought

SELECT @a + @b-2 * @C AS 'Result #4'

would have been more challenging without the parentheses for most...

How about the 2% who...

Koen Verbeeck (1/8/2013)

---

Not sure what this question tries to teach us.

I spend 5 minutes looking for a mistake, only to finally decide there wasn't one, all joins seemed legit. I...

+1 I must agree... was a lot of fun to sit there pondering if all of the various data types would be...