Hi all:
There is no Cyrillic on this machine again, so please bear with my English. I am wrinting a cimple C# application and one of the things should allow me to supply the date range to a query. Initially the parameters should be blank and I thought of the following construct:


This works fine in SQL 2000 and gives me back entire table, but the result set in VS.NET query builder is empty. I tried to trace, but this bastard uses xp_execsql to run the queries, so I do not see the parameter values that it passes.

I compiled a small proc:


When called from VS.NET with empty parameters it displays 12:00 AM. How do I use this information now? What SQL string do I need to use in order to allow the user to pass certain date range or to skip and provide empty values?

TIA,
Gobzo