What?
A super quick article on how to pre-select the pipeline on deal creation within CRM based on the department specified on a user's profile.
Why?
A client asked that when staff create a deal/opportunity ...
What?
This article documents how to stop an employee from applying for leave when already 80% of their team have already booked the same date off. My brief was:
Check the department this employee ...
... will be applied to names and addresses as well as job titles and departments.
Why?
We wanted a T-SQL version despite having successfully built a custom script component for SSIS.
How?
You ...
What?
This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code.
Why?
I'm working with a system which stores XML strings ...
... Department" and "Director of IT".
"O'REILLY" should become "O'Reilly" and not "O'reilly".
"MCDONALDS" should become "McDonalds" but do not apply for "MacDonalds" because of names like "MACK" and "MACHURA".
...
... (one that I know will never be two lines (or two words)) within the SQL query itself. We have a DEPT column that is an acronym of the departments so for example:
SELECT
Date,
Reservation,
Contact, ...
... be obvious to some but these are self-proclaimed highly qualified web-gurus in the marketing department. They'd paid around £150,000 for a template designed by a 3rd-party company. Received the zip and ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.