query para agrupar.

[Thumper]

Un momento de locura antes de ir a almorzar.

[highlight=sql]
create table #table( art int, alm int, stock int)
create table #tableResult( art int )

insert into #table values( 1, 1, 10 )
insert into #table values( 1, 2, 20 )
insert into #table values( 2, 1, 10 )
insert into #table values( 2, 2, 30 )
insert into #table values( 3, 1, 20 )
insert into #table values( 3, 2, 30 )

declare @art int
declare @alm int
declare @stock int
declare @alterSQLtable as nvarchar(100)
declare @typeColumn as nvarchar(50)

set @typeColumn = 'int' -- DEPENDE DEL TIPO DE DE DATO DEL STOCK

-------------------------------------------------
-- CURSOR PARA CREAR LA TABLA CON LAS COLUMNAS --
-------------------------------------------------
DECLARE example_cursor CURSOR FOR
SELECT distinct alm
FROM #table
OPEN example_cursor

FETCH NEXT FROM example_cursor
INTO @alm
WHILE @@FETCH_STATUS = 0
BEGIN

set @alterSQLtable = 'alter table #tableResult add ['+ cast(@alm as varchar) + '] ' + @typeColumn +''%0