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 MikeeOK 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: *

  • Users: sqlblind
  • Content: Threads
  • Order by date
  1. sqlblind

    IN Statement in Store Procedure

    Hi Guys, I have a simple store procedure which looks a bit like this: @ProductCodes as varchar(25) Select * from Market_Promotions where Booths_ID in (@ProductCodes) When I try to execute this and pass in a number of values I get an error message. Can you please give me some guidance...
  2. sqlblind

    Query Optimisation

    Hi Guys, I was wondering if i could get a helping hand in optimizing this query. I know its not perfectly formed and would really appreciate your expert guidance. Select ISNull(a.pd_main_group_code_desc,b.pd_main_group_code_desc), a.pd_super_group_desc...
  3. sqlblind

    Simple query Help

    Hi guys I have a data table which looks something like this: Date Channel Actual 1 3 4545 1 1 666 1 6 5456 2 1 1511 2 1 4888 3 1 1545 4 1 643 4 2...
  4. sqlblind

    SQL Query Help

    Hi Guys Im pretty new to sql and was wondering if one of you could help me out. I have a dataset which looks a bit like this: Year crs_code school sub % 2011 KT101 ML French 30% 2011 KT101 Law Law 50%...

Part and Inventory Search

Back
Top