Viewing 15 posts - 166 through 180 (of 9,643 total)
The following code doesn't get you to your final result the way you want it pivoted, but it gets close:
WITH Customer
...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 27, 2016 at 3:29 pm
Ed Wagner (2/27/2016)
I get it and it makes sense for the recruiter. It is challenging for the job seeker when multiple agencies all try to fill the same position. That...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 27, 2016 at 1:37 pm
Public Service Announcement
For those who wish to submit sessions for the 2016 PASS Summit the deadline for submission is Wednesday, March 2. I have started working on my abstracts...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 26, 2016 at 2:12 pm
Sean Lange (2/23/2016)
Alan.B (2/23/2016)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 23, 2016 at 12:31 pm
Steve,
Good editorial as usual. I think you sum it up well in the last paragraph:
The mark of a good manager is that they find ways to treat each employee...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 8, 2016 at 12:21 pm
Sean Lange (2/8/2016)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 8, 2016 at 12:06 pm
BWFC (2/5/2016)
It's done through stored procs called by SSIS. We first load a staging table then the fact table.
Okay so that makes the process of maintaining that flag...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 5, 2016 at 8:13 am
How do you load the data warehouse?
Can a person have risk at one load and then not have a risk the next load?
How will implement the risk reason...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 5, 2016 at 7:32 am
Phil Parkin (2/5/2016)
Never noticed your avatar pic before: is that you playing a Strat?
No that's Fender Milestone Bass.
I tried to play guitar but I couldn't get my left hand to...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 5, 2016 at 7:17 am
jasona.work (2/5/2016)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 5, 2016 at 6:04 am
nick.latocha (2/4/2016)
Thanks Jack.Will SSDT sync the local project and the physical database automatically? My devs make changes direct to DB in our dev/uat env.
Depends on what you mean by automatically....
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 5, 2016 at 6:00 am
nick.latocha (2/3/2016)
We did request a copy of...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 4, 2016 at 12:23 pm
It wasn't easy to find and the only reason I found it is because I'm an MVP and we had a discussion about it via email.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 4, 2016 at 9:06 am
I'd be interested as well. I may even download the trial. It looks similar to the architecture a colleague and I have been trying to design where I'm...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 4, 2016 at 8:06 am
I believe this Article[/url] will take you where you need to go to find what you are looking for. The key text is near the top of the...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 4, 2016 at 7:57 am
Viewing 15 posts - 166 through 180 (of 9,643 total)