•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 391,962 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,037 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 536 | Replies: 0
 |
•
•
Join Date: Mar 2007
Location: South Africa
Posts: 14
Reputation: 
Rep Power: 2
Solved Threads: 0
Newbie Poster
hi All
i realy need your Help. i have a Table named Property, this Table has a Field named "Lis_key" and Attrib_code and "Func_key", my Table can look like this
Figuire:1
Now from the Above table, i call records that have Func_key "Parents" and Records that has Func_key "Children". and in my table there are many Parents that have no Children. Am interested in those that have Children. As you can see the Attrib_code of Children is Null, i have this query that Find the Parents that has Children. and its like this
Figuire:2
and now as you above, table this Parents have Children with a Fun_key that is like "GEOSS", and they are null. i want to Copy a Attrib_code of a Parent to a Child as long as the Lis_key as the same. and the Final results should be like this
No more Nulls for Attrbi_code for GEOSS, So i need an update Statement for the Children.
Thanks
Please Help
i realy need your Help. i have a Table named Property, this Table has a Field named "Lis_key" and Attrib_code and "Func_key", my Table can look like this
Lis_key ===========Attrib_code========================= Func_key====== ===================================================================== 01424545 1212033993 PV000000 01424545 Null GEOSS001 01424545 Null GEOSS002 01424545 Null GEOSS003
Figuire:1
Now from the Above table, i call records that have Func_key "Parents" and Records that has Func_key "Children". and in my table there are many Parents that have no Children. Am interested in those that have Children. As you can see the Attrib_code of Children is Null, i have this query that Find the Parents that has Children. and its like this
select p1.Attrib_code,p1.Lis_key from sde.property_Backup p1 where p1.func_key = 'PV000000' and exists (select 1 from sde.property_Backup p2 where p2.lis_key = p1.lis_key and substring(p2.func_key,1,5)='GEOSS' And P1.aCTIVE =1)
Lis_key ======Attrib_code============Func_key====== =========================================== 01424545 1212033993 PV000000 01424545 1215035993 PV000000 01424545 3599345445 PV000000 01424545 5035934544 PV000000
and now as you above, table this Parents have Children with a Fun_key that is like "GEOSS", and they are null. i want to Copy a Attrib_code of a Parent to a Child as long as the Lis_key as the same. and the Final results should be like this
Lis_key ======Attrib_code=========Func_key====== ============================================ 01424545 1212033993 PV000000 01424545 1212033993 GEOSS001 01424545 1212033993 GEOSS002 01424545 1212033993 GEOSS003
Thanks
Please Help
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
•
•
•
•
ajax asp database decimal seperator thousand seperator when using sql server deleting records from ms sql table where columns have duplicate values developer development hacker management studio 2005 microsoft msdn news office security software sql sql cache dependency with polling-based invalidation survey vista
- Previous Thread: Selecting E-mail Addresses
- Next Thread: How do I ban ip addresses using MsSQL script?
