none
Help UnderStanding SSRS SQL

    Question

  • Someone else developed these SSRS reports and I know what the SQL means but when I view the report it has some special characters in the query.  This is the query behind the report can someone explain to me what the <> mean?  Are they fields on the report that I need to locate?  Is it special SSRS reporting formatting?

    Select Count(*) from tbl_user_login_data
    Where isnull(username, '') <> '' and isnull(logindate, '') <> ''

    EDIT ---

    And SQL Server throws the error of:

    Msg 4145, Level 15, State 1, Line 9

    An expression of non-Boolean type specified in a context where a condition is expected, near ';'.

    • Edited by Joe Marx's Saturday, July 19, 2014 5:13 PM
    Saturday, July 19, 2014 5:11 PM

Answers

  • it should be this

    Select Count(*) from tbl_user_login_data
    Where isnull(username, '') <> '' and isnull(logindate, '') <> ''

    which means NOT EQUAL TO

    you might have viewed xml which is why it displayed them as &lt; &gt; etc as <,> etc are special characters in XML


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Marked as answer by Joe Marx's Saturday, July 19, 2014 6:46 PM
    Saturday, July 19, 2014 6:15 PM