-
Continue reading →: SQL query to split a string separated by Comma (or any special character)
Assume that you have a String with Comma separated value and wanted to split and get the collection in SQL. My string looks ‘A,B,C,D, ‘ and I want output as Value A B C D Approach The approach I am following here is Declare a Temporary table Split the string Insert…
-
Continue reading →: GUID generator website
How many times you were in a situation, where you need a GUID to test your .Net application or fill a ‘uniqueidentifier’ column of SQL table. I found this GUID generator site very helpful. You just need to refresh the web page to get a new GUID every time. Not…
-
Continue reading →: CRM Developer Toolkit for Visual Studio 2013
There is no release of CRM Developer Toolkit for VS 2013. However by hacking the CRM Developer toolkit for VS 2012 we can get Developer Toolkit work for VS 2013. Refer steps mentioned in this article. 🙂
-
Continue reading →: Auto generate new GUID for ‘uniqueidentifier’ column in SQL Table
If you a have a column of type ‘uniqueidentifier’ in your SQL table, and you want to auto generate a new Guid every time when you insert a record, you can use the ‘Default Value or Binding’ property of ‘Column Properties’. Set Default Value or Binding = newid() 🙂
-
Continue reading →: SQL Query to fetch top 1 record from each group
I have a SQL table ‘Market’ with 3 Groups (i.e., Fruits, Vegetable and Meat) and below is the data My requirement is From each group fetch the top 1 item by ‘Priority’ column (i.e., Priority = 1) like below Name Group Priority Apple Fruits 1 Fish Meat 1 Potato Vegetable 1 The…
-
Continue reading →: Create an Organization with custom Currency Code as Base Currency
Recently I was creating a new CRM Organization for “Mauritius” Customer and I had to set Base Currency as “Mauritius Rupee (MUR)”. But MUR currency code was not there in the list of available CRM currency codes. In these scenarios, we can type the Currency Code, Currency Name and Currency…
-
Continue reading →: Loading dependent jscript libraries in ribbon button’s execution CRM 2013
In CRM 2011, To load the dependent Jscripts on execution of ribbon button command actions We can add the dependent script as a Library in the “Javascript Command” and pass “isNaN” as Function Name (Refer my existing article) In CRM 2013, I observed a slight change in the execution w.r.t the order. The…
-
Continue reading →: Can only generate one of classes or data sets – Error with Xsd.exe tool
I was getting below exception when I try to generate a class file from my XML schema using command (xsd “mySchema.xsd”) Reason & Fix – Reason is, Xsd tool unable to determine whether to generate Dataset or Class Fix is, pass argument “/c” to generate Class or “/d” to generate…
-
Continue reading →: How to debug XAML Workflows when invoked remotely
Assume you have a XAML workflow created using WF designer and you trigger this workflow from a console application which is in another server. Below are the steps to debug Install “Workflow Manager Tools” After installation you can find a folder under “C:\Program Files (x86)\Workflow Manager Tools\1.0” Open “Microsoft.Workflow.TestServiceHost.exe.config” using…
Visitors
2,152,622 hits
Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI 