🚀 go-pugleaf

> I need to do this maneuvre in one go, and not via many calls. Is there a way to 
> do this? 

Jeg h�ber ikke jeg misforst�r dig.... men du joiner to tabeller, fra
to forskellige databaser p� denne m�de:

SELECT db1.dbo.table1.field1, db2.dbo.table2.field2
FROM db1.dbo.table1 INNER JOIN db2.dbo.table2 ON db1.dbo.table1.field1
= db2.dbo.table2.field2

Herefter burde du kunne lave dit udtr�k s�dan her:

SELECT * FROM OpenQuery(INSQL,"
  SELECT DateTime, B1G, B1S, B2W, B3G
  FROM Runtime.dbo.AnalogWideHistory
  WHERE DateTime >= (
    SELECT TOP 1 Resource.Time 
    FROM Lot, Resource
    WHERE LotId like '0105M3'
      AND Route=1
      AND Lot.time=Resource.time) AND
      DateTime <= (
        SELECT TOP 1 Resource.Time
        FROM Lot, Resource
        WHERE LotId like '0105M3'
          AND Lot.Transaction='COMPLETE'
          AND Lot.time=Resource.time) AND
        wwresolution=100")

"TOP 1" skal v�re med n�r du bruger ">= / <=", ellers "IN"....