Recent content by JustATheory

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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