April 13, 2008 at 3:46 pm
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
April 13, 2008 at 4:38 pm
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