Post reply

SQL Server Function: Cursor or Tally Table; which to use, HELP

  • February 13, 2014 at 6:19 am

    #1688695

    knives the fix is rediculously easy;

    the Tally table needs to start at zero instead of one.

    so this tiny subsection changes:

    TALLY (N) AS (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 0)) FROM THOUSANDS)

    --change to

    TALLY (N) AS (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 0)) - 1 FROM THOUSANDS)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 13, 2014 at 6:49 am

    #1688709

    Hi lowell

    I've managed to sort it now, figured it out about 2 mins after posting. Having a blond day today.

    In the THEN clause I just -7 after the calculation. This moves all predicted dates back 7 days.

    Sorry for not updating post, only just had a spare minute.

    Thanks for the help, it's appreciated 🙂

Viewing 2 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply