Viewing 15 posts - 76 through 90 (of 163 total)
=====UPDATE=====
We brought a guy in that indicated he was very experienced as a dba. He had lots of stuff on the resume that sounded right.
As it turns...
September 21, 2012 at 9:31 am
What the SAM-HILL in TARNATION... dumb thing started working... which what one of you yahoos fixed it when I wasn't looking!!!???!!!:w00t:
September 17, 2012 at 7:57 am
I don't know whether or not to be proud or embarrased... the answer to my question has taken on a life of it's own....
:blink:
September 17, 2012 at 7:17 am
Snape's hair wasn't as cool... LOL
Think Star Wars, meets Star Trek... Add in Spock, and a little bit of Space Balls.
September 14, 2012 at 10:51 am
I Just LOVE GSquared's Avatar... it's been so long since that movie was out I bet hardly anyone knows who that is.
September 14, 2012 at 10:43 am
Just when I think I'm getting really good at what I do, you guys take me to school... . I guess that's what learning is about...
September 14, 2012 at 9:53 am
I'm actually reading it now.... LOL
I"m thinking we should take this discussion offline... I can PM you with my personal address...
September 14, 2012 at 9:44 am
Lynn,
I don't recognize the DelimitedSplit8k function.. I'm assuming this is something custom?
September 14, 2012 at 9:36 am
Lynn, dumb question... the machine I was running it on had a 2008r2 Developers edition install. The host machine which houses the data is a 2005 machine,...
September 13, 2012 at 5:44 pm
Lynn, It doesn't like the Values bit... I'll look at it tomorrow.. Thanks for the help on this BTW...
September 13, 2012 at 4:03 pm
Here is why I asked, the sample data you posted above has 1 row where the Legal column has a "record" with 25 columns based on the column delimiter (:)....
September 13, 2012 at 3:49 pm
Lynn, In this case, yes there are always 13. The data is from a State Government. A different state might have 12 or 9, but I...
September 13, 2012 at 3:07 pm
No... The snapshot does not match the data; however, the problem doesn't change. The final result would be......
DocNumStrValSequenceCol_1Col_2Col_3Col_4Col_5Col_6Col_7Col_8Col_9Col_10Col_11Col_12Col_13
1994-00008417:4:6:::::6:::::LT 41NULL46NULLNULLNULLNULL6NULLNULLNULLNULLLT 4
1994-00007372:2:17:::::17:::::LT 2 BK 17 FAIR OAKS ADDITON 3RD FILING1NULL217NULLNULLNULLNULL17NULLNULLNULLNULLLT 2...
September 13, 2012 at 2:57 pm
Um... Huh? The lines of text are just from the same parts looping...
September 13, 2012 at 2:51 pm
OH... and we're using 2005... Figured I should throw it out there.. I'm in a 2008 forum... I know.. someone is going to yell at me...:Whistling:
September 13, 2012 at 2:49 pm
Viewing 15 posts - 76 through 90 (of 163 total)