Dynamic Columns - SQL Server 2012

Question

Dynamic Columns - SQL Server 2012

Navigation

#1 by (0 votes)

0

I have two tables which I want using a Query SQL Server to generate dynamic columns depending on the number of records in a table. Please see the image.

sql-server datatables query pivot

asked by configbug 03.11.2017 в 03:34

source

1 answer

Error inserting a client from java into a database in SqlServer Problems with Bootstrap carousel

score 0 · Accepted Answer

I found the solution to what I needed. I share with you I used SQL STUFF:

	SELECT A.codEmpresa
			,A.nomEmpresa
			,A.codSistema
			,A.nomSistema
			,A.codPerfil
			,A.nomPerfil
			,modulos = STUFF((SELECT DISTINCT ', ' + M.nomModulo
									FROM smpseg.[0004] R
									JOIN smpseg.[0014] SMOP
									ON SMOP.codSistema = R.codSistema
									AND SMOP.codModulo = R.codModulo
									AND SMOP.codPerfil = A.codPerfil
									AND SMOP.objDefault = CAST(1 AS BIT)
									JOIN smpseg.[0011] O
									ON O.codSistema = SMOP.codSistema
									AND O.codModulo = SMOP.codModulo
									AND O.codObjeto = SMOP.codObjeto
									JOIN smpseg.[0010] M
									ON M.codSistema = O.codSistema
									AND M.codModulo = O.codModulo
								WHERE R.codUsuario = @p_codUsuario
									FOR XML PATH('')), 1, 2, '')
  FROM smpseg.[0004] A
			JOIN smpseg.[0016] U
				ON U.codUsuario = A.codUsuario