Search results for query: *

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

Yes, both fields that I've searched on are indexed.

Greetings, I'm running SQL Server 2005, I have a database with one large table and I continue to receive this error (802) on simple queries. I'm asking for all fields there are only 8, by a date range, like 1 week and it bombs. It has over 700 million records, it resides on a 2TB eSATA...

Sorry it took a while to get back, it worked and all is well. Thanks, JustATheory

Greetings, I'm running a stand alone version of SQL Server 2005, and was setting up an index when, the database was taged suspect with an error 926. How is the best way to remove this tag, is it possible to do this without resorting from backup? Any help is greatly appreciated. Thanks...

Thanks George, Works like a charm! I wrote something similar and it didn't work, sometimes it's just the extra set of eyes. Thanks much, JustATheory