hi i came across one post by one of SQL Master. let me share it with you.

you can use this for dynamic pivot.

Requirements:

table: RRTab (user_name varchar(100),Day datetime,time int)...

Akhil Thank you ..

Can you please let me know , what should be the best way to maintain the LOG file so that can not create issue on production....

Data file is : 5 GB appox and log file size is 4.541

Thank you for your support.

DBCC SHINKDATABASE , can help us to over come this issue?

Jai ho.. Sambha....

Oh Thank you for your reply.

Pd.

Hi All thx a lot..

thanks a lot..Paul ..

You are an expert SQL guy.. it really sounds great solution, and exactly what i was looking for.

Frnds....

Can we use Horizontal Partitioning on table ? this may reduce the processing time..