Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Using IF in a SELECT statement?

    Join is the Answer and right Approach to this problem.

    AMIT KULSHRESTHA

    SOFTWARE ENGINEER

    NEW DELHI,INDIA

  • RE: Previous date's value

    very simple one .. use self join and take from one starting balance and from another ending balance

    Cheers

    AMIT KULSHRESTHA

    SOFTWARE ENGINEER

    NEW DELHI,INDIA

  • RE: Identity column resetting

    yes identity column can be reset as follows

    DBCC CHECKIDENT (<TableName>, RESEED, <reseed value>)

    AMIT KULSHRESTHA

    SOFTWARE ENGINEER

    NEW DELHI,INDIA

Viewing 3 posts - 1 through 3 (of 3 total)