spLoadRecord_SitePolls

    CREATE PROCEDURE dbo.spLoadRecord_SitePolls
    (
        @PKID int
    )
    AS

    select * from SitePolls where ID = @PKID

    select spa.* 
    from SitePolls sp INNER JOIN SitePollAnswers spa ON
            spa.SitePollsID = sp.ID 
    where sp.ID = @PKID
    order by spa.SitePollsID, spa.SeqNbr