Hi Dwain,

Thanks for the help, I made a few changes but the key is that I need to push the column_id variable to each function. How do I do this? With the cursor I set column_id is the cursor which it iterates through.

Many Thanks for your help,

Oliver

SELECT @COLUMN_TYPE = TSC_COLUMNS.ColumnType

FROM TSC_COLUMNS

WHERE TSC_COLUMNS.ID = @COLUMN_ID

INSERT INTO @TEMP_EXPORT

SELECT *

FROM [dbo].[TSC_ExportedColumnIds] a

CROSS APPLY [dbo].[udf_TSC_qry_ExportBlockColumnParam1](@COLUMN_ID) b

WHERE a.ColumnType = 1

UNION ALL

SELECT *

FROM [dbo].[TSC_ExportedColumnIds] a

CROSS APPLY [dbo].[udf_TSC_qry_ExportBlockColumnParam2](@COLUMN_ID,4) b

WHERE a.ColumnType = 1

UNION ALL

SELECT *

FROM [dbo].[TSC_ExportedColumnIds] a

CROSS APPLY [dbo].[udf_TSC_qry_ExportSequenceColumnParam1](@COLUMN_ID) b

WHERE a.ColumnType = 2

UNION ALL

SELECT *

FROM [dbo].[TSC_ExportedColumnIds] a

CROSS APPLY [dbo].[udf_TSC_qry_ExportSequenceColumnParam2](@COLUMN_ID,4) b

WHERE a.ColumnType = 2

UNION ALL

SELECT A,B,C,D,E,F,G

FROM [dbo].[TSC_ExportedColumnIds] a

CROSS APPLY [dbo].[udf_TSC_qry_ExportEventColumnParam0](@COLUMN_ID,4) b

WHERE a.ColumnType = 3