Server Control Remove Span

Normally when you write a server control, .Net automatically wraps the output with a span and the Id of the control. Depending on your CSS this can cause rendering issues. You can use the following technique to prevent the span from being rendered.

public override void RenderBeginTag(HtmlTextWriter writer)
{
    using (HtmlTextWriter blankOne = new HtmlTextWriter(new System.IO.StringWriter()))
    {
        base.RenderBeginTag(blankOne);
    }
}
public override void RenderEndTag(HtmlTextWriter writer)
{
}

It basically writes out the open tag to a new HTML Writer and therefore is not part of the final rendered HTML

Delete with Inner join

The following example shows how to perform a delete using an inner join

DELETE 
    a 
FROM 
    StatementlineassociatedPayment AS a
INNER JOIN 
    rebatePatientStatementLine AS b  
ON  
    a.StatementlineId = b.Id
INNER JOIN 
    rebatePatientSummary AS c 
ON 
    b.summaryId = c.Id
WHERE 
    c.IssueStatus <> 2