please refer to my previous posts for the scenario in which i want outpt.

I have posted some functions which returns a sql query as string and i want to call...

INSERT INTO [SampleProperty].[dbo].[Equipment]

([EquipmentNo]

,[Description]

...

Hi,

Please import the attached excel to get data.

Regards

Pooja Sharma

Please create an empty database and run following sqls.

Add some data into them .

USE [SampleProperty]

GO

/****** Object: Table [dbo].[EPropertyData] Script Date: 01/16/2014 16:36:46 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

Hi,

I have created a Sample DB back and screen shot for my expectation .

Please refer the attachments.

Regards

Pooja

declare @cols NVARCHAR(MAX)

select @cols = STUFF((SELECT distinct ',' + QUOTENAME(c.propName)

...

HI,

I am not getting how to use Table valued functions as columns that i need to fetch are not constants rather they are dynamic "' + @cols + '" .

They...

Hi,

Actually my function is returning a dynamic query .

Step 1 : Create a function returning property names in CSV format

Create FUNCTION dbo.fxnGetPropertyColsQuery

(

)

RETURNS NVARCHAR(MAX)

AS

BEGIN

declare @Return NVARCHAR(MAX)

...