Hi,

Please see attached as an example.

Many Thanks,

Oliver

CREATE TABLE [dbo].[A_TABLE](

[ID] [int] NOT NULL,

[column1] [nvarchar](max) NULL,

CONSTRAINT [PK_A_TABLE] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,...

Thanks Dwain,

Will give this a try and try the unpivot alternative, looks good.

Is performance better than unpivot?

Cheers

Oliver

Many Thanks Nevyn and Luis I get the concept now, I really appreciate your help.

Thank You,

Oliver

Hi,

Thanks for the help, however this isnt what I am after, I essentially want the group by field (column 2) to be on top (as a title grouping) of column...

Hi,

Yes unfortunately it needs to be pure T-SQL. Sorry I know it's very easy in SSRS but for the task I need it for this isnt appropriate.

Thanks,

Oliver

Think we were writing at the same time!

Thanks for the help

Think I have it, create an empty table first, then with the EXEC use insert into.

This works, if it is poor SQL please let me know,

Many Thanks,

Oliver

Thank you for the reply, I am incorporating this into my larger script.

Thanks again

Hi,

in your script you added

WHERE object_id = OBJECT_ID('tempdb..#TABLE')

How do I find the temporary table name through object id of the temporary table I just created?

select TOP(650) * INTO #table FROM...

Hi,

I have got this working now, as I understand it does it prevent scanning because it is all being run under the one select statement with case as opposed to...

Thanks, I know absolutely that at the moment it is designed badly.

I will try to break down your query and have more of a play, I dont think the first...

Hi,

Thanks for this, the query provided is in essence what my current query does except my current one stipulates each column, where as yours creates the sql dynamically. The problem...

I simply want to create a subset of the data as requested by the user and return them a table of the data which only contains columns that contain data....

sorry firefox crashed when I added the post, sorry for double posting.

PLEASE Remove this post.

Very sorry

Thanks so much Sean, really appreciate the help it's working like a gem now.

Thanks again,

Oliver