Wednesday 26 February 2014

SQL exists (but not exists)

We did some business data import and after the import there were some difference happening in what business provided the data and what system calculated using the config data.

To find the differences and placing the difference in front of client I used something similar

Select * from table1 t1
exists
( select * from table2 t2
where t2.column1 = t1.column3 and ( t2.column2 like '%' + cast( t1.column4 as varchar(10)) + '%' or t2.column2 like '%' + cast(t1.column5) as varchar(2)) + '%' )

 

CRM tools

Diagnostics

https://OrgURL/tools/diagnostics/diag.aspx.

If the result is greater than 150ms then performance experience will suffer.
 

Tuesday 18 February 2014

import records in excel in sql data base

To check if a the corresponding column contains 'some text' if so then return true otherwise false
=ISNUMBER(SEARCH("Some Text",A3))


To import records in excel file into SQL server database


http://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/

Wednesday 12 February 2014

Permissions required for data import

Following are the required entities permission to allow a user to import data into crm through data import wizard.

 - Data Import (all)
 - Data Map (all)
 - Import Source File (all)
 - Web Wizard (all)
 - Web Wizard Access Privilege (all)
 - Wizard Page (all)

 - Entity privilege which user needs to import data for.

I am not sure if we need all privilege here as I have used some of the entities mentioned above with less privilege and it worked fine.

http://social.microsoft.com/Forums/en-US/crm/thread/deca129e-189a-4c11-9e74-c6e93469e664