spLoadRecord_Clients

                    CREATE procedure [dbo].[spLoadRecord_Clients]
                    (
                            @PKID int
                    )
                    as
                        select [ID], [Name], [RESerialNumber], [Guid], [OwnerID], [Deleted], 
                                [HomePhoneType], [BusinessPhoneType], [EmailPhoneType], [InterestsTypeID], 
                                [RECountryMask], [defPrivacy], [OrigID], [Address1], [Address2], [City], [PostCode], [SearchEnabled],
                                [Options],[OrganizationPhoneType],[WebSitePhoneType],[Phone1Type],[Phone2Type],[Phone3Type],[Phone4Type],[Phone5Type], [LinkedInPhoneType]
                        from dbo.Clients where ID = @PKID
                        return