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 TouchToneTommy 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: Connatic
  • Content: Threads
  • Order by date
  1. Connatic

    Select where Value is between 2 Column Values ??

    I am having a problem with a query, and because it is Monday morning i don't think my Brain is quite working properly yet, so maybe some one can help me out ? I have a table in which i have 2 Columns (see below) Start No / End No __________________ 1! 200 ! 300 2! 400 ! 500 3! 600...
  2. Connatic

    Tricky Update Query !!!

    I have a query where i need to Update the Top 50 records of a resultset. The way i figured to do this was, Select the Top 50 of the records i want into a temporary table, and then update from the table. The problem with this is that i need to Order the 50 by Date, so i am getting the 50 oldest...
  3. Connatic

    Select ... Where ... IsNumeric ????

    I feel that i should know how to do this but the ways i have tried don't work; SELECT linkref FROM Derivedaddresses WHERE right(linkref,1) IS NUMERIC SELECT linkref FROM Derivedaddresses WHERE ISNUMERIC(right(linkref,1)) linkref is a varchar field, and has both Alpha ~& numeric...
  4. Connatic

    Removing Double Spaces from a field ???

    Hi, I have an Address Field in a table, that is a bit of a mess, and I am trying to clean it up. The first step I would like to do is to remove all the Double spaces for the records in this column, and by this I mean, reducing any double space to a single space! Joe Bloggs --> would become...
  5. Connatic

    How to make query use an Indexed View ?

    I had a problem query (taking to long to execute) that uses the Like operator, and have found that when i copied all my existing tables into a new database & Ran the Index Tuning Wizard, this solved my speed issue with my query. My problem is, running the index tuning wizard on my original...
  6. Connatic

    Index Tuning Wizard ???

    I have a (like)query that was taking 6 seconds to run, so after valuable assistance from members of this forum, i tried copying the whole database (tables & et all) onto another server. Doing this, and then using the Index Tuning Wizard reduced the time of my query down to 1 second. When i...
  7. Connatic

    Is there any way of speeding up Queries that use LIKE clauses ?

    I have a query (stored proc) that uses a LIKE statement on a Varchar column and it takes 6 seconds to run. As this is returning a results set to an application, this performance is unnacceptable. Query : SELECT m.m_mat_id, m.m_clt_code, m.m_mat_num, m.m_clt_name, m_mat_desc, t.at_desc...

Part and Inventory Search

Back
Top