Monthly Archives: March 2015

SQL server Multiple rows to one comma separated value

This is the select statement in Sql server which will select the multiple rows of a column into a single column and single row as a comma separated values. SELECT ┬áID ,STUFF((SELECT ‘, ‘ + CAST(Name AS VARCHAR(10)) [text()] FROM … Continue reading

Posted in SQL Server | Leave a comment

Sql Sever Split String function with special character support

The following the is the SQL server table valued function which will return the result as table. The input to the function is string delimited with the comma (for that matter any character which is is not part of the … Continue reading

Posted in SQL Server | Leave a comment

Chain of Responsibility design pattern with Dynamic handlers

This is the Chain of responsibility pattern with dynamic handler which can handler. With this we can assign dynamic handler for the request without touching the main handler. The following is the image shows the list of projects I have … Continue reading

Posted in Design patterns, Visual Studio | Leave a comment