Read here : Common Table Expressions

That query willl not handle that scenario. We can work it out anyways. Do u have any "Shift identifier"??

oooops.. i dint see your last select statement..

Hmmmm.. i cant think of any other way than individually checking each columns!

Whats your desired output? which rows u want to see?

unclear on what you trying to do.. Can you be more elaborate?

And what is your desired output of ur samples?

:hehe: :w00t:

Sivaganesh,

I am seeing a lot of posts from you ont he same request and the people who respond ask you to provide sample data, sample table ALWAYS. But you fail...

Eugene Elutin (3/15/2012)

---

Yep! It works!

Now is only performance left.

Yours give:

Table 'Worktable'. Scan count 6, logical reads 70, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical...

ColdCoffee (3/15/2012)

---

Eugene Elutin (3/15/2012)

---

ColdCoffee (3/15/2012)

---

Eugene Elutin (3/15/2012)

---

I'm not sure what OP wants for "UNION ALL SELECT 400 ,10 ,10 " data sample, I've read his requirements as: he only want...

Eugene Elutin (3/15/2012)

---

ColdCoffee (3/15/2012)

---

Eugene Elutin (3/15/2012)

---

I'm not sure what OP wants for "UNION ALL SELECT 400 ,10 ,10 " data sample, I've read his requirements as: he only want to...

Eugene Elutin (3/15/2012)

---

I'm not sure what OP wants for "UNION ALL SELECT 400 ,10 ,10 " data sample, I've read his requirements as: he only want to see the record...

How about this?

IF OBJECT_ID('TempDB..#Temp') IS NOT NULL

DROP TABLE #Temp;

CREATE TABLE #Temp

(

iD INT --IDENTITY(1,1)

,AMT_DIFF INT...

You're welcome.. One question - did u use the first one or the second?

Another solution

; WITH CTE AS

(

SELECT EmployeeID

,EmployeeLoginDateTime = DATEADD(DD,DATEDIFF(DD,0,OutTab.EmployeeLoginDateTime),0)

,JobFunction = CASE WHEN JobFunction = 'Logout' THEN 1

...

Then this?

DECLARE @TableA TABLE

(

EmployeeIDINT

,EmployeeLoginDateTimeDATETIME

,JobFunction VARCHAR(25)

)

INSERT @TableA

SELECT 123,'2012-02-01 01:00:24','Coding'

UNION...