I dont have MONTH COLUMN in my table 🙂 as I am populating days of the month dynamically all i have is TASK_ID, TASK_DATE, TASK_COUNT ...thats it..now how to change...

Thanks for your reply. I did try this

--Put it all together into a pivot query.

set @sql = 'SELECT Task_Name, ' + @columnnames + ' , Total FROM (';

set @sql =...

I am almost there as I've got this solution from web searching and results are coming as I was expecting.

CREATE PROCEDURE crosstab

@select varchar(8000),

@sumfunc varchar(100),

@pivot varchar(100),

@table varchar(100)

AS

DECLARE...

is this which i need to install where my VS 2010 is installed ..cause on my database server we do have sqlserver 2008 enterprise R2 and BIDS is there.

Stewart thanks for the file but I cannot open it as I am using Visual Studio 2010 🙁

its working in Oracle but dont know how to convert it into SQL.

WITHstart_dateAS

(

SELECTTO_DATE ( '01-Jan-2010'

, 'DD-Mon-YYYY'

)AS start_date

FROMdual

)

SELECT m.task_name

, COUNT (CASE WHEN TO_CHAR (d.task_date, 'DD') = '01' THEN 1...

do i need to issue 31 select statements to create 31 columns?

thanks how to create upto number of days column in select statement according to the given month?

Thanks for your answer I am quite new to SQL world 🙂 dont know how to create dates out of the given month in matrix style. or perhaps a view...

jerry-621596 (8/19/2010)

---

Just so I understand...

You are developing a financial application and want something to work for now, hoping it will work in the future? I have developed financial applications...

andrewd.smith Thanks for the answer exactly I was looking for. Hats off to ya 🙂

Thanks for the link but this is not my requirement i mean Calendar table and all. I just want simple query to achieve this like for example.

DECLARE @mydate DATETIME

SELECT @mydate...

Victor I tried your procedure its working fine but having issues related to ordering...the ordering of 2nd level items are not the same as it was entered.

Thanks for your reply but it seems you didnt get my questions properly. Adding space before every node is not what i am looking for infact I want spaces before...