I am attempting to perform a simple query to get the number of redemptions during a specified period of time using the DatePart function of Sql Server.  Everything was going great until I need to Group By the datepart functions since I am using the count() function in the select clause. Originally I put in the following code thinking it ...

I'm able to use the Dynamic Query API to build a SELECT statement with a GROUP BY.  But, is there a way to extend that query to add a HAVING clause? For example, using Northwind, I would like to use the Dynamic Query API to generate a SQL query that looks like the following SELECT statement:Code:SELECT c.CustomerID FROM Customers c LEFT ...