Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rtmpxr

  1. rtmpxr

    sql to create value dependent on prior record

    This can be done in Firebird: execute block returns(id_out integer,wo varchar(6),parent integer) as declare variable n integer; declare variable i integer; declare variable wo_old varchar(6); begin select count(*) from table1 into :n; select id,name,id as parent from table1 order by id rows 1...
  2. rtmpxr

    JOIN / Not existing records as blank cells in the results

    Correction: select NAMES.ID, NAME.NAMES, CODES.CODE from NAMES LEFT JOIN CODES on NAMES.ID=CODES.ID and CODTYPE='C'
  3. rtmpxr

    JOIN / Not existing records as blank cells in the results

    select TABLE1.ID,NAME,TABLE2.CODE from table1 LEFT JOIN table2 on TABLE1.ID=TABLE2.id and CODTYPE='C'
  4. rtmpxr

    Installing SLQ Server 2000 Enterprise Edition

    You must have Windows 2003 Server operation system (or other server system operation) to install SQL Server 2000. If you need to learn SQL language only, you can use SQL Server 2005 Express Edition which can be installed on XP.
  5. rtmpxr

    select only the first row in a group

    Maybe this is convenient: select <col1>, min(<col2>) from <table> group by <col1> Results: a 1 b 2 c 1 d 2
  6. rtmpxr

    Importing Excel data into SQL existing table

    see http://support.microsoft.com/kb/321686 to append use insert into <table> select * from EXCELINK...[<your sheet>]
  7. rtmpxr

    COMPLEX JOINS

    Correction ! select Products.[Product ID], Products.Category, Products.Quality, T.Suplier, T.Date as [Date Today], T.Price as [Price Today], Y.Date as [Date Yesterday], Y.Price as [Price Yesterday], (T.Price - Y.Price) as [Price Difference] from Products, (select [Product ID], Suplier...
  8. rtmpxr

    COMPLEX JOINS

    select Products.[Product ID], Products.Category, Products.Quality, T.Suplier, T.Date as [Date Today], T.Price as [Price Today], Y.Date as [Date Yesterday], Y.Price as [Price Yesterday], (T.Price - Y.Price) as [Price Difference] from Products, (select [Product ID], Suplier...
  9. rtmpxr

    Computer Performance Comparison - FEA

    Like always de gustibus non est disputandum :) For the airport example I give you a star :)
  10. rtmpxr

    Computer Performance Comparison - FEA

    cbrn, Maybe I was out of luck with laptops. Used just for demos on customer site. I prefer to build my own rig and maximise it's performance. And don't forget he wants to use Solidworks also. No chance with a laptop. I still consider the laptop a fancy toy for a serious engineer.
  11. rtmpxr

    Stress Engineer !!

    "If you can predict the values then you are aware of the phenomenom" said by JJ Thompson (not sure, maybe my memory let me down :)) Important is the concept.
  12. rtmpxr

    Viscoelastic material - Linear or Non-linear?

    You can have small deformations (which obbey the Hook's law) but large rotations. This is a non-linear analysis. See "Foundations of non-linear elasticity" by VV Novozhilov
  13. rtmpxr

    Stress Engineer !!

    It's nice to see that engineering community retains it's sense of humour :) Now, seriously, I see a CAE engineer like that: -design the product in Soliworks or Unigraphics (for example) -import the model and do an analysis with Ansys or Abaqus (for example) -conduct an experiment to verify his...
  14. rtmpxr

    Computer Performance Comparison - FEA

    A laptop is a joke for a serious stress analyst. It's maded for bussines people to impress the stupid ones (which represents the majority). Talk with a good IT engineer and you'll get the right answer.
  15. rtmpxr

    area of elements is too small,zero or negative

    I believe you have a large strain problem where your elements submit large deformations. Redo the mesh accordingly with the state problem or try to do a rezoning to keep area elements at a reasonable shape.

Part and Inventory Search