Post reply

number that increment at teh start of each cycle and resets for each new district

  • April 18, 2012 at 7:40 am

    #1475338

    kiran.rajenimbalkar (4/18/2012)

    Ya its working but I have many district so what can I do? and I want to show all columns as I have mentioned in my SQL.

    So please do the need full Sir

    You'll first need to post some DDL and sample data in a readily consumable format (not an Excel spreadsheet)

    as well as the expected results. Have a look at the link in my signature for details on how to do this.

    ____________________________________________________

    Deja View - The strange feeling that somewhere, sometime you've optimised this query before

    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

  • April 19, 2012 at 12:56 am

    #1475864

    Hi,

    For my above requirment i want,

    dq_cycle_cnt.:

    Every time a district reach qualification status , cycle time should set a count +1 to the previous count.

    So for each district we have seq nbr, dq status and dq eff dt.

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

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