Concatinating Dates -
12-21-2005
, 06:17 AM
I have this Query
WITH
SET [LatestMonth] AS
'TAIL(NONEMPTYCROSSJOIN([Time].[Standard].[Month].Members,
{[Country].[Country].[Bahrain]}, 1), 1) + " " +
HEAD(NONEMPTYCROSSJOIN([Time].[Standard].[Month].Members,
{[Country].[Country].[Bahrain]}, 1), 1)'
SELECT
{[Measures].[Coverage]} ON 0,
CROSSJOIN({[Country].[Country].[Bahrain]}, [LatestMonth]) ON 1
FROM [Cross Country]
However it gives me 2 rows of data, the top row with teh last month
(i.e. Oct 04/05) and the bottom row with the first month (i.e. Oct
01/02)
I would like it to be all on one row so that the month column would
read "Oct 01/02 Oct 04/05"
I know I may have to convert it to string but everytime I try and do it
it fails
Any ideas |