Not enough information. Can you post the stored procedure code?

CONVERT uses style codes to control output and input formatting:

declare @ToDate datetime, @FromDate datetime

SELECT -- UK format

@FromDate = CONVERT(DATETIME,'21/06/2014',103),

@ToDate = CONVERT(DATETIME,'21/07/2014',103)

select @FromDate,...

wBob (7/21/2014)

---

I would approach that using TOP and CROSS APPLY, eg:

SELECT c2.*

FROM ( SELECT DISTINCT CoverageCode FROM dbo.[Contract] ) x

CROSS APPLY ( SELECT TOP 5 * FROM dbo.[Contract] c WHERE...

I agree with Luis, it's very difficult to work with filters as complex as this without sample data. However, here's a...

Here's the final solution:

;WITH

SeqID1 AS (

SELECT x.ID, x.RowID, x.Value, MAXReadingdate = x.Readingdate

FROM (

SELECT *, rn = ROW_NUMBER() OVER(PARTITION BY ID ORDER BY Readingdate DESC)

FROM #tempreadings t

) x

WHERE...

Yes I know. One step at a...

ramrajan (7/21/2014)

---

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

"The most recent reading which is more than 24 hours before the max reading date"?

Like this:

;WITH OrderedData AS (

SELECT *, rn = ROW_NUMBER() OVER(PARTITION BY ID ORDER BY Readingdate DESC)...

To help resolve this, I've rejigged the sample data to add a row...

ramrajan (7/21/2014)

---

.

.

.

-- Result 2

-- In The same Query I want the ReadingDate For Each ID And the ReadingDate IS 24 Less Than the max Reading Date of Each ID ....

See also this thread.

Yes, which makes tempdb useful as...

Not really. NTILE(n) splits a set into n partitions.

Runnymede

Happy Friday 🙂