Expected Output

1, 'A' ,'AC',20130101,20130110

2,'B' ,'NON-AC',20130111,20130112

3, 'A' ,'AC', 20130113 ,20130118

4,'B' , 'NON-AC', 20130119 ,20130124

5,'A' ,'AC',20130125, 20130204

6,'C','NON-AC',20130205, 99991231

nice question .. Only one bus is used during a startDateKey and EndDatekey ... No other bus is allowed .

For Example Serial No ...

Hi

I appreciate the solution but failing to the below scenario .. I have added few more records ..

Declare @temp table (SysKey int ,BusName varchar(9) ,BusType...

SQL server 2008R2

solution should be set based only .. .as there are 98 million records that need to be taken care .

Result as not expected

BusnameBusType(No column name)(No column name)

A AC ...

Hi ,

Procedure is working fine ...

Create procedure dbo.SqlServerForum

as

Select Top 1 * from sys.tables

Select Top 1 * from sys.columns

Try...

To encrypt there would be logic that is defined by user

For example: 1234 Coded as 2345 (adding 1 to each digit)

...

You can store Temporary result it either in

Variable Table

Declare @Emp table (EmpID ,DepId)

Temporary Table

Create table #Emp (EmpID ,DepId)

Global Temporary Table

Create...