SQL – mijloce fixe

Lasă un comentariu

11 Februarie 2015 de liviustoica55


SELECT T1.ASSETID, T1.ASSETGROUP, T1.NAME, T1.LOCATION,T1.DOCUMENTS, T1.SERIALNUM, T1.INSURANCEPOLICYNUM, T1.INSUREDVALUE, T1.MAKE, T1.MODEL, T1.GUARANTEEDATE, T1.MAINASSETID,
T1.ASSETTYPE, T1.QUANTITY, T1.BARCODE, T1.UNITOFMEASURE, T1.INSURANCEDATE1, T1.INSURANCEDATE2, T1.ASSETREPLACECOST, T1.SORTINGID, T1.TAXCOUNTYNO, T1.SUBVENTIONNO,
T1.SUBVENTIONTAXFREENO, T1.ASSESSMENTNO, T1.ASSESSMENTTAXNO, T1.ACQUISITIONVALUENO, T1.VALUEAT19840101NO, T1.RETURNONINVESTMENTSNO, T1.SORTINGID2, T1.SORTINGID3,
T1.NAMEALIAS, T1.TECHINFO1, T1.TECHINFO2, T1.TECHINFO3, T1.LASTMAINTENANCE, T1.NEXTMAINTENANCE, T1.MAINTENANCEINFO1, T1.MAINTENANCEINFO2, T1.PHYSICALINVENTORY, T1.REFERENCE,
T1.UNITCOST, T1.PURCHLINERECID, T1.ASSETPROPERTYGROUP, T1.ASSETACTIVITYCODE, T1.DEPARTMENT, T1.MAJORTYPE, T1.PARCELID, T1.PROPERTYTYPE, T1.GISREFERENCENUMBER,
T1.LOCATIONMEMO, T1.ROOMNUMBER, T1.MODELYEAR, T1.DISPOSALRESTRICTION, T1.LEASE, T1.TITLEHOLDER, T1.INSURANCEVENDOR, T1.INSURANCEAGENT, T1.POLICYEXPIRATION, T1.POLICYAMOUNT,
T1.LASTFACTORUPDATEDATE, T1.INSUREDATMARKETVALUE, T1.CONDITION, T1.WORKERCONTACTNAME, T1.WORKERRESPONSIBLE, T1.ISMISSING, T1.TAXICMSOUTGOING_BR,
T1.PISCOFINSRECEIVABLELONGTERM_BR, T1.ASSETSOURCETYPE_CN, T1.ICMSCREDITINSTALLMENTS_BR, T1.GOODSTYPE_BR, T1.TRANSFERREDFROMINVENTORY_BR, T1.ACQUISITIONPRICE_W,
T1.ACQUISITIONDATE_W, T1.DEFAULTDIMENSION, T1.ASSETPRODUCTIONYEAR_PL, T1.ALLOWSALE_PL, T1.CATEGORYID_LV, T1.PHYSICALASSETNUMBER_BR, T1.FISCALESTABLISHMENT_BR,
T1.EXCEPTIONTAXATIONRATE_JP, T1.ISRENTED_JP, T1.ISSECONDHAND_JP, T1.LENDERNAME_JP, T1.EXCEPTIONTAXATIONCODE_JP, T1.FATCURRENTRESPONSIBLE_RO, T1.FATRESPONSIBLE_RO,
T1.FATCURRENTLOCATION_RO, T1.MODIFIEDDATETIME, T1.DEL_MODIFIEDTIME, T1.MODIFIEDBY, T1.CREATEDDATETIME, T1.DEL_CREATEDTIME, T1.CREATEDBY, T1.RECVERSION, T1.PARTITION, T1.RECID,
T2.ASSETID AS Expr1, T2.BOOKID, T2.BOOKTYPE, T2.ACQUISITIONDATE, T2.ACQUISITIONPRICE, T2.ASSETGROUP AS Expr2, T2.DISPOSALDATE, T2.USEDFROMDATE, T2.DEPRECIATIONSTARTDATE,
T2.LASTDEPRECIATIONDATEEXTRAORD, T2.STATUS, T2.SORTINGID AS Expr3, T2.SORTINGID2 AS Expr4, T2.SORTINGID3 AS Expr5, T2.DEPRECIATION, T2.SCRAPVALUE, T2.SERVICELIFE, T2.LIFETIME,
T2.LASTDEPRECIATIONDATE, T2.LIFETIMEREST, T2.CONSUMPTIONFACTORID, T2.CONSUMPTIONUNITID, T2.DEPRECIATIONCONVENTION, T2.POSTINGPROFILE, T2.LVPTRANSFERDATE_AU,
T2.LVPTRANSFERID_AU, T2.EXCEEDINGNETBOOKVALUE, T2.NEGATIVENETBOOKVALUE, T2.RESERVETYPEID, T2.REVALUATIONGROUPID, T2.PURCHID, T2.VENDACCOUNT, T2.VENDINVOICEID,
T2.DEFAULTDIMENSION AS Expr6, T2.CUSTACCOUNT, T2.CUSTINVOICEID, T2.SALEVALUE, T2.RBSLFACTOR, T2.SERVICELIFEYEARS_FR, T2.SERVICELIFEMONTHS_FR, T2.ASSETSOURCETYPE_CN AS Expr7,
T2.MODIFIEDDATETIME AS Expr8, T2.RECVERSION AS Expr9, T2.PARTITION AS Expr10, T2.RECID AS Expr11, T1.MAINTENANCEINFO3, T1.NOTES
FROM ASSETTABLE AS T1 CROSS JOIN
ASSETBOOKMERGE AS T2
WHERE (T1.PARTITION = 5637144576) AND (T1.DATAAREAID = ‘atx’) AND (T2.PARTITION = 5637144576) AND (T2.DATAAREAID = ‘atx’) AND (T1.ASSETID = T2.ASSETID)
ORDER BY T1.ASSETID

Lasă un răspuns

Completează mai jos detaliile despre tine sau dă clic pe un icon pentru autentificare:

Logo WordPress.com

Comentezi folosind contul tău WordPress.com. Dezautentificare / Schimbă )

Poză Twitter

Comentezi folosind contul tău Twitter. Dezautentificare / Schimbă )

Fotografie Facebook

Comentezi folosind contul tău Facebook. Dezautentificare / Schimbă )

Fotografie Google+

Comentezi folosind contul tău Google+. Dezautentificare / Schimbă )

Conectare la %s

%d blogeri au apreciat asta: