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

  • Users: Massy
  • Order by date
  1. Massy

    Careers advice

    Chopstik, thanks for you post: its gave me a few ideas how I can shape my future. Going off topic initially, there were no real major disadvantages living in Asia, however there were a few niggling points that being from the Western world, contributed to me leaving: my diet primarily was Thai...
  2. Massy

    Careers advice

    Just wondering if there is anyone out there with some advice with regards to my career direction. I graduated with a degree in Software Engineering and immediately found a position in a medium sized company designing/developing both front (C++) and back end database (SQL) solutions for a number...
  3. Massy

    Search field with SQL help

    Try select * from sysaudits_02 where extrainfo like "%err%"
  4. Massy

    Conceptual problem with users and databases

    Hi, Well not sure on the question - but a user is local to the Database - so if you have more than one DB, you need to create a user on each separate DB. As for the hierarchy, the DB runs on the server and the user logs in to the DB. Pls could you clarify more?
  5. Massy

    Database Version Update!

    Hi John, I've used ASA 5 DB for years with a ASA 6 so not sure what the problems is? However ASA 6.0 -> 6.2 was quite buggy to say the least. What problems are you having? However, the easiest way to "upgrade" an DB is to unload the ASA 5 one and reload it in ASA 6. You can do all this vis...
  6. Massy

    Output to a file from sybase stored procedure ?

    Have you tried the "output to" command? Tom.
  7. Massy

    Testing if a table is empty

    Hi Paul, How about this: select if exists (select 1 from table) then 1 else 0 endif from sys.dummy Tom.
  8. Massy

    Installing java for Mozilla firebird

    Have you tried this: http://texturizer.net/firebird/faq.html#q2.2 Tom.
  9. Massy

    How many users are we licensed for

    hi paul Try: select property ( 'LicenseCount'); select property ( 'LicensedCompany'); select property ( 'LicensedUser'); select property ( 'LicenseType'); Tom.
  10. Massy

    Performance and speed!

    Not sure what your asking for here: do you want to speed up DB performance or create SQL reports quickly? In the former case, I found this page extremely useful: http://www.bcarter.com/tip077.htm In the latter case, that's all down to DB design! However, creating views maybe useful in...
  11. Massy

    Parse name field into components

    Opps, it seems the "locate" function is an ASA SQL vendor extension. Must take more notice of "standards"!!!
  12. Massy

    Formatting money

    Hi This is probably a task better suited for your front end. For example using a mask in Powerbuilder. Tom.
  13. Massy

    Pack Database

    Hi, Have you tried unloading/reloading the DB? Tom.
  14. Massy

    Change DBA password!

    Hi John, To change the DBA password you need to create a new DBA account (eg "DBA2" - how original!). Log out off the original DBA account and change the pw from the new one. Tom.
  15. Massy

    What is more performant : EXISTS or IN ?

    Hi ScanX, I think this link should answer your query: http://archives.postgresql.org/pgsql-performance/2002-12/msg00185.php However, in my experience, it is best simply to experiment with both and see which one gives you the best result. Tom.
  16. Massy

    Order by on computed value

    okay try this select username, acct, (select count(acct) from table1 b where b.username = a.username) as acct_cnt from table1 a order by acct_cnt desc Tom.
  17. Massy

    Parse name field into components

    Hi Jennifer, You could do something like this: select right( Manager_Name, char_length( Manager_Name) - locate( Manager_Name, ' ', -1)), Manager_Name from table; Of course, this fails when the manger_name contains inconsistencies such as 'Jr', 'III' or 'Del Balso'. You could get round this...

Part and Inventory Search

Back
Top