Function Age

  • This is what I have but keeps getting error, I have this report I need to generate by Urgency, group and the age of the incident by open date

    this is what I have

    select

    [Incident #],

    [Urgency ID],

    [Group Name],

    Open Date & Time],

    [_SMDBA_.Incident_Age = datediff] (d, [Open Date & Time], getdate())-----ERROR is at this line

    from [_SMDBA_.Incident_Age

    where [Open Date & Time] > '2007-1-1' and [Close Date & Time]= NULL

    and [Group Name] = 'NOC'

    group by [Group Name] , [Urgency ID],[_SMDBA_.Incident_Age]

    Can anyone hep Thanks

  • Wow. OK, well first, you are definitely in the wrong forum, I would suggest a T-SQL forum or similar here on this site.

    And secondly, read this link to see how to get better responses to your posts:

    [urlhttp://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply