I have created a stored procedure for the exec function above. In Excel, I have added an existing connection with SQL type calling the stored procedure.

It worked perfectly.

Thanks for your...

Thanks for the feedback,

The way I have started all this dynamic code is to get it automatically into Excel. In my case, when any new dimension is added, the...

To add up, here are the Create and Insert statements, to get data sample for the query above

Create the following tables

CREATE TABLE [dbo].[AAG00400](

[aaTrxDimID] [int] NULL,

[aaTrxDim] [nvarchar](max) NULL

) ON [PRIMARY] TEXTIMAGE_ON...