Hi Experts,

Thanks for your valuable time and suggestion given by you, this is Copy of Main Database on Daily Bases data is inserted and unwanted data is deleted,

We have splited...

Hi Dave,

I am also stucked in similar problem and the query which you have suggested I have executed and I have got the result

Transcount 1

but if I am...

Thanks all of you,

The solution is given by all the expert is better than mine...

Thanks for the co-operation.

Hi Koen Verbeeck

Data file is attached with the Post

have a look

Thanks

Yeah we have forced the driver to log out from the System/Device which we have provided,

Just a have look for below query, will it be ok if I implement it.

IF...

:-D:-D off course it is in next row.

on the base of is_logged_in true/false, the value is inserted into the table

yeah that's the Major issue in it, other wise I have to take loop and then populate the data which I don't want to do.

instead of taking loop I want...

Hi Koen Verbeeck

No Luck from the query, the data is multiplied by the table one rows to table two rows i.e 53*28 = 1484.

Thanks

here is the query

SELECT

DDLH_IN.DRIVER_ID

,DDLH_IN.IS_LOGGED_IN

,DDLH_OUT.IS_LOGGED_IN

,DRIVER_NAME

,DDLH_IN.LOGGED_DATETIME AS LOGGED_IN_DATETIME

,DDLH_OUT.LOGGED_DATETIME AS LOGGED_OUT_DATETIME

FROM

D_DRIVER_LOGGED_HISTORY AS DDLH_IN

INNER JOIN D_DRIVER_LOGGED_HISTORY AS DDLH_OUT

ON DDLH_IN.DRIVER_ID = DDLH_OUT.DRIVER_ID

WHERE

DDLH_IN.DRIVER_ID = 4

Hi Koen Verbeeck,

I have tried it but no luck, I have 81 Records for that particular driver but it is multiplying the records and the output value is 6561 records,

it...

I want the output as below

DRIVER_IDDRIVER_NAMELOGGED_IN_DATETIMELOGGED_OUT_DATETIME

4SAM2014-08-30 12:31:532014-07-05 09:47:41

4SAM2014-08-28 11:37:232014-07-05 09:47:41

Kingston Dhasian (10/17/2012)

---

No. You cannot use a Stored Procedure like a UDF.

You can insert the results from a Stored Procedure into a temporary table and work on the temporary table...

Thanks Chris for Passing a Logic

the way I needed,

thanks once again

Thanks Lowell for instant reply,

This is my predication, not the actual data

, actual data is differ from my Example

in my data it gives me lot of no's 1,2,3.......n or sometime...

Koen Verbeeck (4/13/2012)

---

What do you mean with column index?

You can either specify the columns names, or just add two clauses: ALTER TABLE #TempTest DROP COLUMN ID and ALTER TABLE #TempTest...