table - sql non aggregate pivot -

table - sql non aggregate pivot -

my query is:

declare @dynamicpivotquery nvarchar(max) declare @columnname nvarchar(max) --get distinct values of pivot column select @columnname= isnull(@columnname + ',','') + quotename(ozellikadi) (select distinct ozellikadi kategoriduzyazilar kategoriid=6864) courses print @columnname set @dynamicpivotquery = n'select * from(select i.ilanid,iduz.deger,ozellikadi ilan bring together kategori k on i.kategoriid=k.kategoriid bring together kategoriduzyazilar kduz on kduz.kategoriid=k.kategoriid bring together ilanduzyazilar iduz on iduz.ilanid=i.ilanid i.kategoriid=6864 )piv pivot (max(deger) ozellikadi in(' + @columnname + ')) pvttable' print @dynamicpivotquery exec sp_executesql @dynamicpivotquery

ozellikadi property of ilan,deger integer value of ozellikadi , values of in different tables

and result this

ilanid ada no pafta no parsel no 426 9 9 9 433 24 24 24 434 210 210 210 435 775 775 775

but dont want aggregate , have result

ilanid ada no pafta no parsel no 426 5 7 9 433 13 16 24 434 210 114 5 435 775 0 45

kategoriid variable

http://sqlfiddle.com/#!3/3d158/1 thanks

http://sqlfiddle.com/#!3/3d158/26

the proplem in query

select i.ilanid,iduz.deger,ozellikadi ilan bring together kategori k on i.kategoriid=k.kategoriid bring together kategoriduzyazilar kduz on kduz.kategoriid=k.kategoriid bring together ilanduzyazilar iduz on iduz.ilanid=i.ilanid , kduz.id=iduz.kategoriduzyazilarid i.kategoriid=6864

you've forgot set relationship between ilanduzyazilar , kategoriduzyazilar tables

sql table pivot