spGetAvailablePolls

                CREATE   Procedure [dbo].[spGetAvailablePolls](@ClientsID int)
                    as

                    Select 
                    sp.ID as 'PollID', 
                        sc.XMLData as 'XMLData',
                    sp.Question,
                        sc.PublishDate,
                        sp.AttributeTypesID, 
                    sp.LastActivityDate
                    from dbo.SitePolls sp
                    inner join dbo.ClientSites cs on cs.ID = sp.ClientSitesID
                        inner join dbo.SiteContent sc on sc.ID = sp.ID
                    where cs.ClientsID=@ClientsID
                          --and sc.ExpireDate > getutcdate()
                          and sp.Closed = 0
                        order by sp.LastActivityDate DESC