Thanks SriHarsha for your reply , but just FOR XML doesn't give data in proper format besides client expects data to be of CLOB type. Am not very sure of...

Hi All,

I have exploring various options and came across two approaches.

1.Using a WebService to query the SSAS and pass the result to the downstream applications.

2.Use a Stored Procedure using OPEN...

Thanks SQLZ!!

But this was not applicable in my real situation as there was already data , so no chance of checking it as null. Sorry i didn't mention it earlier...

Thanks Ryaan !!

It's working .

This is how data will look like :

Table1:

Col1 Col2 COl3 Col4

'Y' '' '' ''

'' ...

U might have missed to give value to that variable.

Just check .