InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 07:09:23 GMT20http://www.sqlservercentral.com/Forums/Topic443700-138-1.aspxhi ,i am an electronics engineer and i just have the general knowledge about sql server 2005(i am not too bad i am immediate), but i couldn't adapt your dynamic cross tab sp ,according to my problem if you help me i will very very appreciate and even i will pray for you :) promise:) cause i am desperate and helpless about this, here is my problem:i have just one table, named "collector" and the columns are:ledno(nvarchar(50))' the item number of a kind of led(a mini light source) which we useledname(nvarchar(50))' the name of the ledsquantity(int) ' how many leds we use on that partpartname(nvarchar(50) 'the parts nameand i want it to be this way;ledno ledname partname(part name goes dynamically according to our records(the header))202.a led-a 3 '(this is the total led-a used in the correct partname)205.b led-b 6'(this is the total led-b used in the correct partname)and the "partname" header musn't repeat itself (your sp does it well) i hope i am able to tell my problem, i know it's simple for you but i couldn't manage may self, thanks again.Wed, 16 Jan 2008 08:22:28 GMTdelta dirac