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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JustATheory

  1. JustATheory

    Need to removed

    Greetings, I have a column that displays weight, I need to strip out "lb" and convert it to a numeric or decimal (3,1). the column needs to be averaged, all is fine until the conversion, and I keep getting an error. Msg 8115, Level 16, State 8, Line 96 Arithmetic overflow error converting...
  2. JustATheory

    Hyperlinks with difference address refernces

    Greetings, I a macro that creates worksheets based on a list it also creates a list of hyperlinks to each worksheet and a hyperlink in the worksheet back to the Table of Contents. I don’t want the hyperlink in each worksheet refer to Cell A1. I want each worksheet’s hyperlink to tie back to the...
  3. JustATheory

    Convert Date of Birth to Age, results a negative number

    Thanks to both Jarl and carp, this works perfectly and I'll check out the oracle 11g forum. JustATheory
  4. JustATheory

    Convert Date of Birth to Age, results a negative number

    Sorry about that! Oracle 11g SELECT ID, DOB, floor((months_between(sysdate, DOB))/12) age FROM table ; Sample Results ID DOB AGE 1 25-Aug-54 57 2 10-Feb-85 27 3 20-Sep-80 31 4 10-Aug-18 -7 Many Thanks! JustATheory
  5. JustATheory

    Convert Date of Birth to Age, results a negative number

    Greetings, I'm able to convert a birthdate to age and all is fine except for years in the early 1900s, 1912 - 1920 for instance. I need to correct this, what do I need to add to the query string? All help is greatly appreciated! Thanks, JustATheory
  6. JustATheory

    max value based on two columns

    Greetings, I'm stuck on a simple query to find max values, I'm looking for the max number in col1 based on the values in col2. I keep getting all values. I thought it was as simple as: select max(col1), col2 from table; I've tried subqueries with a similar result. Help is always greatly...
  7. JustATheory

    Concatenate with parentheses around a column

    Hi JarlH, That was it! Many thanks! Thanks, JustATheory
  8. JustATheory

    Concatenate with parentheses around a column

    I have a concatenation problem. I can get the left parentheses to display but not the right. Here is what should happen, if column 2 is populated the concatenate col1 with parens around col2. If col2 is null then concatenate col1 with parens around a dash. It functions properly for placing...
  9. JustATheory

    SQL Server 2008 Query to poulate from previous record

    Yes, there is quite a bit of stuff in there, I'll take a look at it. Thanks for your help! JustATheory
  10. JustATheory

    SQL Server 2008 Query to poulate from previous record

    Hi Qik3Coder, The values should fill through to the record above the next populated value, and then populate the following null fields with that value, there is no specified limit. The order is defined by a row number field, ordered. The numbers in SQL2 was just to demonstrate different...
  11. JustATheory

    SQL Server 2008 Query to poulate from previous record

    Greetings, I’m working with SQL Server 2008 and need to know if there is a way to populate a field with the value from the same field in the previous record? In the table below I need to populate the empty fields with the value in the previous records: Record 2 would also be SQL, Records 4...
  12. JustATheory

    SQL Server 2008 errors during export to Excel

    Hi Qik3Coder, Yes, I was exporting fine until I found the record limitation, added the components and now I'm erroring. I've been exporting individually to a text file, running a macro to enter them into one workbook, for import on a different machine. On a different machine, I can import...
  13. JustATheory

    SQL Server 2008 errors during export to Excel

    Here is the error message. I'd like to export to Excel, I have over 60 files that I need to export and one at a time as a text is to labor intensive. Pre-execute (Error) Messages • Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code...
  14. JustATheory

    SQL Server 2008 errors during export to Excel

    Using the .txt export is fine, it's only occuring with an export to Excel. Thanks, Andy
  15. JustATheory

    SQL Server 2008 errors during export to Excel

    Greetings, The Export wizard was working fine until I realized that the Excel file limits were at the old 66k records instead of the 1million available in 2007. I needed to add Office 2007 compatibility components and now it errors and stops the export completely. The files are of the 2007...
See more

Part and Inventory Search

Back
Top