i didn't get the clear picture.give the condition by using 'where'

PPK

may be you have definied only one parameter and in the execution statement you have give two parameters

PPK

you can create trigger for dml staements such as select,update ,delete..So create a trigger while selecting the table.

PPK

Use convert statement to the format required and use style 105 to cut date... Remember to convert date to the table format while selecting... '%' Sign can be used only with a string and if ur date format in the table is datetime then that cant be done

PPK