Viewing 15 posts - 136 through 150 (of 55,829 total)
So, just to be sure, "Component N" and "Region" can actually be anything, correct? And the goal is to assign the "N" of "Group N"? Do the requirements of "Group...
May 30, 2022 at 1:29 pm
May 30, 2022 at 1:17 pm
Thanks, Thom. It sounds like you've had some good experiences with SSIS.
A little bit off topic, if you good folks don't mind... I am curious about good experiences in SSIS...
May 30, 2022 at 1:15 pm
I'm thinking that I'm not understanding much either. 😀
You probably don't actually mean "Hierarchical"... you just mean you have some relational tables, correct? If that's the case, and ERD might...
May 30, 2022 at 3:30 am
Let me give more context on this. I am trying to identify if multiple components have been purchased by customers (Sales>0) in Last 4 quarters and then on basis...
May 30, 2022 at 3:18 am
Table looks right but I don't know why you resist providing the information I asked for. You didn't include the BULK INSERT I asked for. 🙁
No matter though. I made...
May 29, 2022 at 6:01 am
See the following article and the link to the other article list in it.
That will help you provide the proof you need to increase your RAM.
May 29, 2022 at 4:29 am
Various activities (post new topic, reply to one, post article, etc.). I think I need to file a bug that spam posts don't count as points.
It's worse than that,...
May 28, 2022 at 2:47 pm
Doesn't SSIS allow you to run a CMD Task where you could issue the following simple DIR command and capture the output to a table? It'll give you the full...
May 27, 2022 at 11:06 pm
Thanks for the feedback Grant and Steve! I really appreciate it.
May 27, 2022 at 10:53 pm
I don't know what the data is that you're playing that code against. Is strongly suspect that you may have imported the data incorrectly OR there's an anomaly in the...
May 27, 2022 at 9:10 pm
I'll let Jeff do some chopping but WHY Reorganize? this should be avoided almost at all costs (very few exceptions)
Not aware of that, also can't seem to find...
May 27, 2022 at 4:19 pm
As a bit of a sidebar... I have a visceral hate for DATEFIRST() and @@DATFIRST(). It just bugs me.
With that, and even though it's a tiny bit slower, I use...
May 27, 2022 at 7:31 am
Actually, none of the answers are correct (and I didn't click an answer because of that... they're all incorrect).
The first answer is syntactically incorrect because DATEPART only takes two operands.
The...
May 27, 2022 at 6:51 am
Viewing 15 posts - 136 through 150 (of 55,829 total)