bukhantsov.org

my technical notes

Skip to content

Maconomy version

SELECT 
  MAINVERSIONNUMBER, 
  PATCHNUMBER 
FROM 
(
  SELECT 
    MAINVERSIONNUMBER, 
    PATCHNUMBER, 
    ROW_NUMBER() OVER (ORDER BY MAINVERSIONNUMBER DESC, PATCHNUMBER DESC) RN 
  FROM 
    SYSTEMMAINTENANCELOG
)A
WHERE RN = 1

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...

Related

This entry was posted in Maconomy on September 25, 2014 by dmytro.

Post navigation

← Misc. Dates – SQL Server XI 3.1 Issue with Excel Data Provider →
  • Business Objects
    • Administration
    • SDK
    • Tools
    • Universe Designer
    • Web Intelligence
    • Xcelsius
  • Command Line
  • Data Warehousing
    • Design
    • Kettle
    • Methodology
  • Databases
    • Oracle
    • SQL Server
  • Interview
  • Maconomy
  • OLAP
  • Other
  • Programming
    • C#
    • Flex
    • Java
    • Javascript
    • Python
  • Uncategorized
Website Built with WordPress.com.
  • Follow Following
    • bukhantsov.org
    • Already have a WordPress.com account? Log in now.
    • bukhantsov.org
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Copy shortlink
    • Report this content
    • View post in Reader
    • Manage subscriptions
    • Collapse this bar
%d bloggers like this: