Thanks for the reply. I got the correct result. But can u explain a little bit. what approach did u follow?

Specially this part:

;WITH rns56

AS

(

SELECT TOP 56...

I would still go with the past 8 weeks.

In most cases the input will be getdate. If the user inputs any date lets say '5/30/2012' or even calculates on...

This is not for queries.. It is related to table design...

Thanks

I catched the error.. Its solved.

Thanks all for the support !!

I am using column names instead of * still getting the error. Can you please provide me the sql.

I am getting the below error while creating the function:

Column names in each view or function must be unique. Column name 'id' in view or function 'fn_name' is specified more...

Thanks !!

Thanks a lot !!

So does that mean that creating an inline function is same as parametrized view.

Regards,

Nidhi