Viewing 15 posts - 16 through 30 (of 138 total)
I am helping someone else with this. If the next few things attempted don't fix it, I will gather the DDL and such and post it.
May 11, 2012 at 11:37 am
The getdate() is already being assigned to a variable, and used for the update. The update also should touch only 5 records (it is using a top 5). If the...
May 11, 2012 at 11:30 am
This is in preparation for an upgrade of the app, which will be replaced with reporting services. I am hoping that would not be too difficult, but I don't know...
April 12, 2012 at 8:03 am
Thanks Sergiy , that ended up being what I did, and it worked smoothly.
March 9, 2012 at 12:08 pm
Thanks Bitbucket, I will have to give that a try in addition to the non-linear thinking way I am testing now.
(Which is, import all files with LF as the row...
February 21, 2012 at 8:28 am
Would these values be created out of a mainframe cobol program?
December 13, 2011 at 11:39 am
Thanks Paul, and yes I do.
Thankfully, after years of attempts, IT has ceased to be a wall. While they are still not ready to listen to me, they did hire...
December 9, 2011 at 7:40 am
It may be worth the effort to expand on this to look for other regular patterns. I would imagine eventually someone will figure out the sequential dialing is being detected,...
November 25, 2011 at 10:02 am
Ok, I have to...
What makes a good senior DBA.... it depends...
October 27, 2011 at 8:46 am
Thank you both! It is good to have confirmation that my gut reaction was on the right track. Not too bad for the accidental data warehouse designer/DBA/Developer where there are...
October 27, 2011 at 8:14 am
You do have the right idea. One to One for all but a single client, whom is one to many. While there is no guarantee this will be the...
October 26, 2011 at 11:07 am
I had this problem frequently, initially the IMEX setting on it's own worked fine. However, to work fine the excel sheet data has to have the mixed char/numeric data in...
October 18, 2011 at 8:33 am
Yeah, wouldn't it be nice if people followed some sort of actual logical rules on naming things, as well as the data entry people following those rules, rather than breaking...
October 14, 2011 at 8:57 am
Thank you Sergiy, I will have to try that. Every step closer to getting toward the answer for this is very welcome.
October 14, 2011 at 8:14 am
Rtrim does work in some cases, but not all. That is in some cases of the data, there should be a space added to the concatenation of the two fields,...
October 7, 2011 at 1:20 pm
Viewing 15 posts - 16 through 30 (of 138 total)