I have the following derived formula and get an error stating Missing Right Parenthesis. I'm not sure what is causing this...
CASE
WHEN RTRIM(JOB_POSITION.BARGAIN_UNIT_CODE) = '' THEN 'N'
WHEN JOB_POSITION.BARGAIN_UNIT_CODE IS NULL THEN 'N'
ELSE 'Y' END
I have a fact table that identifies active and terminated employees each month. The Active and Terminated measures are a sum of the column with a 0 or 1 populated. At the month level, this gives me the total active employees for the month and the terminated employees. When I roll up to the...
Wrox also has a good website oriented book called 'ASP.NET Website Programming Problem - Design - Solution'. It's not as thick as 'ASP.NET Unleashed', which I also highly recommend, but it's very thorough in developing a web solution from start to finish and includes best practices for overall...
I would like to send an e-mail with a report snapshot attached. I know I can accomplish this through the SendObject command. However, I also want the ability to change the urgency of the e-mail and edit the fonts in the e-mail message. I know I can use the outlook api's to edit an e-mail message...
Can a wildcard character be use in an IN statement? If not, can and IN statement be combined with a LIKE statement in order to utilize a Wildcard character?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.