Change it to IsNull(L.EndDate + 1, '2999-12-31') should do the trick

If not, then try

IsNull(DateAdd(d, 1, L.EndDate), '2999-12-31')

This should still work because NULL + anything = NULL.  So adding a day...

Thanks for following up with a solution - nice to know how ppl work around things

What about a view that selects from a user-defined function?  In the UDF you can create your table variables, perform procedural logic and then create a view that does a...

Are you asking how to make MS SQL Server keep a DB entirely in memory, or are planning to use any DB engine (eg Oracle, MySQL, etc).

There are many in...

Your SQL seems to be OK.  What do you mean by ALL rows and what makes you think ISNULL is causing you grief?  I can only imagine that you want...

See this for ADO

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q258038

See this for ADO.NET

http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;308042

I haven't actually read the examples in great detail - I usually program in Delphi using ADO.  Delphi provides some nice stream...

Ahhh ok - thanks for posting the error message.  This makes it very clear what your problem is (well at least less ambiguous  ...

I guess the whole thing with displaying query results is that it is up to the application to format the data - query analyser happens to not be built for displaying...

You could also create a table called KEYS which has a single identity field.  Then your stored proc just does an insert to this table and retrieves the SCOPE_IDENTITY value... ...

Use a text parameter instead - although these are more difficult to parse.  You'll need to parse it into a separate temp table (a table variable would do) and then...

Is there at least a well-defined set of columns, say you may return any 7 of a set of 20 columns?  If so, make a table that contains all of...

Attaching is probably easier and also means you keep your DB diagrams

After restoring, make sure you also look up sp_change_users_login to map database...

If the other guy's app just writes out SQL text to SQL Server (using ADO command, ADO.NET command, OSQL, or even crystal reports, etc) you could simply have (as per...

Windows write caching vs hardware write caching...  Perhaps your sys admins are referring to the prior - the latter is obviously nice as the hardware can have battery backups and...

Almost

Instead of

select * from tablea

INNER JOIN tableb ON tableb.property LIKE '%tablea.property%'

Try

select * from tablea

INNER JOIN tableb ON tableb.property LIKE '%' + tablea.property + '%'

Note that it will perform like...