SQL Server 2005 -I want duration from the condition below- without cursor would be preferred
I have the following table: CREATE TABLE [dbo].[DurationCalc]( [Id] [int] IDENTITY(1,1) NOT NULL, [ContractId] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Status] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ModDate] [smalldatetime] NULL ) ON [PRIMARY] And the following are the records INSERT INTO Tabletest1 values (5,’O',’2009-01-01 00:00:00.000′) INSERT INTO Tabletest1 values (5,’C',’2009-01-02 00:00:00.000′) INSERT INTO Tabletest1 values (5,’S',’2009-01-04 00:00:00.000′) INSERT INTO [...]

Answer Question   |  June 10, 2009  12:20 PM
SQL Server 2005, SQL Server Condition