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)
 Update Query

Author  Topic 

Brittney10
Posting Yak Master

154 Posts

Posted - 2013-09-22 : 21:27:11
I need to create an update statement that will find the nth instance of a value and replace it with a blank/empty value. The value will be repeated 3 times, and I need the 2nd instance of the value removed.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2013-09-23 : 01:22:49
Is that not you want?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=188384

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -