Viewing 15 posts - 1 through 15 (of 56 total)
Thanks for your hint! I used a calendar table and DENSE_RANK() as shown in the article to solve my problem. I appreciate your help very much.
Sam Vanga
http://SamuelVanga.com
December 10, 2021 at 8:41 am
If you need to look at previous or next records in a set, use LAG() or LEAD() with an OVER clause. then you can use conditional logic to see...
Sam Vanga
http://SamuelVanga.com
December 9, 2021 at 7:43 pm
I'm guilty of using Int for SSN a long time ago (and I'm not from the US). You can imagine that was short lived!
Sam Vanga
http://SamuelVanga.com
October 7, 2015 at 1:15 pm
g.britton (10/6/2015)
Sam Vanga
http://SamuelVanga.com
October 6, 2015 at 6:24 pm
Honny (10/6/2015)
Sam Vanga
http://SamuelVanga.com
October 6, 2015 at 6:17 pm
t.pinder (10/6/2015)
In almost all cases, parsing in the data flow pefroms (sic) better than parsing at the source, if not at the same performance level.
Sam, I'm sorry, this sentence doesn't...
Sam Vanga
http://SamuelVanga.com
October 6, 2015 at 6:15 pm
g.britton (9/10/2015)
It's really hard to get help! I...
Sam Vanga
http://SamuelVanga.com
September 10, 2015 at 7:28 pm
By un-pretty I mean you'd have to type BIMLScript without intellisense and proper formatting in Visual Studio.
Sam Vanga
http://SamuelVanga.com
July 16, 2015 at 5:43 am
1. BIML might be free but to use it in anger you will need to install Mist which is not cheap at $4000 per licence plus annual support costs.
Sam Vanga
http://SamuelVanga.com
July 15, 2015 at 1:26 pm
TheComedian - No, I don't have experience with Theobald. If you need help, try posting on Biml forums and I'm sure one of the guys will help you. Link is...
Sam Vanga
http://SamuelVanga.com
July 13, 2015 at 7:11 pm
TheComedian (7/13/2015)
Sam Vanga
http://SamuelVanga.com
July 13, 2015 at 5:29 am
nzhang6666 - Huh! My attempt to write an elaborate article so even people new to Biml would be follow may have caused you to feel that this is complicated. This...
Sam Vanga
http://SamuelVanga.com
July 13, 2015 at 5:19 am
Alan.B (4/20/2015)
Great article Sam. Simple, to the point, easy read - well done sir!
Thanks for the kind words! Glad you liked it.
Sam Vanga
http://SamuelVanga.com
April 23, 2015 at 2:50 pm
For added flexibility I usually have the processing path set in a variable, makes it easier to move from staging environments to production.
Chris, I hope you mean something like a...
Sam Vanga
http://SamuelVanga.com
April 23, 2015 at 2:49 pm
I don't disagree. I think these are two different ways to do it. I've used both of them. And I think I said it in the article, this step of...
Sam Vanga
http://SamuelVanga.com
April 20, 2015 at 9:13 am
Viewing 15 posts - 1 through 15 (of 56 total)