Yes. I 'm using SQL server 2008. I'm just altering the existing code, so i am using the existing openxml and thanks for helping. 🙂

When user updates something CREATED_DT in MS_USER table gets updated & it is logged into MS_USER_A table (as far as my knowledge is concerned).

good to see you again...Eugene Elutin ...

ok. Thanks for helping me...:-)

can you make one small change in this.

389ssss2009-12-04 10:40:22.0001

389ssss2009-10-15 18:49:30.0000

389ssss2009-11-13 16:34:35.0001

like this :

389ssss2009-12-04 10:40:22.0001

NULL2009-10-15 18:49:30.0000 [MS_USER_A table]

NULL2009-11-13 16:34:35.0001 [MS_USER_A table]

yes by date.

180505kenn2009-11-16 17:58:16.0001

191505kenn2009-10-27 10:58:23.0000

201505kenn2009-11-11 12:12:11.0001

211505kenn2009-11-16 17:10:17.0001

221505kenn2009-11-16 17:10:29.3271

231505kenn2009-11-16 17:58:03.0001

240586gare2009-11-11 12:07:58.0001

Here, user has become Active again on 2009-11-11 12:12:11.000 so skip remaining]

I think u you got the idea with the last column [keep] and where ever Yes is not there the row(s) should not be displayed.

Can we hide the RowID &...

Have a look at the snap shots, you may get idea what I'm trying to explain...

I this snap shot I've taken one particular USER_NUM to show.

ok. I'll be posting another problem as i'm not able to start with this query...

Thanks for your help:-)

Yes you are right.

I didn't went through your previous post correctly.

Now got it.

As I my boss needs output the way I posted previously for report. so I took cursor to insert into another table. One row from first query and n...

Thanks for your help.

I created another temporary table and dumped the result into it using cursor.

Thank you very much. I appreciate taking you time off to help me.

As this is my first post its quite cluttered...next time I'll post as per posting rules.

can we...

I shorted table name just to post it

NEED OUTPUT LIKE THIS:

neena 177 545 Hrs 5 Mins.

<NULL> 11/30/2009 18:54 11/30/2009 21:11 127.0.0.1 ...

CREATE TABLE USER_SESSION(

USER_NUM int NOT NULL,

LOGIN_DT datetime NOT NULL,

LOGOUT_DT datetime NULL,

USER_LOCATION varchar(4000) NULL,

...