I have quite many queries and i would like to save its row count results into a single table, also by adding some kind of identifier to the row count results.
this is what i have for now, which works not how i would like to output the results;
select count(*) as 'FI' from
where land1 = 'FI'
select count(*) as 'SE' from
where land1 = 'SE'
The result from the above query is :
FI (Column name)
100 (this is result of the 2nd query, but its difficult to know, as it takes into account the lowest no. of rows)
123 (result of the 1st query, for FI)
i would like to have it outputed in a certain format if its even possible.
Result_Description Row_Count Result_Date
SE_Country 100 03/08/2010
FI_Country 123 03/08/2010
also these results to be saved in another table, along with a date, i guess that could just be automated when the record was created?