T SQL order of the way a query is processed

I don't think that most of us ever thought about the order a T SQL is getting processed. I Know i haven't thought about it before.
I have given the order below. This i have taken from a book written about Linq.

1. FROM
2. ON
3. JOIN
4. WHERE
5. GROUP BY
6. WITH
7. HAVING
8. SELECT
9. TOP
10. ORDER BY

Change the default filter in activities in crm 3.0

We needed to change the default activity history filter as a customer asked us to do that. I searched the net to find some answers and there were 2 very good articles regarding this. i have pasted the links below.

http://www.stunnware.com/crm2/topic.aspx?id=js11
http://ts2community.com/blogs/larrylentz/archive/2008/12/19/changing-the-default-activities-filter-on-view.aspx

Change the for title and title bar in CRM 3.0 forms

I have given below the javascripts that needs to be used to change this.

var doc = document.getElementsByTagName('td');
for (var i = 0; i < doc.length; i++)
{
if(doc[i].className == "formTitle")
{
var header = doc[i].innerText;
strName=crmForm.all.name.DataValue;
strTitle=crmForm.all.titleid.DataValue[0].name;
header = strTitle +". "+ strName ;
doc[i].innerText = "Member : " + header;
document.title ="Member : " + header;
}
}

This scripts will change both the form title and CRM form title bar.
i was helped by this post.
http://robbakkers.blogspot.com/2006/03/update-header-information.html

Error Messages in CRM 3.0

we have been having issues with the error message returned by CRM 3.0 web service as it always returned "Server was unable to process the request".

 

we had to check everything to find the actual cause of error.

Recently i found a very ggod artical written by Ronald Lemmen explaining error details returned by CRM web service. This is avery good article. Anyone can refenrece it from this location.

http://ronaldlemmen.blogspot.com/2009/01/error-messages-in-crm.html

Thanks alot Ronald for your valuable time and information.

Control the Form Assistant Pane in CRM 3.0

One of the tasks that our guys had to do was to check how to get the form assistance expanded when a crm Form is loading. We searched the net and found some links. but some of them didn't work.

However Dmitri's blog contained a different was and when we incorporated it we got what we were looking for.

Simple we had to put the following java script to onload event of the form.

// to make sure it loads lookup data, if you want it expanded
if (document.all.RelatedInformationPane != null)
document.all.RelatedInformationPane.LoadContextData();

if (document.all.RelatedInformationPane != null)
document.all.RelatedInformationPane.ToggleInformationPane();

Thanks Dmitri. Following is his link.
http://devsturgeon.blogspot.com/2008/04/controlling-form-assistant-pane-on-crm.html