Results 1 to 13 of 13

Thread: Get duplicate and related data on same table?

Threaded View

  1. Oct 20th, 2011, 05:59 PM #11
    Techno
    Techno is offline

    Thread Starter
    PowerPoster
    Join Date
    Aug 2003
    Location
    Edinburgh, UK
    Posts
    2,773

    Re: Get duplicate and related data on same table?

    just to make it easier, i thought i would attach a script with data

    be sure to join Device to DeviceHistory on DeviceID in order to get the DeviceIdentifier (on Device table)

    just create a blank SQL Server 2008/5 DB and run the script against it.
    Attached Files Attached Files

    MVP 2007-2010 any chance of a regain?
    Professional Software Developer and Infrastructure Engineer.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width