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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Cross Apply

Author  Topic 

sanjay5219
Posting Yak Master

240 Posts

Posted - 2014-12-30 : 08:48:43
Hi All,


I have one table called std and another is std_sub. Now I have to update subject_detail column of STD table like Math,English

Please suggest how to do in Sql 2000

Std_Sub is a below format
std_id,subject
1,Math
1,English
2,Science
2,Math





tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-30 : 12:38:25
We need to see the structure of the std table, sample data for that table and then show us what it should look like after the update.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -