Dear ChrisM,

Ok I will try to fix it.

Thanks ChrisM, for your efforts for me.

But it gives me error "Out of Memory" and not able to execute. What to do?

Hi All,

No any comments, What happen? I am waiting for answer. I was on leave for a week. Pls give me some solution.

R.P.Rozema,

I want to remove the duplicates as a one-off task.

Vinu,

1. "TRU-90-JK" is not in output b'coz of this condition -

and h.perf_date between 14411 and 14755

and for "TRU-90-JK" perf_date is

doc_history

14526 | C | 17589

2. Query create the...

Refer R.P.Rozema post above. It is Sybase adaptive server (SQL J).

Not MSSQL.

Ok Vinu,

Tabel Structure

doc_header (docno [alphanumeric], docno_i [integer], description [alphanumeric], doc_type [alphanumeric])

doc_history (docno_i [integer], doc_status [alphanumeric], perf_date [integer])

doc_signoff_tree (docno_i [integer], ref_docno_i [integer])

doc_replacement (docno_i [integer], ref_docno_i [integer], replacement_code [alphanumeric])

Sample Data

doc_header

[docno] ...

Hi Vinu,

I think solution you have given is perfect. but I am not able to use it with my query. Pls see below is my query.

===========

select m.docno, m.adref, m.perf_date from

(

...

Thanks Vinu,

You have given perfect solution. But I have observed that some records are missing from output (this is my fault for incomplete sample data). After research it is found...

I found following site only. Please check. But I couldn't found anything useful here.

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.java/html/java/java118.htm

Dear R.P.Rozema,

I understand your concern, don't get angry. Sorry for troubling you. But frankly speaking I can't find the forum for SQL J. I am using SQL J for my...

Hi Vinu Vijayan,

Max() function does not gives intended output. Because row selection from duplicate records is based on column2 value. If column2 value is present then select that row in...

Thanks for helping me. But 'ROW_NUMBER() Over' function is unknown in SQL version I am using (Gives error message). What is alternative solution to this problem. Any simple technique using...

Hi,

The output of my query contains duplicate records (i.e. column1 value is similar but other column's value different) as well as single record having column2 value blanks(-). now I want...