have a look at different CMS like silverstripe and jhoomla.......they may help you get better understanding of the storage...

The reply by grasshopper seems to be correct. You can make it general by passing the date you need.

Let variable @datepassed be the date for which you match the records

SELECT...

great article....thank you very much.....the simplicity of the language is greatly appreciated...do come up with more of such articles...thank you

some of the things i might add....

1.have indexes on columns which u knw will be frequently used to query

2.initiate change tracking for your databases and the tables....this will help you...

problem solved.......actually very stupid of me......i didn't link the sqlCommand to the sqlParameter..........those were just two independent entities.......new ways thanks for your time....

well i am using SQL 2008..and ASP.NET 3.5......

the problem is the stored procedure works fine when i execute the 'query' given in 4th code of my original Post. but when...