Common Table Expressions

Microsoft offers the following four advantages of CTEs:

• Create a recursive query.

• Substitute for a view when the general use of a view is not required; that is, you do not have to store the definition in metadata.

• Enable grouping by a column that is derived from a scalar sub select, or a function that is either not deterministic or has external access.

• Reference the resulting table multiple times in the same statement.

Using a CTE offers the advantages of improved readability and ease in maintenance of complex queries. The query can be divided into separate, simple, logical building blocks. These simple blocks can then be used to build more complex, interim CTEs until the final result set is generated. 

• About are as follow

A common table expression (CTE) can be thought of as a temporary result set that is defined 

Difference Between STUFF Vs REPLACE

STUFF - Delete a specified length of characters and insert
another set of characters at a specified starting point.

ex: SELECT STUFF('abcdefghi', 3, 3, 'ABC')
Go
Answer is: abABCfghi

REPLACE - Replace all occurrences of the second given string
expression in the first string expression with a third
expression.
For Example: SELECT REPLACE('Abhay', 'a', 'v')
Answer is: vbhavy

How to enable/disable compile errors warning in Visual Studio

1. From the "Tools" menu, select "Options".
2. In the dialog that appears, expand "Projects and Solutions", and click "Build and Run".
3. On the right side, you'll see a combo box labeled "On Run, when build or deployment errors occur".
   
   • If you want to disable the message box, select either "Do not launch" or "Launch old version" (which will launch the old version automatically).
   • If you want to enable the message box, select "Prompt to launch" which will ask you each time.

   
Of course, as people have suggested in the comments, this means that your code has errors in it somewhere that are preventing it from compiling. You need to use the "Error List" to figure out what those errors are, and then fix them.

Ajax and Javascript with Asp.net MVC 3

Helpful for MVC3 Articles :


http://www.pluralsight-training.net/microsoft/players/PSODPlayer.aspx?author=scott-allen&name=mvc3-building-ajax&mode=live&clip=0&course=aspdotnet-mvc3-intro

Pass Dynamic Connection String to SSRS Reports

SSRS 2005 ReportViewer is 'Shrinking' my Reports

I've found the solution to SSRS shrinking my reports. For reference, you have to do three things

1. Delete the declaration from my hosting aspx page
2. Set the Report Viewer's AsyncRendering property to false.
3. Set the Report Viewer's Width property to 100%

Apparently there is a bug in SSRS 2005 with its XHTML rendering engine which is now fixed with the engine rebuild in SSRS 2008.