Thank you. I was all over it like butter on a roll, but was missing just a
small piece.
Thanks again,
Mike
On 7/2/07, Matthew Wills <[EMAIL PROTECTED]> wrote:
Mike,
>> How can I create a JOIN that excludes records based on two columns? If
I
have one rowset that contains two columns that are keyed to another
rowset of the same two columns, how can I get only those rows that are in
the 2nd rowset that are not included in the 1st rowset?
Not really a .NET question, but:
SELECT TableA.*
FROM TableA LEFT OUTER JOIN TableB on TableA.C = TableB.C AND TableA.D =
TableB.D
WHERE TableB.C IS NULL
Seeya
Matthew Wills | Senior Analyst Programmer | Adviser Tools and Services |
Financial Planning and Third Party | NAB Technology
Phone: 02 9957 8183 | Mobile: 0435 002 520 | Email:
[EMAIL PROTECTED]
Mike Andrews
<outdoor.jellyrol
[EMAIL PROTECTED]> To
Sent by: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
"Discussion of cc
advanced .NET
topics." Subject
<ADVANCED-DOTNET@ Re: [ADVANCED-DOTNET] Cross-Server
DISCUSS.DEVELOP.C Queries
OM>
03/07/2007 08:04
AM
Please respond to
"Discussion of
advanced .NET
topics."
<ADVANCED-DOTNET@
DISCUSS.DEVELOP.C
OM>
Thanks Phil.
Yes this would work, however I won't be able to use this due to security
restrictions with sql server 2005.
I therefore have to come up with something else. More than likely I'll
use
the linked server feature.
I do have another question - more or less a SQL question.
How can I create a JOIN that excludes records based on two columns?
If I have one rowset that contains two columns that are keyed to another
rowset of the same two columns, how can I get only those rows that are in
the 2nd rowset that are not included in the 1st rowset?
Thanks,
Mike
On 7/2/07, Phil Sayers <[EMAIL PROTECTED]> wrote:
>
> i think you can specify the connection string to the remote server in
the
> text of your query.
> Check sql books online for
>
> OPENDATASOURCE
> and
> OPENROWSET
>
>
> -----Original Message-----
> From: Discussion of advanced .NET topics.
> [mailto:[EMAIL PROTECTED] Behalf Of Mike Andrews
> Sent: Monday, July 02, 2007 2:34 PM
> To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
> Subject: [ADVANCED-DOTNET] Cross-Server Queries
>
>
> Guys,
>
> Perhaps I'm being crazy here, but is it possible to execute a cross-sql
> server query without having to set up a linked server in sql server?
> My problem is that I want to execute a sql statement against two
different
> databases located on two different servers but I don't really want a
> linked
> server (or I'd rather not if at all possible).
> Any suggestions?
>
> Thanks,
> Mike
National Australia Bank Ltd - ABN 12 004 044 937
This email may contain confidential information. If you are not the
intended recipient, please immediately notify us at [EMAIL PROTECTED] by
replying to the sender, and then destroy all copies of this email.
Except where this email indicates otherwise, views expressed in this email
are those of the sender and not of National Australia Bank Ltd. Advice in
this email does not take account of your objectives, financial situation, or
needs. It is important for you to consider these matters and, if the e-mail
refers to a product(s), you should read the relevant Product Disclosure
Statement(s)/other disclosure document(s) before making any decisions. If
you do not want email marketing from us in future, forward this email with
"unsubscribe" in the subject line to [EMAIL PROTECTED] in order
to stop marketing emails from this sender. National Australia Bank Ltd does
not represent that this email is free of errors, viruses or interference.
===================================
This list is hosted by DevelopMentor(r) http://www.develop.com
View archives and manage your subscription(s) at
http://discuss.develop.com
===================================
This list is hosted by DevelopMentor® http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
