Archive for

SQL Challenge 1

Problem: how do I write a query in SQL to do this? I have a table: name mark u 23 h 38 j 20 p 83 and for output we need name mark mark2 u 23 38 h 38 20 j 20 83 p 83 0 Solution: The query to accomplish the task: is ;WITH … Continue reading

AutoComplete Textbox

Introduction: During the work on a project, i need to use a control having auto complete facility in it as user types then I realized that we can make use of the textbox control  or combobox control for this purpose. Both controls can be used to filter records as a drop down list to show … Continue reading