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 2000 Forums
 Transact-SQL (2000)
 Record update

Author  Topic 

PATPC999
Starting Member

8 Posts

Posted - 2011-03-16 : 14:31:02
I have one file with multiple records for a person(one for each year).
I want to update their 2010 record with the same field from their 2009 record.
Not even sure where to begin.

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2011-03-16 : 14:36:36
Please post the DDL for the table.

Jim

Everyday I learn something that somebody else already knew
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-16 : 14:37:26
Show us your table structure, sample before data, and sample after data.

Are you even using SQL Server? You are using terms (file/record) that are not consistent with a relational dbms.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -