Index: trunk/grails-app/services/com/lemans/ds/fitment/PartFitmentService.groovy =================================================================== diff -u -r8704 -r9989 --- trunk/grails-app/services/com/lemans/ds/fitment/PartFitmentService.groovy (.../PartFitmentService.groovy) (revision 8704) +++ trunk/grails-app/services/com/lemans/ds/fitment/PartFitmentService.groovy (.../PartFitmentService.groovy) (revision 9989) @@ -49,12 +49,12 @@ } private String fitmentsByModelYearIdSql(Integer modelYearIdCount, String columns = null) { - """SELECT ${columns ?: '*'} FROM dbo.PartFitment + """SELECT ${columns ?: '*'} FROM dbo.PartFitment WITH(NOLOCK) WHERE partNumber = ? AND modelYearId IN (${placeHolders(modelYearIdCount)}) AND dateDeleted IS NULL""" } private String fitmentsByPartFitmentIdSql(Integer partFitmentIdCount, String columns = null) { - """SELECT ${columns ?: '*'} FROM dbo.PartFitment + """SELECT ${columns ?: '*'} FROM dbo.PartFitment WITH(NOLOCK) WHERE partNumber = ? AND partFitmentId IN (${placeHolders(partFitmentIdCount)}) AND dateDeleted IS NULL""" }