Viewing 15 posts - 2,956 through 2,970 (of 13,855 total)
What format are the dates in?
How would you know which columns to interrogate?
What do you mean by 'dynamic', exactly?
February 3, 2020 at 8:56 pm
Jack's just kinda boring, that's all. It's not "bad", like undrinkable or anything, but it's not interesting either.
Some of the special Jacks are much better. I don't...
January 31, 2020 at 4:45 pm
JEFF Do NOT go all SSIS on me 🙂 we all know it's Bulk insert with a formatfile or openrowset
Jeff's blood pressure just went up a notch 🙂
January 31, 2020 at 3:47 pm
Jeff, that would be the best case scenario, but we get many clients that give to us as is and don't want to do more. It is in...
January 31, 2020 at 3:42 pm
sigh... my heart dies a little bit when we ignore the option of getting a provider of data to make it useable , I know they are often "paying...
January 31, 2020 at 3:04 pm
Following on with the food and music theme. To be sung to the tune of Queen's Bohemian Rhapsody ... it's the Indian version. (Not my work.)
Naan, just...
January 30, 2020 at 7:00 pm
So, came across this on Twitter, this morning, I figure some of the folks here ought to both get it, and get a kick out of it.
Or beat me...
January 30, 2020 at 6:47 pm
Please explain how to convert the following 'scientific numbers':
January 30, 2020 at 6:44 pm
How are these numbers broken ... what does 'fix' mean?
As Mike says, numbers should be stored in NUMERIC or INT formats. It is the job of the presentation layer to...
January 30, 2020 at 5:43 pm
i wonder how many veterans we still have left???
Hmmm ... I can feel a query coming on 🙂
January 30, 2020 at 2:19 pm
Posting to the original thread would have helped avoid fragmentation of replies.
January 30, 2020 at 12:42 pm
Duplicate post. See here
To the OP: what was wrong with the previous solution?
January 30, 2020 at 11:40 am
You should be able to upgrade both and leave the problematic database in 2012 compatibility mode - have you investigated this? It would save you a lot of trouble.
January 29, 2020 at 10:24 pm
some dlls should not go to GAC
Please explain what you mean by this.
GAC is the usual way ...
January 28, 2020 at 9:43 pm
Are they all going into the same target table? If so, you'll need to be careful with parallelism, because of the likelihood of blocking occurring during INSERTs.
I'd use SSIS for...
January 28, 2020 at 1:52 pm
Viewing 15 posts - 2,956 through 2,970 (of 13,855 total)