Viewing 15 posts - 1 through 15 (of 40 total)
I many have come across a script that does the trick. So far so go. Will have to insert into the application and test.
October 26, 2010 at 2:16 pm
Thank you for the reply!
yes, I added in distinct and saw that it would remove the repeating values. I'm just concerned why the value repeat in the first place....
October 26, 2010 at 1:06 pm
cool trick, I'll give it try. Thanks for the replies>
October 6, 2010 at 3:20 pm
so if I understan, you are suggesting adding an identiklty column. This way I can address a row via a unique value. Yes?
October 6, 2010 at 3:08 pm
Yes, I would like to update the 'Null' value to the previous non 'Null' value
October 6, 2010 at 3:05 pm
opps I wrote that backwards. the Data files arrives first then the trigger..
July 12, 2007 at 8:41 am
I did verify that with the sender and confirmed via the ftp log that the trigger arrives first and then the data file.
Log shows -- user come in ..creates...
July 11, 2007 at 8:46 am
My server admin has verified that no system maintenace jobs are running during this time frame. He has also checked to see that no one is logged on the box...
July 10, 2007 at 9:29 am
The schedule has two steps:
1) check that a trigger file was sent. This is nothing more then a trigger.txt and contains a comment "this is a trigger file". It is sent...
July 10, 2007 at 9:21 am
Quite true. Rule of programming is to try it for yourself.
Supermodel to sql is an interesting transition.
Each is full of glamour and high living.
parties, booze, sex..... and end users...
August 12, 2005 at 9:11 am
Yes, I will always admit when I am wrong. My apologies.
However, a previous post indicated that the level setting was not the issue. This was alos stated by one of...
August 12, 2005 at 8:56 am
Thats it. I adjusted the comp level and its working.
Now this opens the disscusion of what are the potential gottcha's.
August 12, 2005 at 8:28 am
No its a good catch. I was under the impression that service pack 3a had been applied during a recent server upgrade project. Turns out that because my then server...
August 12, 2005 at 8:05 am
Hmmm I was under the impression that the service packs had been installed.
Thanks for pointing that out. I think the datacenter has some explaining to do!
August 11, 2005 at 2:34 pm
yep order by works just fine.
August 11, 2005 at 1:56 pm