Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
danjapro
Starting Member
44 Posts |
 Posted - 2006-06-02 : 09:53:54
|
| I am trying to return only the last Orbitimport File by its ID How do I do this in the Where statment:SELECT AssetType.Description, AssetAttribute.AssetDescription, Asset.Barcode, Asset.SKU, ESNTracking.ReportTime, ESNTracking.CurrLocStreet, ESNTracking.CurrLocCity, ESNTracking.CurrLocState, ESNTracking.CurrLocZip, ESNTracking.CurrLocCounty, ESN.EsnNumber, ESNTracking.DistanceMiles, InventoryOrigin.WarehouseDescriptionFROM AssetType INNER JOIN Asset ON (AssetType.AssetTypeId = Asset.AssetTypeId) INNER JOIN InventoryOrigin ON (Asset.WarehouseId = InventoryOrigin.WarehouseId) INNER JOIN AssetAttribute ON (Asset.AssetAttributeId = AssetAttribute.AssetAttributeId) INNER JOIN EsnAsset ON (Asset.AssetId = EsnAsset.AssetId) INNER JOIN ESN ON (EsnAsset.EsnId = ESN.EsnId) LEFT OUTER JOIN ESNTracking ON (EsnAsset.EsnId = ESNTracking.EsnId) LEFT OUTER JOIN AssetVehicle ON (EsnAsset.AssetId = AssetVehicle.AssetId) LEFT OUTER JOIN AssetCustomAttribute ON (EsnAsset.AssetId = AssetCustomAttribute.AssetId) LEFT OUTER JOIN AssetCustomAttributeDef ON (AssetCustomAttribute.AssetTypeId = AssetCustomAttributeDef.AssetTypeId) LEFT OUTER JOIN OrbitImport ON (EsnAsset.EsnId = OrbitImport.OrbitImportId)WHERE (OrbitImport.OrbitImportId >= OrbitImport.OrbitImportId) |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-02 : 09:55:53
|
| WHEREOrbitImport.OrbitImportId = (select max(OrbitImportId) from OrbitImport)==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Get the Last Orbit ID