thanks to all

hi cold coffee,thanks a lot.it worked.yes i am working on 2005 but dont have much idea about the newer stuff.

Yes,Andrew.Thanks a lot.

dear andrew each date for a customer is to be considered with the previous visit of that customer.for example if there are 5 visits A,B,C,D,E the E is condered with...

hi lowell,thanks for the help.2 questions apart from SELECT * FROM [ReorderS] where Item is not null there is one more count.so it is acually SELECT * FROM [ReorderS] where...

Hi Gurus,

I am not able to make much progress.If I have the below

if (select count(*) from FROM [ReorderS] where Item is not null) > 0

I get error incorrect systax...

Hi torpkev,

I found what was the issue.the view was using an oracle function userenv('LANG') to get the language of the current session in oracle.since we have one US English,so instead...

No,I am not able to understand why datatype will be a issue in a select statement.2)this column is of varchar type.Every other column I am able to retrieve info.

I have a ERP which is running on Oracle and a retail application which is in SQL Server.Oracle has the Employee information and I have created view which I...

I am accessing Oracle from SQL Server.And both are on different machines.

The qoutes in Sandro is because I am executing the query in SQL Server and I guess that is the syntax for that.Also the same query when I run in...

sorry that was a typo mistake.thanks any for the help

sir,

that didnt work.what I did was like this

''' + str(@val2 ,21, 2)+ ''' and it worked

sir,that was a dummy table for this cae.I dont know what is the reason,is it becuase there are 1000 rows?the output of the cursor shows as I mentioned as 121.1...

hello sir,there seems to be one issue with this.the quantity column in the table ReorderS is a number.Using this way I find that value is in some case getting rounded...