Selection criteria not working in Crystal Reports and Visual Studio 2010

Problem:
I had upgraded my visual studio.net 2008 project to visual studio.net 2010. After that i noticed that some reports are not working properly. Infact selectioncriteria was not working. I tried many things but in vain.

Solution:
Just comment out or delete the following lines of code where the crystalreportviewer is defined in InitializeComponent()
        Me.crystalreportviewer .SelectionFormula

        Me.crystalreportviewer .ViewTimeSelectionFormula

SQL Server 2008/2012 - Loop through/split a delimited string

On internet, you will find many ways to loop trough the comma separated list in SQL. Following is a little bit different thing. Comma Separated list is parsed using XML datatype is saved in a temporary table.


Declare @xml AS XML  
Declare @id_list  VarChar(Max)
SET @id_list  = '2,5,6,2,6,73,26,267'

CREATE TABLE #TmpIdlist  
(  
  IdSequence  INT  
)  
SET @xml = CAST(('' + replace(@id_list , ',' ,'')+'') AS XML)  
INSERT INTO #TmpIdlist (IdSequence)  
SELECT  N.value('.', 'INT') AS value  
FROM @xml.nodes('A') AS T(N)