Mitch Milam's Dynamics CRM and xRM Discussions

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 5)

dbo.fn_FindBusinessGuid

This function will return the ID for the business unit for the currently logged-on user.

select dbo.fn_FindBusinessGuid()

dbo.fn_FindUserGuid

This function will return the CRM ID for the currently logged-on user.

select dbo.fn_FindUserGuid()

Conclusion

I hope you enjoyed this series which explored the built-in user-defined functions included with CRM 4.0.  Hopefully, it will make your report writing quicker and more powerful.

I have a couple of additional articles planned that will cover some of these functions in more detail in the future.