Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by alexwhit
-
auto colomn names from data
i ended up creating a pivot table and then adding it as a stored procedure. now working like a dream -
-
auto colomn names from data
the prices are not stored in this table they are stored elsewhere. -
auto colomn names from data
thanks for the reply. the sub querey creates the comlomn name standard. nd fills in the info. what i am alooking for is somethinkg like that but creates a colomn for every "price band name" record in the priceband table. thanks -
auto colomn names from data
yea something like that. i can create them manuly but the amount of bands could change -
auto colomn names from data
the table i want just has id name 1 Standard 2 price band 1 3 price band 2 ect -
auto colomn names from data
SELECT "StockItem"."Code", "PriceBand"."Name", "StockItem"."Manufacturer", "StockItem"."StockItemStatusID", "StockItem"."StandardCost", "StockItemPrice"."Price", (SELECT "StockItemPrice"."Price" WHERE ("PriceBand"."Name"= 'standard')) AS "PriceBand Standard" FROM... -
auto colomn names from data
i wonder if you can help. this may be in the wrong forum. i want to produce an auto alias for a group of price bands. the names of what i want the aliases to be are stored in a table and these can change. is there a way to automatically create these and keep them updated? thanks
