Covert Complex SQL In clause to a business rule

Suppose you have Complex SQL Stored procedure and you would like to do this Complex SQL operation into BizTalk Business Rule Engine, what can you do??

Let see Example for This…
we need to transform the below SQL script to BRE
Update a Set a.policy=150
from a
Inner join b
on a.id=b.id
Where a.xx=100 and a.yy in (3,10) and b.zz=1
To solve this issue follow this steps
1- create view contain SQL join.
2- Use IF statement in Business Rule
by adding in the if condition a.xx=100 and a.yy in (3,10) and b.zz=1
and put the set action into if condition action
I Hope this Help.

How to Setup Microsoft Dynamics CRM for Outlook

One of the most Important features for Microsoft CRM Dynamic 4.0 is integration with Microsoft Office Outlook to do this just follow the following steps

1- Go to you CRM Install Package and copy the client folder into your client machine

2- run the setup file named SetupClient.exe

3- make sure you have installed the .net framework 3.0 or later and Microsoft Visual c++ runtime 8.0 or later.

4- important note the i have write this post for it

if you do not have Microsoft Visual C++ runtime installed download it and put it in folder named VcRedist then copy this folder beside the EXE file mention in step 2

5- after the installation finished go to Microsoft Office Outlook you will find big link in the top of you personal outlook named configure CRM Dynamic just click this link and follow the wizard till you finish.

6- now you can find all activities you authorized to access from Microsoft Dynamics SRM 4.0 available into you Microsoft Office Outlook….. Good Luck.

I hope this help.