Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.programmer > #38443

Re: Is there a SQL hashmap?

X-Received by 2002:a0c:e841:: with SMTP id l1-v6mr4498535qvo.1.1530157981554; Wed, 27 Jun 2018 20:53:01 -0700 (PDT)
X-Received by 2002:a25:5f4a:: with SMTP id h10-v6mr796101ybm.5.1530157981398; Wed, 27 Jun 2018 20:53:01 -0700 (PDT)
Path csiph.com!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder-in1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!h2-v6no1132195qtp.0!news-out.google.com!u13-v6ni432qtg.0!nntp.google.com!h2-v6no1132188qtp.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups comp.lang.java.programmer
Date Wed, 27 Jun 2018 20:53:01 -0700 (PDT)
In-Reply-To <ph19nj$126q$1@gioia.aioe.org>
Complaints-To groups-abuse@google.com
Injection-Info glegroupsg2000goo.googlegroups.com; posting-host=2601:644:200:6f11:9159:b3e4:35d2:86c9; posting-account=7ixWyAoAAAADqEcP1-y81qi5CF4UEB_d
NNTP-Posting-Host 2601:644:200:6f11:9159:b3e4:35d2:86c9
References <031dadbc-3c27-4021-9b1d-8cb860c5e9f6@googlegroups.com> <fpfmegF9ol2U1@mid.individual.net> <34af17f0-0d59-4b87-8af0-01ce37deb5cb@googlegroups.com> <ph19nj$126q$1@gioia.aioe.org>
User-Agent G2/1.0
MIME-Version 1.0
Message-ID <1ed30aa2-e8cd-47f7-958e-9cd6f487dff9@googlegroups.com> (permalink)
Subject Re: Is there a SQL hashmap?
From firstsql@gmail.com
Injection-Date Thu, 28 Jun 2018 03:53:01 +0000
Content-Type text/plain; charset="UTF-8"
Content-Transfer-Encoding quoted-printable
Lines 34
Xref csiph.com comp.lang.java.programmer:38443

Show key headers only | View raw

On Wednesday, June 27, 2018 at 5:22:23 PM UTC-7, Arne Vajhøj wrote:
> On 6/26/2018 5:02 PM, Eric Douglas wrote:
> > On Tuesday, June 26, 2018 at 4:36:44 PM UTC-4, Robert Klemme wrote:
> >> On 26.06.2018 18:03, Eric Douglas wrote:
> >>> Just a better syntax to do such a thing within the SQL, or a way to
> >>> pass the values as a parameter?  Ideally I would just create a table
> >>> and write the values there and join that table, but I don't want to
> >>> alter that database which was created by our third party
> >>> application.
> >>
> >> Another option might be to create another database on the same server
> >> with the new table and join cross databases if SQL Server can do that.
> 
> > Right.  I am familiar with IFF, not with CASE, sounds good I'll check that out.
> 
> > I don't think the SQL can join tables from 2 different databases but would be nice if it can, needs researched.
> 
> Generally you can't.
> 
> Usually you can.
> 
> You can in MS SQLServer
> 
> Just refer to the tables as somedatabasename.dbo.sometablename and it 
> should work.
> 
> Arne

The general name is Federated Database or Federated SQL.

Sounds like a great idea, but optimization is severely crippled.

Lee Fesperman, FirstSQL Software

Back to comp.lang.java.programmer | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-26 09:03 -0700
  Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-26 12:23 -0400
  Re: Is there a SQL hashmap? Robert Klemme <shortcutter@googlemail.com> - 2018-06-26 22:36 +0200
    Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-26 14:02 -0700
      Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-27 20:22 -0400
        Re: Is there a SQL hashmap? firstsql@gmail.com - 2018-06-27 20:53 -0700
        Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-28 05:03 -0700
          Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-28 06:49 -0700
            Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-28 07:38 -0700
              Re: Is there a SQL hashmap? Andreas Leitgeb <avl@logic.at> - 2018-06-28 15:52 +0000
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-28 19:47 +0000
                Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-28 18:34 -0400
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-28 23:20 +0000
                Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-28 20:07 -0400
                Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-29 05:11 -0700
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-29 12:30 +0000
                Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-06-29 06:11 -0700
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-29 13:43 +0000
                Re: Is there a SQL hashmap? Robert Klemme <shortcutter@googlemail.com> - 2018-06-29 23:20 +0200
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-29 22:34 +0000
                Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-30 16:36 -0400
                Re: Is there a SQL hashmap? Martin Gregorie <martin@mydomain.invalid> - 2018-06-30 23:00 +0000
              Re: Is there a SQL hashmap? Robert Klemme <shortcutter@googlemail.com> - 2018-06-29 23:34 +0200
            Re: Is there a SQL hashmap? Arne Vajhøj <arne@vajhoej.dk> - 2018-06-30 17:51 -0400
              Re: Is there a SQL hashmap? Eric Douglas <e.d.programmer@gmail.com> - 2018-07-03 07:13 -0700

csiph-web