How can i get sum of quarters for each year with datepart function.

thanks

select period,Hours from table Emp

REsult set

period ...

How can i update table A from Table B when i found records from the EXCEPT cluse, ie; want to update table A with table B where i found records...

do i need to compare with CHECKSUM for each n every field like

WHERE

CHECKSUM(serverA.Column1,ServerA.Column2)

<>

CHECKSUM(ServerB.Column1,ServerB.Column2)

I think this worked well for me.

where month(date) in (3,6,9,12)

you are right.

I was just posting full proc just...

yeah u guys gace some ideas before and followed tha same here also, but still it takes like more than 5min.

thanks for your help guys

these are very old procs written by some one else years back, trying to make it faster as they are in the daily jobs.

I was assuming this can be dont...

thank you so much for the help, i'll keep debugging it.

joins shud reflect in my original store proc, am just trying to rewrite the original one, thats all.

unfortunately there was no records returned to me.

its just empty, where am supposed to get 22 rows.

yes it has the right data for those tables.

Thanks a lot for working on this.

yeah i got some result of 10 rows, but i was wondering how this wud replace my cursor, as it is a row by...

For that select statement i am not getting any data returned.

CREATE TABLE [dbo].[Audits_Comments](

[CommentId] [int] IDENTITY(1,1) NOT NULL,

[AuditInspectionItemId] [int] NULL,

[Comment] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

CONSTRAINT [PK_Audits_Comments] PRIMARY KEY NONCLUSTERED

(

[CommentId] ASC

)WITH...

Lynn Pettis

yeah i'll change the naming conevention, actually it was written by some one else long back in 2000, now since they migrated to 2005, i have to work on...