Please visit DEMANDDRAFT.SHOP for quality of products...

Ad

Search This Blog

Monday, December 17, 2012

How do you extract first tuple from the set?

Use could usefunction Set.Item(0)
Example:

SELECT {{[Date].[Calendar].[Calendar Year].Members
}.Item(0)}
ON 0
FROM [Adventure Works]

No comments:

Post a Comment