I need an sql query to get all the column values to be displayed if any one condition is satisfied from multiple conditions? Is this can be possible..please help me...
if i use or condition i get all the records from the table if both exist..i want all the records if any condition matches with the table data..for example, if i have 2 columns a,b.. a has records say 1,2,3 and b has records 4,5,6 .now i want to retrieve all columns values of a,b when the condition matches a =1 or any other condition.
In ssrs i want to generate reports on any 1 condition is satisfied...I have textboxes of the fields in the database..and if the user enters the name if should get all the records corresponding to the name ..or if he enters id which is provided in another field he shd retreive all the corresponding results..the report contains many textboxes in which if the user inserts any one value in any corresponding textbox it shd display all the records in the report.