It is one time requirement

Thanks for your reply...If i have lakhs of records how can i load

Thanks much it works

Thanks Much...That works

The Columns are string....I have stored all these into one string variable

Do we have any other way withput using calendar table

I need to get the transactions weekly for previous weeks from current week.

The weeks should considerd as mentioed in my previous thread

Can you please describe me what is criteria here. Is this column name?

Yes That is right. I have used that logic, but i did not get the data for other dates as well