Could somebody help me,

any idea on how to join the same table to compare accountno and name for 2012 and 2013

Thanka ton in advance

Dhani

Thank you Christian Graus,

I am glad, just want to learn a new way to do the things, i greatful to all of the gurus here,

but the one you posted in...

Thank you very much Luis ,

it is really great solution , and simpler form

i greatful to you,

Thank you

Dhani

Mark Thank you very much for your example

it worked very well for me

i greatful to you,

is it something can be done in sql, or do we need to do step by step process for this

i am trying hard but no use, could somebody help...

Could somebody please help me

Thank you in advance

asitti

Hello All,

thank you for your inputs, i appreciate your help,

unluckly i dont have any audit/log enabled

now onwards, how can i make it auditable (with out my dba interfere), what could...

hello all pleasse share any ideas

thank you in advance

Could Sombody please assist me

I Greatful to you

thank you

Finally merge staement worked as below

MERGE studentnew AS stTarg

USING (select [Sno], [Sname] , [DoB],[City],[Fee] , [State]from [StudentOffers]) AS studSrc

ON studSrc.sno=stTarg.sno and studSrc.sname = stTarg.sname

...

Could somebody please assist me

if i write update statement without any where clause, it is full table scan,

here the in my exist stable they have about 7 million rows, and...

Please Find the individual statements

--Update Statement

UPDATE a

set Points=

case when (a.lastGamedate is null and b.fee>0) then b.fee

when (a.lastGamedate is not null and dateadd(DAY,49,lastgamedate) >= getdate() and a.Points < b.Fee )...

Thank you livingston,

i thought it is simple, but when i am writing the code indidvidual update stement it is taking time,

i am sorry it is not ready yet, but...

please help me

Kind Regards

asittti

pleae see the DDL and logic it require for this query

please assist me here,

create table Student

CREATE TABLE [dbo].[StudentNew] (

[Sno] ...