The final installment in this series contains miscellaneous SQL functions. You may wish to review the following articles before proceeding: CRM 4.0’s Built-in SQL Functions (Part 1 of 5) CRM 4.0’s Built-in SQL Functions (Part 2 of 5) CRM 4.0’s Built-in SQL Functions (Part 3 of 5) CRM 4.0’s Built-in SQL Functions (Part 4 of […]
Continue readingIn this section, we’ll cover year-related functions. You may wish to review the following articles before proceeding: CRM 4.0’s Built-in SQL Functions (Part 1 of 5) CRM 4.0’s Built-in SQL Functions (Part 2 of 5) CRM 4.0’s Built-in SQL Functions (Part 3 of 5) dbo.fn_BeginOfLastYear Returns the beginning date and time for last year. […]
Continue readingToday we are continuing on with part three of our series on using CRM 4.0’s built-in SQL functions. You may wish to review the following articles: CRM 4.0’s Built-in SQL Functions (Part 1 of 5) CRM 4.0’s Built-in SQL Functions (Part 2 of 5) Note: The date used in the following example is 2009-08-16. […]
Continue readingAs we continue onto the second article in our set, you may wish to review the previous article: CRM 4.0’s Built-in SQL Functions (Part 1 of 5) Note: The date used in the following example is 2009-08-16. dbo.fn_BeginOfLastWeek Returns the beginning date and time for last week. This function requires a valid datetime […]
Continue readingAs I mentioned in a previous article, CRM 4.0 includes a group of user-defined functions that are commonly used within SQL Reporting Services reports to query CRM data. I first noticed these functions when modifying a report created using the CRM Report Wizard. That got me to thinking that I needed to explore these functions […]
Continue readingOver the past several years, I have read and seen multiple references to a practice called Visualization, which is when a person rehearses a physical action by performing the task mentally. Examples that come to mind are the NASA astronaut training program, Olympic athletes, and the Navy’s Blue Angels. Note: You can perform an Internet […]
Continue readingWhile digging around the Net today, I ran across an extremely valuable color chart for cascading style sheets. They actually created the chart by scanning paint samples from a major household paint manufacturer. The samples art well organized and they provide facilities that show the color values in both Hex and RGB.
Continue readingI ran into an issue a couple of months ago where the CPA of one of my customers was having trouble using the NetScreen VPN client ( to talk to my customer’s network ) and a Cisco VPN client ( to talk to another customer ) using the same workstation. I finally traced the issue […]
Continue readingI ran into an issue recently where I need to remove certain fields from a CRM data entry form. The problem is the field is “locked.” That means it can’t be removed. Here is one solution to removing unwanted and locked fields from a data entry form: Step 1: Prepare the environment Add a new […]
Continue reading