thava (9/8/2014)

---

Hi jeff;

Thanks, for the info, but switching my career is not possible, I think i know little bit of the clustered index and...

How does such an expression look like?

Interesting question, thanks.

Since you have the comma as a delimiter and the address data contains a comma as well, you are bound for trouble.

SSIS will think a new column has started.

You either...

There is also a commit at the end of a buffer, if I'm not mistaken.

Batch Sizes, Fast...

What is the batch size and what is the buffer size of the data flow?

Ugh. 🙂

This is bad design, because a table doesn't have an order. You should be able to random mix the rows in the table and still achieve the same result.

If...

patelmohamad (9/5/2014)

---

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...

If a single driver has multiple logged in dates and multiple logged out dates, you need to join on something else as well.

How do you know which logged in date...

Does this work?

SELECT

DDLH_IN.DRIVER_ID

,DDLH_IN.IS_LOGGED_IN

,DDLH_OUT.IS_LOGGED_IN

,DRIVER_NAME

,LOGGED_IN_DATETIME= DDLH_IN.LOGGED_DATETIME

,LOGGED_OUT_DATETIME= DDLH_OUT.LOGGED_DATETIME

FROM dbo.D_DRIVER_LOGGED_HISTORY DDLH_IN

JOIN dbo.D_DRIVER_LOGGED_HISTORY DDLH_OUT ON DDLH_IN.DRIVER_ID = DDLH_OUT.DRIVER_ID

WHERE DDLH_IN.DRIVER_ID = 4 AND DDLH_IN.IS_LOGGED_IN = 1 AND DDLH_OUT.IS_LOGGED_IN = 0;

patelmohamad (9/5/2014)

---

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...

+1

The system variables...

Ah I see. Use an INNER JOIN on DriverID instead of the union all.

What exactly is your desired output?

Easy one, thanks.