Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Buckman0

  1. Buckman0

    Missing Right Parenthesis Error

    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
  2. Buckman0

    Avg of Measure over time

    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...
  3. Buckman0

    Read all about it!

    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...
  4. Buckman0

    Send E-mail With Report Snapshot

    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...
  5. Buckman0

    Using a Wildcard in an IN statement

    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?

Part and Inventory Search

Back
Top