Hi Friends,
Thank u for ur help.... And I have Solved this
SELECT * FROM tablename WHERE Date BETWEEN ISNULL(@Fromdate,Date) AND ISNULL(@ToDate,ISNULL(@Fromdate,Date))
AND ID =ISNULL(@Id,ID)
This Query Worked Out For Me.. Thanks Friends for ur contribution....