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 Chriss Miller 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: sqlwp
  • Content: Threads
  • Order by date
  1. sqlwp

    Subtotal

    I need to do a conditional subtotal on a field. If any cell in column A is the value "R" then sum the associated value in column B. How can I accomplish this with a subtotal? I need to use subtotal because autofiltering can be used on many different columns.
  2. sqlwp

    Constraint still allows scanning on field

    I have multiple tables that I union together into a view. Each table has a check constraint on it for the same field but different value for each table. When I do a select on the view including the constraint field in the where clause the execution plan still shows all tables in the view being...
  3. sqlwp

    Query runs slower on newer server

    I am in the process of moving my sql database to a newer server(Windows 2003, SQL 2000) from (NT/SQL 7.0). The server has 2 more processor and more memory. My update queries are taking twice as long to run on the new server. It doesn't look like it's using the processors, it seems like it is...
  4. sqlwp

    Communication link failure

    When accessing a database with Crystal in design mode when I run the report the first time it runs fine, and if I keep running it within a few minutes it's fine, but if I let the report sit there for more than a few minutes when I try to run it again I receive a "communication link failure" and...
  5. sqlwp

    Disable keyboard actions

    Is there any way to prevent the action of the Windows key and the print screen key?
  6. sqlwp

    Table Comparison

    I have a two huge tables I need to compare field by field to make sure the data is exactly the same. The table layouts are identical. Is there any way of assuring the data is identical in both tables without doing a field by field comparison?
  7. sqlwp

    Fixed length font

    I'm displaying data on an asp page from information entered through an MS Access form. The spacing of the text in Access looks good, for example: This is line 1 text: This is line 2...........123 This is line three.......125 But when I display it on the asp page the font is different and skews...
  8. sqlwp

    Entering data into a form field

    Is there any way to use a tab to when entering data in a form field?
  9. sqlwp

    Performance

    I am creating a table that is used in a warehouse for reporting. The queries that create the table end up joining about 30 tables and creating 1.5 million records. It takes about 1.45 hours to run. Then the indexes built on it take .5 hours to run. The tables are all indexed on what they are...

Part and Inventory Search

Back
Top