relation - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

relation

Author

Topic

kashyap_sql
Posting Yak Master

174 Posts

Posted - 2010-08-10 : 10:02:22

i want a query that insert a data into the column
let me explain clearly i has a table for example


Create table Srikari
(No int IDENTITY(1,1),
 Members varchar(20) NOT NULL,
 Designation varchar(20) NOT NULL,
 Place varchar(20) NOT Null,
 Year smallint NOT NULL
)
insert into srikari Values 
('Sriram', 'Chief-Secretary','Jillellamudi','2001')
insert into srikari Values
('Hema kumar','President','Hyderabad','2001')
insert into srikari Values
('Bhushan','Secretary','Vijawada','2001')
insert into srikari Values
('Bharavi','Vice-President','Vizag','2001')
insert into srikari Values
('Pardhu','Treasurer','Bapatla','2001')
insert into srikari Values
('Vamsi','Member','Ongole','2001')
insert into srikari Values
('Kashyap','Member','Bapatla','2001')
insert into srikari Values
('Nageswar','Member','Bapatla','2001')
.
.
.
.
drop table srikari

i want to change the column_Designation "member as Partner" when both column_place is bapatla and column_year is 2001
unable to make a relation plz help

With Regards
Kashyap M

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-08-10 : 10:19:00

Try this -


UPDATE srikari SET Designation = 
CASE WHEN Place = 'bapatla' AND [Year] = 2001 THEN 'member as partner' ELSE Designation END

Let me know if I understood wrongly...

Vaibhav T

To walk FAST walk ALONE
To walk FAR walk TOGETHER

kashyap_sql
Posting Yak Master

174 Posts

Posted - 2010-08-10 : 10:23:14

quote:
Originally posted by vaibhavktiwari83

Try this -

UPDATE srikari SET Designation =
CASE WHEN Place = 'bapatla' AND [Year] = 2001 THEN 'partner' ELSE Designation END

that's what i want nice just small modification just a member to partner which i made any way it works thanks

With Regards
Kashyap M

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-08-10 : 10:28:19

Welcome

Vaibhav T

To walk FAST walk ALONE
To walk FAR walk TOGETHER

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources