Hi, Why not do it without Direct SQL?
Action 1: Set-Fields: From: CHG:Association_ID02Join ('Request ID01'>= $Incident Number$ AND 'RequestID02_Status >= "Completed") Integer Field = $LASTCOUNT$ + LEFT($1$, 0) If you have a lot of matches, and do the count often, using this method might have a slight performance impact. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > Hi Pamela, > > You need to replace the double quotes with single quotes for this to work. > > Regards, > > Chris > > > -----Original 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, > > 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 grateful with your help > > Thanks > > Pamela > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers > Are, and have been for 20 years" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"