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 ...