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 derfloh 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. Katy44

    Why is ISNUMERIC('-') = 1

    select convert(int,'-') brings back 0 so it looks like that's another way of sayinf zero! select '-'+3 brings back 3! Interesting.
  2. Katy44

    Make-table query very slow

    That's not a bad idea - the table structure will always be the same as they normally just select *. Didn't know you could do that - thanks! I'll see if it's any quicker.
  3. Katy44

    Make-table query very slow

    Thank you for your response. The query selects from probably about 30 or 40 tables. There are about 200 fields and the number of rows depends on the parameter values- but it's normally in the thousands. The select query, as I mentioned takes about three seconds, when it's a make-table it takes...
  4. Katy44

    Access project: views

    ...it, the Access project puts my username in front before it passes it to the SQL Server. This is what the profiler says is trying to be run: select * from CREATE VIEW <domain>\<user>.View2 AS SELECT * FROM TestIPAllFields Now this fails because of the '\' and Access tells me that. The name...
  5. Katy44

    Make-table query very slow

    Hi, I have a query which is incredibly slow. It's a make table query but when it's changed to a select query it runs in <3 seconds (still slow I know, but not half an hour!) Does anyone know why this is happening and how it could be fixed? Thanks for any help
  6. Katy44

    Than vs. Then

    Tracy, I know what you mean about fingers getting carried away - I have trouble writing the word 'form', my fingers insist that it should be 'from'. I also add a 'g' on to the end of any word ending in 'in' (travelling on the traing). On the other hand (pun intended), maybe I just cn'at tyep...
  7. Katy44

    Split field into different columns

    I don't understand, are these reason1, reason2...reason5 fields already set up? Or are you going to have a link table which would be a much better solution? If the fields I mention above aren't already created and you can't change the table structure, what do you intend to do?
  8. Katy44

    Query Help

    select ... where (field1 = 'b' and (field2 = '1' OR field2 = '2')) or(field1 <> 'b' and (field2 = '1' OR field2 = '2' OR field2 = '3')) ..I think!
  9. Katy44

    Split field into different columns

    If the table structure is already prepared then my suggestion will work - just create the update statement.
  10. Katy44

    Cumulative differences

    What exactly ae you trying to achieve with the aggregate? Can you post the query exactly as you ran it?
  11. Katy44

    Cumulative differences

    That shouldn't cause a problem, what is the error?
  12. Katy44

    Split field into different columns

    There will be a way to do it, but the easiest way in my opinion is to get the PK field and this field into excel, delimit the field that has reasons separated by an underscore, change the table structure, build up an update string for each one in excel and then run the created strings. May not...
  13. Katy44

    If Statement

    SQLBill - IIIII see :)
  14. Katy44

    If Statement

    Why is it not syntax? Do you mean it depends on the version?
  15. Katy44

    Simple Query

    From your query I can't see why - what other class codes are returned? If you add the class code to the select statement, can you show us some sample output?
  16. Katy44

    If Statement

    The SQL Server equivalent is the case statement.
  17. Katy44

    Can't Compare Numeric Characters

    if you try (columnname is null or columnname <>1) what do you get?
  18. Katy44

    Whats wrong with my Inner Join

    you have written 'innert' rather than inner. If that's just in the post and not the syntax let us know.
  19. Katy44

    Business Objects Grand Total

    Id you have a summary field already set up, just move it or copy it into your report footer. Did that work?
  20. Katy44

    &quot;Where, Group By and Order By&quot; help

    Are you sure? What happens if you do: SELECT COUNT(MachineID) AS Total, DisplayName00 AS Application FROM Add_or_Remove_Program_DATA WHERE (DisplayName00 = 'Adobe Reader 7.0') OR (DisplayName00 = 'Microsoft Data Access Components KB870669') Do you get them all or only the two...

Part and Inventory Search

Back
Top