Viewing 15 posts - 2,506 through 2,520 (of 3,232 total)
Which table are you updating, the temp table or GE Claim? How are the two tables related? Can you be a bit more descriptive as to what you want done?
December 6, 2006 at 1:42 pm
Just as Sergiy said:
INSERT INTO #tmpTable (you need to define this prior to this statement)
SELECT
a.PolicyNumber,
a.TableCode,
a.SeriesCode,
a.LossDate,
a.EffectiveDate,
b.WaiverofPremium
FROM tableA a
INNER JOIN tableB b
ON a.PolicyNumber...
December 5, 2006 at 2:00 pm
I would guess that you could interchange the words 'youngest' and 'most inexperienced' and the statement would still ring true.
"by the way im one of the most inexperienced oracle qualified...
December 5, 2006 at 12:54 pm
Is there a specific problem that you are having? If so, it would be helpfull if you would post your UDF and provide a description of your problem and include...
December 5, 2006 at 12:05 pm
What exactly does "This query runs within the above code's looping output" mean? Does this mean that you've written a cursor? Please post all of your code, DDL for relevant...
December 5, 2006 at 11:58 am
Oops, my bad. That will not work. Will your Code values be the same for the employees and only the hours different? If so use
SELECT Empoyee#, Code, MIN(Hours) FROM...
December 1, 2006 at 2:58 pm
The only way that I am aware of would be for you to run profiler and capture all incomming traffic. How busy is your system? Keep in mind that this...
December 1, 2006 at 12:35 pm
I suggest you think about re-designing your approach, but if you insist to go down this route, check out these two threads. The first one in particular should be helpfull.
December 1, 2006 at 9:23 am
I think you’re going to have a problem with this solution. While you may be able to get something that works, it may be best...
December 1, 2006 at 8:44 am
Does it need to be sequential or just a random unique numeric?
December 1, 2006 at 7:59 am
Can you post the syntax you are using in your connect string for OSQL?
December 1, 2006 at 7:56 am
What is too long? What index rebuild command are you using, DBCC DBREINDEX? Consider running DBCC SHOWCONTIG directly after your index rebuild job runs, directly before it runs, and sometime...
November 30, 2006 at 3:20 pm
I'm not real sure exactly what you are trying to do, but it sounds like a great place for a scalar function. When you say "I would like to concatenate...
November 30, 2006 at 12:17 pm
OK, this is a different issue correct? Look through that same article as it provides alot of SQL mail troubleshooting info. Your mail configuration may not be setup correctly.
November 30, 2006 at 10:04 am
November 30, 2006 at 9:41 am
Viewing 15 posts - 2,506 through 2,520 (of 3,232 total)