Author: feroz.saiyed | Posted on: 10/27/2010 3:07:05 AM | Views : 248

I have a requrement to create multicolumn dropdown list.
It must look exactly like the one given below


















I ran one query to imoplement this functionality in SQL Server Stored Procedure


SELECT (COALESCE(Column1,'') + ' | ' + COALESCE(Column2,'')) AS Column1s
                     FROM Table1
                    WHERE (COALESCE(Column1,'') + ' | ' + COALESCE(Column2,'')) != ''
         ...

Go to the complete details ...