Hi,
Thanks for the details but I don't have access to run these commands in our db. I can access from report end....
Means I need to use whatever tables already there in my package as I told you earlier.....I need to use Merchandise week table from my package which is having values like wk1,wk2.....wk53 for each year..
Only thing I can do is use the fucntions which is there in report level like date functions or case,if,for anything to get our output.
Thanks
Gopi