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.