Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

adapting the solution---sooo desperate :( Expand / Collapse
Posted Wednesday, January 16, 2008 8:22 AM


Group: General Forum Members
Last Login: Thursday, March 3, 2011 1:05 PM
Points: 22, Visits: 54
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.

Post #443700
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse