84gopi all 14 of your posts over the last 20 days are on the same subject: showing your data by weeks and ranges of weeks, in what i think is a cross tab format.

Sample Data has been requested in more than half of those posts (that means a CREATE TABLE statement, INSERT INTO statements showing example data)

but you never provided it.

There's a lot of "best guess" posts and examples some of our volunteers, including myself have thrown out there, but instead of following up on those examples, and clarifying with your real DDL/sample data, you create new posts instead.

Help us help you! stick with one of those posts you feel you can understand or need additional explanations on.

take the time to right click the table in your database and script it, and create a few rows of sample data.

only with that will you get a solid, tested, workable example.