Query for gathering all keywords on a doc type in separate columns

[Austin_Barber1]

I've seen a couple older threads, but wanted to check and see if someone has figured out a way to gather all keywords on a doc type and separate them into their own column. Like others, I can gather the item name, but that is what the auto string is. Any idea on how to separate them out? I can generate a CSV file on all the documents and their keywords, but a query seems to be a better way then locking up the system. 

Thank you!

[Roger_Linhart]

@Austin Barber Are you looking for the Keyword Types associated with each Document Type or the Keyword values associated with all the documents in a Document Type? Can you provide an example of what the query results would look like?

[Austin_Barber1]

Sorry for the delay. I would like to see the keyword values on a document in their own columns. It would pretty much be the same output as the generate csv does. 

[Roger_Linhart]

The following query provides a comma separated list of the Keyword Types associated with each Document Type:

/* KeywordsInDocTypesReport.sql * * Roger D. Linhart   11/20/2017   OnBase 17.0.0.57 * Jeff Pinkerton provided initial query. * * Show Keywords in Document Types. * * To list Keywords in all Document Types: *   --SET @myDocType = 'EA'; * * To list Keywords in Document Types LIKE 'EA%': *   SET @myDocType = 'EA'; * */DECLARE @myDocType nvarchar(51) = '';--SET @myDocType = 'EA';SET @myDocType += '%';SELECT DISTINCT rtrim(A.itemtypename) AS 'Document Type',	STUFF ((SELECT ', ' + rtrim(C.Keytype)		FROM hsi.itemtypexkeyword B WITH (NOLOCK)        INNER JOIN hsi.keytypetable C WITH (NOLOCK) ON B.keytypenum = C.keytypenum		WHERE  B.itemtypenum = A.itemtypenum		ORDER BY B.keytypenum		FOR XML PATH('')), 1, 1, '') AS KeywordsFROM hsi.doctype A WITH (NOLOCK)  WHERE (A.itemtypename LIKE @myDocType)

[Dominique_Pluch]

excellent!