Thanks a lot.

If clinic is inpatient then it is inpatient.Else it is Outpatient.

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