Category Archives for "Dynamics CRM"

2 Finding the value of the state and status codes

If you’ve ever wondered how to find the values for the statecode and statuscode, you can use the following SQL script to find those values: select AttributeName, AttributeValue, Value from dbo.StringMap where (dbo.StringMap.AttributeName = ‘statuscode’ or dbo.StringMap.AttributeName = ‘statecode’) and dbo.StringMap.ObjectTypeCode = 1 Will display the following values for the Account Entity ( ObjectTypeCode = […]

Continue reading

CRM Customization File Best Practices

Today I thought I’d share what I think are some best practices when working with CRM’’s customization files. Procedure When exporting customizations for either edit (ISV.Config or Site Map ) or transport, I always save them to disk so I have a reference copy of the customizations.   Location Pick a specific folder on your […]

Continue reading

CRM 4.0’s Built-in SQL Functions (Part 5 of 5)

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 reading

CRM 4.0’s Built-in SQL Functions (Part 4 of 5)

In 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 reading
1 20 21 22