worker bee (1/11/2012)
I know your not inserting columns, :), After you insert you data into the table you are wanting to count the datakey column, if so then your select stmt would be this;Select DataKey Count(*) AS DataKey
FROM TableName
That would just give me the total rows in the table not the figures I am after
Just to expand on what I require:
Total = 9 (total rows)
Total Unqiue Datakey = 6 (total rows ensuring duplicate datakey values are ignored)
Total Unique Landline (1 per unique datakey)= 5 (total rows ensuring duplicate datakey values are ignored and duplicate landline values are ignored and the landline field is populated)
Total Unique Mobile (1 per unique datakey)=5 (total rows ensuring duplicate datakey values are ignored and duplicate moibile values are ignored and the mobile field is populated)
Total Unique Email =3 (total rows ensuring duplicate datakey values are ignored and duplicate email values are ignored and the email field is populated)
Hope this helps make clear what I am after
Thanks