The first tip off that something was wrong, was your statement in the second paragraph, 'I work as the way I always work.' It is always part of your...

While I agree with Jeff and MrPoleCat (MrPC for short?) that providing a sample would be helpful, let pose this question - do you have any idea how the input...

jeff, i think the answer to short term / long term will be [in pseudocode] a case statement (case datediff 1 year longterm, case datediff = 1 year ???...

Joe - you must be working in Linux systems. The rest of us already have windows. Vista, XP, 2000....

I've not had a window in my office space since...

I have never seen so clearly the thinness of the line separating us from lawyers in how finely we split hairs over coding instead of points of law.

The one cogent...

use > or >=???, just in case there are two or more values that are maximum. Also, what if one of the compared to values is NULL?

Glad I could be of service. Regarding your further question, we have the opportunity for similar confusion. Let us say that we have record called 'A'. Would...

Knowing nothing about your application - it's quite possible that you could require the users to enter all content in English as far as the database is concerned, and the...

Have you managed to come up with a method of approaching what content is hanging? For all you know, it's poorly edited input from a particular end-user. Train...

My reading of the processor license is that it is non-transferrable from the processor(s) installed on the motherboard. Which would mean that if you had to use a DR...

IF the application is tight, i.e., well written, then there are mechanisms in place to parse the GUI-supplied input and edit it before processing, so that a single quote aka...

Did you look at the execution plan with and without the @WRID line added?

Otherwise, without knowing how the variables are declared and assigned content, there's not much we can tell...

Is this a static workbook? Or periodic processing that has to be imported (daily? weekly? monthly? hourly?)? Is there any way of arranging to have the source of...

My gut reaction is you are butting your head against a size limitation. Depending on the size of each row, you may be writing lines out to the file,...

Hi Laura! Can you be a little more specific?

1. You want to 'marry' unlike details correlating to the same core content (matching foreign keys [FK]) and create a table,...