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 |
|
WJHamel
Aged Yak Warrior
651 Posts |
 Posted - 2012-05-09 : 06:23:16
|
| First i'll apologize for not being able to put sample data or specific structures up as i'm not in my office yet.I have a table with source data that i need to compare to a table that was created from that data. I need to verify that the data in certain columns remained "lined up" with one another in the conversion. What i need to do is, for example, in the source data table, compare the columns ECSOID, FNAME, LNAME, MNAME to the same columns in the converted data and ensure that, in the source data, the ECSOID which corresponds to the LName, Fname, and Mname corresponds to the same matches in the converted table. So, essentially, it would be in t1, ECSOID=FNAME=LNAME=MNAME and that this matches with the same ECSOID in the converted table. I need to compare other data between the two as well, but knowing my jumping off point will cover me there.thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-09 : 16:09:41
|
| do you've a key column based on which you identify a row in both tables ie their primary key?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
WJHamel
Aged Yak Warrior
651 Posts |
Posted - 2012-05-10 : 10:50:54
|
| ECSOID |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-10 : 12:06:20
|
quote:
Originally posted by WJHamel
ECSOID
sorry but this is included among compared columns list in last post. so using what column value you determine which rows are to be compared?Can you post some sample data and explain your requirement?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
WJHamel
Aged Yak Warrior
651 Posts |
Posted - 2012-05-10 : 13:49:04
|
| Thanks, but i'm gonna drop this post. Turns out this is not needed after all. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-10 : 15:18:56
|
quote:
Originally posted by WJHamel
Thanks, but i'm gonna drop this post. Turns out this is not needed after all.
ok.. fine then  ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
comparing data