Consolidating rows in table - 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

SQL Server 2000 Forums

SQL Server Development (2000)

Consolidating rows in table

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-29 : 09:16:58

Manuel Negron, Jr. writes "I was asked to do a conversion for work and by mistake I mixed up the FIRST and LASTNAME in the same column. I need to consolidate FIRST and LASTNAME which would be an easy task if it wasn't for the fact that they eneded up in different rows. Let me illustrate by showing you an example:

This is what I have:

FNAME		LNAME		SSN		ACCOUNT_NUM

BLAISE				567779903	123456666
PASCAL
MARIA				545484855	454544545
SMITH
LINDA				541215445	548787878
LOVELACE
HERMAN				877787555	878799955
HOLLERITH
MICKEY				657655747	764556565

MOUSE

And this is what I need (Table name is irrelevant):

FNAME		LNAME		SSN		ACCOUNT_NUM

BLAISE		PASCAL		567779903	123456666
MARIA		SMITH		545484855	454544545
LINDA		LOVELACE	541215445	548787878
HERMAN		HOLLERITH	877787555	878799955
MICKEY		MOUSE		657655747	764556565"

maneve
Starting Member

1 Post

Posted - 2001-12-12 : 14:29:04

This is a late reply but I just wanted to THANK YOU, very very much for your help!!! I hope this "help" is returned to you with huge interest rates.

Manny

"if you are not part of the solution you are part of the precipitate"

Edited by - maneve on 12/12/2001 14:30:04

PiecesOfEight
Posting Yak Master

200 Posts

Posted - 2001-12-12 : 18:11:51

You're welcome. I'm glad I could help.

Cheers
Michael

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources