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 |
|
atlachar123456
Starting Member
33 Posts |
 Posted - 2011-11-10 : 11:07:15
|
| Hi, I have a requirement to check why the Trd_Linked column is getting 'N' for legal 206337UPDATE #Rpt SET Trd_Linked = 'N' --setting default value as N UPDATE #Rpt SET Trd_Linked = 'Y' FROM #Rpt RT INNER JOIN customer..bus_a_lgle_tree BT ON RT.bus_a_id_c = BT.bus_a_id_c AND RT.lgle_id_c = BT.lgle_id_c WHERE BT.lgle_sys_a_rel_c = 'TRD'Based on this condition i got teh excel sheet with bus id's 205605 and 205629 have same legal id 206337 but the Trd_Linked column is showing as 'N'when i ran this query select * from customer..bus_a_lgle_tree where lgle_id_c = 206337 i got onlybus_a_id_c a s 205605 there is no 205629 can any one fix it how to find why trd_linked column is getting N fo rlegal 206337.atlaaaaaaaa |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-10 : 11:09:53
|
| no idea at all...without seeing any of your data and understanding any of relationships, how do you expect someone to fix this for you?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Issue with Trd_Linked column