Thanks Newbie.

i know going with procedures makes the steps easier.

but have some restrictions for me of not to use any procedures.

so trying to do with queries.

Thanks once again.

i solved my problem myself.

thanks

hi along with date function,

it telling that CurrentArea is ambigious.

no result is coming.

the errors are DateAdd(day, -1, Today.RunDate) is showing some prob

and it coming like curren_area is ambigious.

thanks.

hi,

there is some probs with the query.

thanks

Hi,

Teradata is a relational database management system (RDBMS) that provides the foundation enabling a company's IT systems to achieve the goal of "Transforming Transactions into Relationships." Teradata's scalability allows...

 Hi,

Here is the updatde table.

its restricetd not to use procs,this is restriction from my manager.

Create   Table iw_patstrat_genpact_workdb.days_area (

ind integer,

hi,

Ignore [/*drop table test ;*/]

i using Teradata.

Thanks

Hi Veteran,

it was just look good.

but my prob is i should not use any proc.

so for that reason i wrote a big query for finding the working days.

can u help...

Hi friends,

can one tell me how to find the same result without using procedures.

i wanna find the no of working days between two given dates excluding sat an sun without...