http://msdn.microsoft.com/en-us/library/aa174792.aspx

http://databases.about.com/od/sqlserver/a/storedprocedure.htm

Just go through the above link,I hope you will get some idea.

Concur...

if you don't want to do something ,then simply

select name from master.dbo.sysobjects where name ='Table1' and xtype ='U'

Also How may member groups are available ?

What is mean by PM ?

whether it is better to handle via DB side or from Front End side.

Any Inputs ?

Note: The above code has used cursor earlier,I have replaced it by using 'Iteration' or 'Tally' table.

Time taken before (cursor method) : 20 Minutes

Time taken after(After replacing Cursor with TALLY...

UPDATE #PfManager

SET monthEnd = ( select MAX(dt)

FROM PMag A

WHERE #PfManager.SP = A.SP

AND A.sno IN ( SELECT MID FROM Mgr WHERE SP = #PfManager.SP)

AND A.Type <>'T' Group BY SP) ...

Jeff,

Just i am thinking, will Tally table be a good replacement for this cursor ?

Jeff,

Thanks for highlighting some good points.

Table doesn't have a single clustered index. But it have non clustered index on mid.

Will it help to resolve this running total issue ?

Janine,

Thanks for...

Jeff,

Thanks a lot.

is it possible to create Tally table starting with 'Zero' ?

Any Comments or suggestions?

i got the below output

code N Count

---- ------- -----------

1X...

I tried the below code.

create table #emp

(

mid int,

status char(1),

code varchar(5)

)

insert into #emp

select 1,'A','1X'

union all

select 25,'A','1X'

union all

select 37, 'T','1X'

union all

select 42,'T','2X'

union all

select 58,'A','2X'

union all

select 61,'A','3X'

select * from #emp

select code,N,count(code)

from #emp,Tally

group by...

Just i am thinking ,why can't we create the running number based on the code ?

Running number has to increase when there is no change found on the CODE,if found...