CodeLogs

What is Common Type Expressions? and How do we use it in our Stored Procedures? Common Type Expressions is almost similar to a view but you don't really create a physical view, instead you are querying a result set that is available for your SELECT, UPDATE, DELETE statements. Here's an example using Northwind: We may have a query like this: SELECT CustomerID,         CompanyName,         CONVERT(varchar,OrderDate,101) as OrderDate,         ProductName,         Quantity FROM (  SELECT  c.CustomerID, c.CompanyName,  o.OrderDate,                p.ProductName,  od.Quantity FROM Orders o INNER JOIN dbo.Customers c ON o.CustomerID = c.CustomerID INNER JOIN dbo.[Order Details] od ON o.OrderID =  od.OrderID INNER JOIN dbo.Products p ON od.ProductID = p.ProductID ) details WHERE details.Quantity>10 With...

Back to Blogging. I have this project in ASP.Net MVC wherein I need to make a dashboard for our client using ASP.Net MVC. Quick Requirements: -A predefined dashboard for each user group. -Customizable widget/gatgets/webparts whatever you want to call it. Quick Goals: -Create a webpart and webzones. -Create a baseclasses with interfaces. -Create a controller base which other controllers will inherit from. -Webparts are independent.