Hi,

Worked it out, added a new field for ordering:

SELECT 1 as OrderME,*

FROM [dbo].[TSC_ExportedColumnIds] a

CROSS APPLY [dbo].[udf_TSC_qry_ExportBlockColumnParam1](a.ID) b

WHERE a.ColumnType = 1

UNION ALL

SELECT 2,*

FROM [dbo].[TSC_ExportedColumnIds] a

CROSS APPLY [dbo].[udf_TSC_qry_ExportBlockColumnParam2](a.ID,4) b

WHERE a.ColumnType = 1

UNION ALL

SELECT 3,*

FROM [dbo].[TSC_ExportedColumnIds] a

CROSS APPLY [dbo].[udf_TSC_qry_ExportSequenceColumnParam1](a.ID) b

WHERE a.ColumnType = 2

UNION ALL

SELECT 4,*

FROM [dbo].[TSC_ExportedColumnIds] a

CROSS APPLY [dbo].[udf_TSC_qry_ExportSequenceColumnParam2](a.ID,4) b

WHERE a.ColumnType = 2

UNION ALL

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

FROM [dbo].[TSC_ExportedColumnIds] a

CROSS APPLY [dbo].[udf_TSC_qry_ExportEventColumnParam0](a.ID,4) b

WHERE a.ColumnType = 3

order by ID,OrderMe

This works great, thank you so much for your help. I wish I could understand how to work up cross apply more. I will sit in a quiet room and work it out.

Many Thanks,

Oliver