Viewing 15 posts - 1 through 15 (of 38 total)
Yeah, ultimately it's due to how the different systems handle applying credits and payments to invoices. In SystemA, credits are essentially applied against payments kind of inflating the payment (which...
October 25, 2018 at 8:54 am
Forgive the ETL portion of the title. This is overall part of a larger ETL process, but this specific step is really just TSQL so title should've just "Help with...
October 25, 2018 at 8:26 am
Ultimately what I have in DocApplyInformationFromSystemB in original post is what it needs to look like so the DocApplyInformationFromSystemA is the before and the DocApplyInformationFromSystemB is the after that I need to...
October 25, 2018 at 7:30 am
You guys are awesome. Thanks!
February 26, 2018 at 2:24 pm
Yeah, I think that's it. Well, using DENSE_RANK() to handle date ties along with CHAR() + 64 to convert results of DENSE_RANK from numeric to alpha equivalent starting with A....
February 26, 2018 at 1:30 pm
Wow, you guys are gods among men. That was quick! Thanks a lot. As to the wisdom of doing this, I agree, but in this particular case...
September 24, 2013 at 9:19 am
Well, that was weird. Right when I opened this thread to see your reply, I got a call from the Prometric person I spoke with earlier and they said...
January 9, 2013 at 10:42 am
(Bob Brown) (7/31/2012)
July 31, 2012 at 8:16 am
Thanks for input, everyone.
Thomas Abraham (7/31/2012)
(Bob Brown) (7/31/2012)
July 31, 2012 at 7:44 am
The assumption is that those units were sold and removed from QOH or depleted for purposes beyond our visibility for this task. Basically, I'm only looking at QOH in...
June 11, 2012 at 2:50 pm
Right, I misread the question, and probably could've explained myself better as opposed to confusing the definition of precedence and laying blame where it wasn't deserved when it was actually...
May 25, 2012 at 12:18 pm
JiCiT (5/24/2012)
mtassin (5/24/2012)
Toreador (5/24/2012)
I can't believe that 21% have currently got it completely wrong, thinking that OR has precedence over AND! Hopefully they're just all misunderstanding what 'precedence' means 😉
I...
May 24, 2012 at 7:28 pm
We haven't implemented log shipping quite yet. We're still in the process of testing out the 15 minute interval trans log backups and determining what bandwidth requirements are in...
April 20, 2012 at 12:19 pm
kapfundestanley (4/20/2012)
'The problem with mirroring is that they use Standard, not Enterprise'...you can mirror in both these editions.
I know that - read the rest of that sentence:
lbrigham (4/19/2012)
April 20, 2012 at 7:03 am
Viewing 15 posts - 1 through 15 (of 38 total)