sql - Select qry to using 2 databases -

-

i have below query:

select       --a.dateentered,      --a.inventoryid,      a.sku, a.qtyonhand,      b.dateentered vdateentered,      b.golive, b.dateonsite, b.costprice,      --a.currentprice,      m.name status,      hrf.category, hrf.department, hrf.brandedob, hrf.division,      hrf.fascia,      (a.qtyonhand * b.costprice) cost_value,      null item_quantity, null item,      null season, hrf.company,      (a.qtyonhand * b.currentprice) sellilng_value,      b.merchandisingseason, b.costprice costprice_rp,      b.currentprice, b.inventoryid,      -- a.averageunitcost,      -- a.averageunitcost rp_stk_averageunitcost,      -- a.currentprice rp_stk_current_price,      -- a.statusid,      -- a.quantity_sign,      (a.qtyonhand * b.costprice) cost_value_rp,      (a.qtyonhand * b.averageunitcost) awc_value           -- a.stockreconciliationid,      -- a.averageunitcost,     [dbo].[fc03qty] join      dbo.inventory b on a.sku = b.sku left join     (------hierarchy-------      select           ih.inventoryid, hry.category, hry.department,          hry.brandedob, hry.division, hry.fascia, hry.company               (select               ihn.hierarchynodeid, ihn.inventoryid           bm.inventoryhierarchynode ihn           group ihn.hierarchynodeid, ihn.inventoryid) ih      join           (select                g.categoryid, g.category, h.department, i.brandedob,               j.division, k.fascia, l.company                          category g (nolock)           join               department h on g.departmentid = h.departmentid           join               brandedob (nolock) on h.brandedobid = i.brandedobid           join               division j (nolock) on i.divisionid = j.divisionid           join               fascia k (nolock) on j.fasciaid = k.fasciaid           join               company l (nolock) on k.companyid = l.companyid           group               g.categoryid, g.category, h.department,               i.brandedob, j.division, k.fascia, l.company) hry on ih.hierarchynodeid = hry.categoryid      group          ih.inventoryid, hry.category, hry.department,          hry.brandedob, hry.division, hry.fascia, hry.company) hrf on b.inventoryid = hrf.inventoryid join     inventorystatus m (nolock) on b.statusid = m.statusid

it using 2 tables -

  • [dbo].[fc03qty] a

and

  • dbo.inventory b

that joined @ sku level.

[dbo].[fc03qty] on scratch database , dbo.inventory on reports database.

how can query use these tables if on 2 different db?

any advice received.

in sql server syntaxis tables [database name].[schema name].[table name]

so need this:

select a.*, b.*       database1.dbo.table1  a,       database2.dbo.table2  b

Comments

Post a Comment

Popular posts from this blog

javascript - Chart.js (Radar Chart) different scaleLineColor for each scaleLine -

-
Image
i try , create radar chart using chart.js has various colours each scaleline, or coloured between scalelines. wondering if possible? from: to: i have working graph, though there doesn't seem method change individual scale lines. kind regards leigh you can extend radar chart type this, so chart.types.radar.extend({ name: "radaralt", initialize: function (data) { chart.types.radar.prototype.initialize.apply(this, arguments); var originalscaledraw = this.scale.draw; var ctx = this.chart.ctx; this.scale.draw = function () { var linewidth = this.linewidth; // bypasses line drawing in originalscaledraw this.linewidth = linewidth; originalscaledraw.apply(this, arguments); ctx.linewidth = this.linewidth; var scale = this; // draw chart.helpers.each(scale.ylabels, function (label, index) { // color of ...
Read more

apache - Error with PHP mail(): Multiple or malformed newlines found in additional_header -

-
suddenly have started receiving above error without changes having been made script. host 1and1 (i know...) the script still works fine on different server, , suspicion there must have been server config change has lead this, although hosts plead ignorance. there's no information on above error @ in google can find - have ideas? server running apache if helps. had similar problem. came out of blue. no php code changed. what changed: php upgraded 5.5.25-1 5.5.26. a security risk in php mail() function has been fixed , newlines in additional_headers allowed no more. because newlines mean: starts email message (and surely don't want inject newlines through headers followed evil message). what have worked fine, e.g. having newlines after headers or passing whole message additional_headers , function no more. solution : sanitize headers. no multiple newlines in additional_headers argument. these count "multiple or malformed newlines":...
Read more

java - Android – MapFragment overlay button shadow, just like MyLocation button -

-
Image
i'm struggling add shadow custom overlay button on google map. goal make custom button google's mylocation button. here's how app looks now: layout.xml <relativelayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" xmlns:map="http://schemas.android.com/apk/res-auto" android:layout_height="match_parent" android:layout_width="match_parent" style="@style/apptheme"> <fragment android:layout_width="match_parent" android:layout_height="match_parent" android:id="@+id/map" tools:context=".mapsactivity" android:name="com.google.android.gms.maps.supportmapfragment" android:layout_alignparentend="true" android:layout_alignparentstart="true" android:layout_alignparentbottom="true" ...
Read more