I am looking for help on a crosstab query. Ideally I would like to run this as a procedure that can take a month and year as parameters.
The query should be simple. The attached ER shows the relationsip. The attached xl doc shows the output.
I need to pivot the data so that the columns along the top are the day value in TxDateTime for a given month and year (as parameters). In the day columns it should show a count of siteTx records and the first column would be the document title from tbl_content. Action would always be filtered for value of 2.
Is this possible in sql 2005?
thanks for any help in advance.