spLoadRecords_SignOnControls

CREATE PROCEDURE [dbo].[spLoadRecords_SignOnControls]
    @ContentID int
AS
    SELECT a.[FieldID],a.[ParentFieldID],a.[FieldName],a.[CodeTableID],a.[AttribTypeID],a.[DataType],a.[UseShortDescription],b.[ID], b.[Required],b.[Display], b.[Text]  
                from applicationfields as a inner join SignOnControls  as b
                on a.fieldID = b.FieldID AND a.ParentFieldID = b.ParentFieldID AND a.AttribTypeID = b.AttributeTypeID
                WHERE  a.fieldid=101 and b.ContentID = @ContentID 
                ORDER BY b.DisplayOrder ASC