As i mentioned in my post we also need to join #temp

--- We Need to join The above Results Set 3 With #tempdeliveries Based ON ID and We need to...

You will need to elaborate on this definition "the ReadingDate IS 24 Less ".

For ID=1, the row chosen for Result 2 has a readingdate which is 1 day before...

Please read it as "ReadingDate IS 24 Hours Less Than the max Reading Date "

Appreciate your response

What ever thats posted in that thread is not correct, So please help me with this scenario.

If we have multiple readings for a ID we are picking the latest record date as current reading and then we need to show the prevoius reading data which is...

And her is how i want to get the output. Based on the sample data mentioned in my POst

ID ReadingDate SeqID

1 2014-07-18 07:48:30.200 1

1 2014-07-17 07:48:30.200 2

2 2014-07-17 07:48:30.200 1

2...

I have already information i need for each ID we have to show the records based on the reading

First reading is always the current reading and the second is the...

Please someone help me

It is giving all the records but i want the output as

ID ReadingDate SeqID

1 2014-07-18 07:48:30.200 1

1 2014-07-17 07:48:30.200 ...

Yes thats correct

I am not sure really how PIVOT work can anyone help me to get the desired result set

i am new to this so need help

the objective is to replace the NOT in with some joins

cant it can be rewritten without looking at the data and resultset

still waiting reply for the below question

Question 2 : Why we need two join below can we rewrite with single join is that possible.

LEFT OUTER JOIN dbo.subsystem subsys WITH (NOLOCK)ON...