Ok thanks.

But how will i apply this in my query?

Instead of EXEC sp_describe_first_result_set, should i mention my proc name?

What should i do here Select * from sys_objects?

Here sysobjects is a table.

I do not have a table, i have to create one dynamically with sparse columns.

Thats my question.

Any one any help very much appreciated.

I do this and get error

SET FMTONLY ON

GO

USE BO_DS_Staging

GO

SELECT *

FROM BO_DS_Staging.dbo.bear_load

GO

Msg 208, Level 16, State 3, Line 1

Invalid object name 'BO_DS_Staging.dbo.bear_load'.

Here bear_load is the function, it only takes...

How does that create a dynamic table with sparse columns?

Any suggestions??:w00t::w00t: