Hi Lowell,

Thanks for helping out.

Yes it is the column headers for the INFORMATION_SCHEMA that I am trying to return with the schema information e.g.

TABLE_CATALOG',

'TABLE_SCHEMA',

'TABLE_NAME',

'COLUMN_NAME',

'ORDINAL_POSITION'

etc etc etc

I saw the solution you...

AT LAST I FIGURED IT OUT!!

if anybody else is interested...

when executing a common table expression (CTE) you must also include the statement that immediately follows it and uses the CTE...

AT LAST I FIGURED IT OUT!!

if anybody else is interested...

when executing a common table expression (CTE) you must also include the statement that immediately follows it and uses the CTE...

Hi Matt,

Cheers for the reply. Not too sure what you mean??... If I hard-code this in to the SP it runs fine:

With ItemEntries as (SELECT ROW_NUMBER() OVER (ORDER BY dogID...

Hi Guys thanks for the replies.

Peter you're right I am all over the place! Been at this all day and it is driving me insane lol can't find anything on...

Hi Guys thanks for the replies.

Peter you're right I am all over the place! Been at this all day and it is driving me insane lol can't find anything on...