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

Leave a Reply 0 comments