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 |
|
RPLI
Starting Member
3 Posts |
 Posted - 2009-09-18 : 07:27:19
|
| Sir While comparingy two table's data in MS SQL Ex.Table Name INDU(POLICY_NO,NAME,FROM_DATE,TO_DATE,PREM). Another Table SATI(POLICY_NO,NAME,PREM). Here in INDU TAble Policy_no like 'R/KT/SK/EA/100001', 'RKTSKEA11001'.... And in Sati TablE which is original data Policy_no like 'R-KT-SK-EA-100001', 'R/KT/SK/EA/11001'. I have 200 records in Indu table and 320 records in original Sati table. And there will not be data in NAME column of Indu. Now I wanted to Compare Indu table with Sati Table and if Numeric Number finds in i.e., if 100001 finds in Sati the correct prefix i.e,.R-KT-SK-EA-is to be corrected instead 'R/KT/SK/EA/'in indu table meanwhile the name for the concerned Policy number has to be inserted in Indu table and that compared data should be separated. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-09-18 : 07:35:57
|
| and your question is?___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
 |
|
|
|
|
|
SQL Query