ASP.NET MVC 3 Preview 1

ASP.NET Best Practices

Check out this SlideShare Presentation:

ASP.NET Best Practices

View more presentations from Harish Ranganathan.

How Do I: Use Covariance and Contravariance in VS 2010 Part I?

jQuery Essentials

Check out this SlideShare Presentation:

jQuery Essentials

View more presentations from Marc Grabanski.

Entity Framework v2 Best Practices

Check out this SlideShare Presentation:

Entity Framework v2 Best Practices

View more presentations from andri_yadi.

ADO.NET Entity Framework & Your Data Access Layer

Check out this SlideShare Presentation:

ADO.NET Entity Framework & Your Data Access Layer

View more presentations from Wade Wegner.

MvcContrib: creating Portable Areas

ASP.NET MVC Performance

View more presentations from rudib.

Getting Started with Telerik Extensions for ASP.NET MVC

ASP.NET MVC Best Practices

View more presentations from Simone Chiaretta.

The ViewModel pattern

View more presentations from Simone Chiaretta.

ASP.NET MVC Extensibility

View more presentations from Simone Chiaretta.

Trim Querystring from Request.Url

Simpler way to trim Querystring from Request.Url in C#:

Request.Url.GetLeftPart(UriPartial.Path);

Micrsoft Silverlight Analytics Framework

Opera Unite : Brower based Web Server

Opera Unite : Brower based Web Server

Glimmer

Glimmer - Glimmer allows you to easily create interactive elements on your web pages by harnessing the power of the jQuery library.

JavaScript: The Master Class

YouTube APIs Overview

Google Web Toolkit Architecture: Best Practices For Architecting Your GWT App

SQL 2005: (Table) JOIN (Table Valued Function)

In SQL 2005, I had to write a Query in which a TVF(Table Valued Function) should be joined with a Table. The TVF had a Parameter which should be joined to the Table's Column
TVF - MyFunction(@ID)
Table - MyTable (with a Column ID)
Here the MyTable.ID should be joined with the MyFunction(@ID) to produce the results. The normal JOIN will not work in this case. This should be done by using CROSS APPLY feature:

SELECT * FROM MyTable T CROSS APPLY MyFunction(T.ID)
CROSS APPLY = Table INNER JOIN TVF

In case of LEFT JOINing use 'OUTER APPLY' like this:
SSELECT * FROM MyTable T OUTER APPLY MyFunction(T.ID)
OUTER APPLY = Table LEFT OUTER JOIN TVF

Note: No need to USE 'ON' clause