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.
| Author |
Topic |
|
cmorisetty
Starting Member
2 Posts |
 Posted - 2009-09-10 : 01:36:38
|
| Is there a way where we can find what value is stored in the cell of a SQL Server table and update the values?I have a temp table created inside a Table Valued Function where there are more than 150 columns in it. I need to check each column in each row to find if the value is ‘unspecified’ and if yes then update that value with a null.I have not come across such a logic but it will be interesting to find one. If you happen to know let me know. |
|
|
Sachin.Nand
2937 Posts |
|
|
cmorisetty
Starting Member
2 Posts |
Posted - 2009-09-11 : 01:59:51
|
| Thanks for the reply. However I want similar logic that needs to be done on a temp table which is part of a Table Valued function. This table is already referred using @. So it is kind of hard to implement the logic provided in the link with a temp table. |
 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2009-09-11 : 09:24:47
|
| Tables have cells now?Can we see the code for the TVF? That would seem to be the place to get rid of "unspecified".http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
|
|
|
Best way for updating cells in a TVF table in SQL