Home
> Business Intelligence > Get a comma separated list in SQL & MDX.
Get a comma separated list in SQL & MDX.
To get a comma separated list in SQL as well as in MDX use below queries.
1 – SQL
Select Name from Sales.SalesReason
GO
Select Name from Sales.SalesReason
SELECT
SUBSTRING
(
(
SELECT
‘,’ + s.Name
FROM
Sales.SalesReason s
ORDER BY
s.Name
FOR XML PATH(”)
)
,2,200000 ) AS NAME
1
2 – MDX
WITH
SET [COMMA] AS [Sales Reason].[Sales Reasons].[Sales Reason].MEMBERS
MEMBER [MEASURES].[COMMATEST] AS
Generate
(
[COMMA]
,[COMMA].CurrentMember.Name
,”,”
)
SELECT
NON EMPTY
{
[MEASURES].[COMMATEST]
} ON 0
FROM
[ADVENTURE WORKS];
2
Suhas R. Kudekar(MCC)
Categories: Business Intelligence
comma seprated, MDX, sql, ssas
Comments (0)
Trackbacks (0)
Leave a comment
Trackback
BI Big Data Authors
Sandip Shinde
Manish Kaushik
Suhas Kudekar(MCC)
Umesh M Patil
YashwantOur Visitors
Big Data, Data Analytics and Data Science | BI-BIGDATA.com 