Here you go.

BTW, I think the problem is with NULLs

CREATE TABLE OptionsetMetadata (
    participationtypemask varchar(50),
    instancetypecode varchar(50),
    donotpostalmail...

I should mention the table/view OptionsetMetadata was created as follows:

CREATE VIEW OptionsetMetadata


AS

with cte as (


select OptionsetName,

LocalizedLabel,

row_number()over(partition by optionsetname order by cast([option] as int)) as rn

from dataverse_montagu_org5a2bcccf.dbo.OptionsetMetadata

)

select

max(case when...

First, really nice job on providing "Readily Consumable Data" AND it actually works without error! 😀

Thanks

• This reply was modified 2 years, 6 months ago by carlton 84646. Reason: update

First, really nice job on providing "Readily Consumable Data" AND it actually works without error!

My pleasure

If I'm asking the community for help, I think it's only fair to make it...

Hi Jeff,

Using the same test data I provided I wonder if you could help me build on your code to achieve an additional outcome.

• This reply was modified 2 years, 6 months ago by carlton 84646. Reason: update

Jeff,

I'm going to have to be become very proficient with Pivot (CROSS TABS) with my company.

Thanks for the links

Hi Jeff,

I think I'll be able to build on what you've provided for the other conditions.

Thanks

Hello Community,

Sorry for supplying so much data in the sample table - I have noticed it has slowed down the page when I scroll.

Anway, I was wondering if I could...

Hi All,

Please ignore this question. I don't know how to delete it.

I have a new question, which is based on Pivoting, not transposing..

Hi Jeff,

You are correct - this isn't very clear.

I'm going to rewrite this question. I have also realised that what I need is pivoting, not transposing.

Shall I just delete this...

Hi, just to be clear, I'm not expecting the dates 04/01/2019

03/01/2019

09/12/2021

03/01/2019

03/01/2019

To be in each Action. I was just being lazy by not...

Hi Phil,

You have once again come through.

Thanks man

Hi Phil,

That would be great.

You can forget about the TABLE_CATALOG

The ordinal_position represents the place a column appears in a table, which we can forget as I'm trying to work with...

Hi Phil,

I have the tables and columns that I would like to extract, see attached. Ideally, I would like the tables to extracted as individual CSVs.

This request might need someone...

Ratpak

Are...