If I understand correctly, you want to bump @from_dt by one day.  So say @from_date = 1/31/2005, you would want fiscal_day to be 1 (as in 2/1/2005) not 32.

If that's...

Well, I'm not quite sure what you mean "do it in SQL Server".  Do you have RTF text stored in a field and are trying to turn it into plain...

I wonder if Crystal is having a problem determing the field type for the case field because the ELSE clause returns NULL.  Can you have the ELSE return a valid...

This is way too much fun.

I have an unnatural aversion to temp tables and an equally unnatural propensity for clever querying.

SELECT
MinRange = (SELECT ISNULL(MAX(subA.TheKey),0)+1...

Just for fun, here's another variation on the first answer:

SELECT

   Key+1

FROM

   MyTable 

WHERE

    --The next # is missing

   Key+1 NOT IN (SELECT Key FROM MyTable)

AND

   --We haven't reached the max of...