Ray,

I have tried running the script from osql it worked fine, the thing is I want to run the below cmd as a windows batch file. What it will do...

First business day is day which is not weekend not it is Jan 1st. So pretty much it is a first normal working/business day of the week

Thanks

< Okay, but now you have this data in a sql server table?

or is it still in its native database system? >

I have ported this data over to sql server...

Ray,

      The above I am dealing with is a Non relational data which has been designed more than 10 years.

So back then all the information is in 1 column itself .i.e...