i found the solution

Thanks,

Sridhar.

Hi,

Why don't we use And clause in the query? The logic seems correct to me if we use And clause.

Create proc spAnomResults @qte as int =...

Thanks Remi Gregoire. I have worked it out using your sample. I appreciate your help. I'm new to Sql Server. I have started it 6 months back. And I'm learning...

Hi,

Now I have to perform two more Anomalies. One is (Cost > Price) and the other is All Anomalies i.e. Price <= 0 or Cost <= 0...

Thank you All. I have used Remi Gregoire's code. It is working.

Thanks Remi Gregoire.

Thanks,

Sridhar!!

Hi AJ Ahrens,

I have worked it out like this. I opened the file and saved it with other name. And when I ran it, it ran without...

Hi Alzdba,

I know that I can do like the one you suggested. But what I want is the same value with out rounding. that is i need...

O.K. Thanks

Hi,

I have the same excel file for all the excel connections. The only thing that changes is the sheet name with each connection.

Thanks,

Sridhar!!

Hi,

I am creating an excel template manually and placed it in the directory. It is the same excel file for all the excel connections. So I created a...

Thanks David. That worked. Thanks for all your help

Sridhar!!

Hi All,

I have used (len(col1)-len(replace(col1,',',''))) to find the number of occurances of ',' and I am able to display all the records which have those extra column. Now...

Hi all,

Thanks for the suggestions. I'm trying to use s.m.b's idea.

I have loaded all the data into a temp table as a single column.

Now my...

Hi Nicholas,

This problem occurs not very often. So we cannot ask them to use quoted identifier for the data. If you have any vb or perl script,...

Hi Phil,

Thanks for the reply. It worked.

Thanks,

Sridhar!!