November 10, 2011 at 9:06 am
Hi,
I have a requirement to check why the Trd_Linked column is getting 'N' for legal 206337
UPDATE #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 only
bus_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.
November 10, 2011 at 9:09 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1203642-392-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply