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!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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
  2. alexwhit

    auto colomn names from data

    could a pivot be used??
  3. alexwhit

    auto colomn names from data

    the prices are not stored in this table they are stored elsewhere.
  4. alexwhit

    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
  5. alexwhit

    auto colomn names from data

    yea something like that. i can create them manuly but the amount of bands could change
  6. alexwhit

    auto colomn names from data

    the table i want just has id name 1 Standard 2 price band 1 3 price band 2 ect
  7. alexwhit

    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...
  8. alexwhit

    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

Part and Inventory Search

Back
Top