Klos, Susan
Susan.Klos at fldoe.org
Mon May 8 14:25:18 CDT 2006
Susan Klos
Senior Database Analyst
Evaluation and Reporting
Florida Department of Education
850-245-0708
sc 205-0708
Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Susan.Klos@fldoe.org|15:25:21%20Mon%2008%20May%202006
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
dba-sqlserver-request at databaseadvisors.com
Sent: Monday, May 08, 2006 1:00 PM
To: dba-sqlserver at databaseadvisors.com
Subject: dba-SQLServer Digest, Vol 39, Issue 6
Send dba-SQLServer mailing list submissions to
dba-sqlserver at databaseadvisors.com
To subscribe or unsubscribe via the World Wide Web, visit
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
or, via email, send a message with subject or body 'help' to
dba-sqlserver-request at databaseadvisors.com
You can reach the person managing the list at
dba-sqlserver-owner at databaseadvisors.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of dba-SQLServer digest..."
Today's Topics:
1. Re: another nudge on that DELETE, OUTER JOIN quirk
(MartyConnelly)
2. Re: another nudge on that DELETE, OUTER JOIN quirk
(Susan Harkins)
3. Re: another nudge on that DELETE, OUTER JOIN quirk
(Susan Harkins)
----------------------------------------------------------------------
Message: 1
Date: Sun, 07 May 2006 12:36:01 -0700
From: MartyConnelly <martyconnelly at shaw.ca>
Subject: Re: [dba-SQLServer] another nudge on that DELETE, OUTER JOIN
quirk
To: dba-sqlserver at databaseadvisors.com
Message-ID: <445E4C21.1080200 at shaw.ca>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Are you specifying which table to delete from
DELETE DISTINCTROW Original_Table.* FROM Original_Table LEFT JOIN ...
or
DELETE Original_Table.* FROM Original_Table LEFT JOIN ...
Susan Harkins wrote:
>I've been experimenting a bit with the DELETE on an OUTER JOIN, and so
far,
>I've not been able to run a single DELETE on any query that contains an
>OUTER JOIN -- I understand the null ability business, but I think what
all
>that technique mumbo jumbo really means is, you can't use DELETE with
an
>OUTER JOIN -- anyone know for sure about this?
>
>Susan H.
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>
>
--
Marty Connelly
Victoria, B.C.
Canada
------------------------------
Message: 2
Date: Sun, 7 May 2006 15:48:35 -0400
From: "Susan Harkins" <harkinsss at bellsouth.net>
Subject: Re: [dba-SQLServer] another nudge on that DELETE, OUTER JOIN
quirk
To: <dba-sqlserver at databaseadvisors.com>
Message-ID: <003501c6720f$3b585b40$9bb3d6d1 at SUSANONE>
Content-Type: text/plain; charset="us-ascii"
No:
DELETE
FROM one LEFT JOIN many
ON one.column = many.column
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
MartyConnelly
Sent: Sunday, May 07, 2006 3:36 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] another nudge on that DELETE, OUTER JOIN
quirk
Are you specifying which table to delete from
DELETE DISTINCTROW Original_Table.* FROM Original_Table LEFT JOIN ...
or
DELETE Original_Table.* FROM Original_Table LEFT JOIN ...
Susan Harkins wrote:
>I've been experimenting a bit with the DELETE on an OUTER JOIN, and so
>far, I've not been able to run a single DELETE on any query that
>contains an OUTER JOIN -- I understand the null ability business, but I
>think what all that technique mumbo jumbo really means is, you can't
>use DELETE with an OUTER JOIN -- anyone know for sure about this?
>
>Susan H.
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>
>
--
Marty Connelly
Victoria, B.C.
Canada
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.5/333 - Release Date: 5/5/2006
------------------------------
Message: 3
Date: Sun, 7 May 2006 15:54:08 -0400
From: "Susan Harkins" <harkinsss at bellsouth.net>
Subject: Re: [dba-SQLServer] another nudge on that DELETE, OUTER JOIN
quirk
To: <dba-sqlserver at databaseadvisors.com>
Message-ID: <003601c67210$019fa240$9bb3d6d1 at SUSANONE>
Content-Type: text/plain; charset="us-ascii"
I tried yours -- the only difference seems to be that you specified the
non-nullable table. Using the following statement, I still got an error:
DELETE Customers.*
FROM Customers LEFT JOIN Orders
ON Customers.CustID = Orders.CustID
I'm using Express -- prehaps the two versions aren't compatiable on this
issue?
Susan H.
Are you specifying which table to delete from
DELETE DISTINCTROW Original_Table.* FROM Original_Table LEFT JOIN ...
or
DELETE Original_Table.* FROM Original_Table LEFT JOIN ...
------------------------------
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
End of dba-SQLServer Digest, Vol 39, Issue 6
********************************************