adapting the solution---sooo desperate :(

• delta dirac

  SSC Veteran

  Points: 262

  More actions

  January 16, 2008 at 8:22 am

  #98785

  hi ,

  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 use

  ledname(nvarchar(50))' the name of the leds

  quantity(int) ' how many leds we use on that part

  partname(nvarchar(50) 'the parts name

  and 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.