Thanks rasmi.

Now i get the following error.

Error: Failed to lock variable "user::varFilePath" for read access with error 0xC0010001 "The variable cannot be found. This occurs when an attempt is made...

hi paul,

I have added variables as ReadOnlyVariables.

Can u plz tell me how to check namespace?

Hi Thanks for suggestion.

Can u plz explore it by small example?

Hi Paul,

Can you give example and explore it?

Hi,

For 6 log files column r same and remaining r different.Can u please send scenario for both situation.

thanks in advance.

Thank you!

🙂

thank u Niraj

regards

Abj

ya,exactly i want that.but user should select week number from particular year. i.e. week number is parameter.and from that week number i want to decide week date range including sunday.

thank...

Hi Steve,

I solved my problem,i found very useful sql which u send

thank u

Steve I m giving 2 tables in brief

tbl1 contains date,Monthkey,prvmonthkey where monthky becomes prvmonthkey in next month.

tbl2 contains acs,amt.

so i have write nested query n its not working properly.

thank u very much Steve,It's Working.

Thank u Steve,

Exact u got my problem.But will u tell me how to use temp tables?

Steve,

Actually i want to display prv months and current months records depend upon selection of date.So that i am using two different queries but it shoes records only from dataset...

thnk u williams

its working