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 gkittelson 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. abware

    update 2 tables in one statement

    why? why this is not working? I can’t update 2 tables in one statement? update pd, p set pd.show = 0 , pd.seashow = 0, p.StockLimited = 0 FROM ProductDetail pd join Products p on p.itemid = pd.ItemID where pd.show = 1 and pd.site in (5,2,9)
  2. abware

    pivot a table

    got it. thank you very much.
  3. abware

    pivot a table

    hi. this is a very hard sql. if someone can do it without a cursor and in 1 sql, it will be very good. this is my table: item | store | Price aaa |store1 | 20 aaa |store8 | 19 aaa |store6 | 50 aaa |store55| 64 aaa |store3 | 15 bbb |store1 | 12 bbb |store8 | 20 bbb |store6 | 15...

Part and Inventory Search

Back
Top