Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Function Age Expand / Collapse
Author
Message
Posted Sunday, April 13, 2008 3:46 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 10:20 AM
Points: 79, Visits: 620
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
Post #484184
Posted Sunday, April 13, 2008 4:38 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
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]


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #484189
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse