I ahve run a select query on a table to count the number of instances of a customers status occur over the last 12 months
As below
SELECT SF1_DBA_CUST_COMP_PROFILES.PER_ID, SF1_DBA_CUST_COMP_PROFILES.STATUS, Count(SF1_DBA_CUST_COMP_PROFILES.STATUS) AS CountOfSTATUS
FROM SF1_DBA_CUST_COMP_PROFILES
GROUP BY SF1_DBA_CUST_COMP_PROFILES.PER_ID, SF1_DBA_CUST_COMP_PROFILES.STATUS;
When I try to make a table from the results of this so
SELECT SF1_DBA_CUST_COMP_PROFILES.PER_ID, SF1_DBA_CUST_COMP_PROFILES.STATUS, Count(SF1_DBA_CUST_COMP_PROFILES.STATUS) AS CountOfSTATUS INTO steven
FROM SF1_DBA_CUST_COMP_PROFILES
GROUP BY SF1_DBA_CUST_COMP_PROFILES.PER_ID, SF1_DBA_CUST_COMP_PROFILES.STATUS;
I get the error message 'invalid arguement. The table will be 750,000 records or so the origibnal table is far larger4 million+ Any Ideas?
Steven
As below
SELECT SF1_DBA_CUST_COMP_PROFILES.PER_ID, SF1_DBA_CUST_COMP_PROFILES.STATUS, Count(SF1_DBA_CUST_COMP_PROFILES.STATUS) AS CountOfSTATUS
FROM SF1_DBA_CUST_COMP_PROFILES
GROUP BY SF1_DBA_CUST_COMP_PROFILES.PER_ID, SF1_DBA_CUST_COMP_PROFILES.STATUS;
When I try to make a table from the results of this so
SELECT SF1_DBA_CUST_COMP_PROFILES.PER_ID, SF1_DBA_CUST_COMP_PROFILES.STATUS, Count(SF1_DBA_CUST_COMP_PROFILES.STATUS) AS CountOfSTATUS INTO steven
FROM SF1_DBA_CUST_COMP_PROFILES
GROUP BY SF1_DBA_CUST_COMP_PROFILES.PER_ID, SF1_DBA_CUST_COMP_PROFILES.STATUS;
I get the error message 'invalid arguement. The table will be 750,000 records or so the origibnal table is far larger4 million+ Any Ideas?
Steven