We need to run a query which pulls a count of all the records added by day into a data extension. We cannot use any of the reports as the system add date is the same for every record.
We created a query which should pull the aggregated date + count data. When we compile it says it is fine - however when we execute the query nothing happens.
SELECT CONVERT(date, O.ouraddate) as dateadded, count(*) as count FROM [Our customer table] O with (nolock) group by CONVERT(date, O.ouraddate)
The data extension this query is loading into contains 2 fields: count - Text(100) dateadded - Text(100)
Anyone know how we can get this query to work?