Jeff,

I have tested the below script.

create table #test

(

Sample Bit

)

insert into #test

select 1

union all

select 0

union all

select 1

union all

select 0

...

yes.

If so, how else would you do...

Sure.

So as your people said , table should be created with clustered index.

But unfortunately table doesn't have clustered index.

what is the solution to solve this problem ?

i.e do i...

Can you explain me about Hidden RBAR or Triangular Join ? I have studied your article 'Triangular Join'. After that lot of doubts arises. Its like putting stone in a...

The way you use it - Yes, it can't use the index

This is OK

where col = @f+'g'

But this is not

where col+'g' = 'abcdefg'

If you use a function on a...

Thanks a lot Lynn Patel !

No, It has to reset for each employee. Also it has to rest for...

As you said if i subtract it from 13 it will give correct result. But assume if any month is missed in the sequence,out query will give wrong sequence. How...

Thanks Jeff for leading me in the right direction to lesson me about SET BASED concept and giving new ideas to me.Also my Thanks to rbarryyoung and Christopher for giving...

Hi Christopher,

Here time is 9:00 PM ,So i have planned to leave. Please do post your reply.

will it work out ?

Christoper,

sorry for not including, i am using Sql2000.

Christoper,

sorry for not including, i am using Sql2000.

Sorry! A little modification in the procedure.

Create procedure p1

(

@dt datetime,

@eno int

)

as

begin

Declare @eno int,@date datetime,@pdata decimal(5,8),@gdata decimal(5,8)

Declare @FinalData decimal(5,8), @FinalData1 decimal(5,8)

set @FinalData = 1,@FinalData1 = 1

Declare cursor c1

for select EmpNo,PerDate,PerformanceData,GrossData

from emp

for...

I want to update the below blank column by using the mentioned formula posted earlier.

EmpNo PerDate PerformanceData GrossData FinalData

1 ...