Posted on: 3/21/2014 6:09:18 AM | Views : 410

Hi!!
I m used the below code to retrieve data from two columns for autofill. It’s working  fine but I need Something like this view.
Select a.ColumnName from (Select Distinct CategoryName as columnname from DistrictData where CategoryName like '%'+@Name+'%' union all Select BusinessName as columnname from DistrictData where BusinessName like @Name+'%'union all Select BusinessName as columnname from DistrictData where CategoryName like @Name+'%')a How to display like this.

The categoryname and Businessname which are in red mark are column names.

Thanks in advance !!
Keep Coding!!

Go to the complete details ...