Hi David ,

Above query u given is working only in case of a table contain all duplicate records..

But if there are some records which are disstinct it will not work...

I have slightly...

Hi ,

Try this solution.........

select clientid , min(date_in) ,

  case when max(isnull(date_out,GETDATE()))= getdate()

  THEN NULL

 ELSE max(date_out)

END [MAX_DATE]

 from client

group by clientid

Regards

Hi ,

Use the following query!! It's working..

SELECT a.e_id,a.name,a.address,

(case when datepart(qq,dt)=1 then sum(salary) else 0 end) QT_1 ,

(case when datepart(qq,dt)=2 then sum(salary) else 0 end) QT_2 ,

(case when datepart(qq,dt)=3 then sum(salary)...

Hi ,

use a replace function where u r populating the data into table.. e.x..

Select Replace('abc''nhju','''','''''') or

remove the apostrophee..from name

Select Replace('abc''nhju','''','')

Regards ,

Amit Gupta..

Hi ,

The columns u have used in the query r not valid.

Please verify. The column names u have used..

Regards,

Amit Gupta..

Hi ,

Can u send the sample data to me.. so that i can check my logic..

Anyway as per ur requirement i can send u a script which is given below...

It is a data length problem.. the field in which ur inserting the data has less size difined..

Please check the values which ur inserting..

Regards ,

Amit Gupta..

Hi ,

Try this script . it will solve ur problem..

select * from tab_a

union

select distinct j.* from (

select distinct z.b,k.name from(

select * from (

select a.i_d,count(*) b from (

select * from...

Hi ,

David first you have to see the format of record_date for e.g.

MY Record_Dtae field which contain a date value like "20070308' so iwill use the query like :

select