Re: Count CRQ related an INC in status=<"Completed"

2015-06-22 Thread Misi Mladoniczky
al Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Pamela Morales > Sent: 19 June 2015 21:32 > To: arslist@ARSLIST.ORG > Subject: Re: Count CRQ related an INC in status=<"Completed" > > Hi Bruce, > &g

Re: Count CRQ related an INC in status=<"Completed"

2015-06-20 Thread Chris Jones
Subject: Re: Count CRQ related an INC in status=<"Completed" Hi Bruce, I tried what you recommend, but I got an error: Invalid column name 'INC2014000903'. (SQL Server 207) (ARERR 552). I'm trying to do this SQL Sentence: SELECT COUNT (*) FROM dbo.CHG_Association_

Re: Count CRQ related an INC in status=<"Completed"

2015-06-19 Thread Pamela Morales
Hi Bruce, I tried what you recommend, but I got an error: Invalid column name 'INC2014000903'. (SQL Server 207) (ARERR 552). I'm trying to do this SQL Sentence: SELECT COUNT (*) FROM dbo.CHG_Association_ID02Join WHERE (Request_ID01 ="$Incident Number$" AND RequestID02_Status>=10) I will be

Re: Count CRQ related an INC in status=<"Completed"

2015-06-18 Thread Wauer, Bruce
t; you would use a value of $2$. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pamela Morales Sent: Thursday, June 18, 2015 2:48 PM To: arslist@ARSLIST.ORG Subject: Count CRQ related an INC in status=<"Completed" Hi

Count CRQ related an INC in status=<"Completed"

2015-06-18 Thread Pamela Morales
Hi, I need know how can I get in a field the result of SELECT COUNT (*) FROM CHG_Association_ID02Join WHERE (Request_ID01 =$Incident Number$ AND RequestID02_Status>=10) What I need is that no one could resolve or close or cancel and incident if it has one or more related changes in status le