jtrask (7/13/2016)

---

Of course. It all seems obvious once someone spells it out for me.

I like the idea of doing it on the fly. There's no point in having...

SQLRNNR (7/13/2016)

---

ChrisM@Work (6/29/2016)

---

tindog (6/29/2016)

---

ChrisM@Work (6/29/2016)

---

tindog (6/29/2016)

---

ChrisM@Work (6/29/2016)

---

The Welsh...

Is the UPDATE always followed by a SELECT of the new values?

UPDATE [cpwarn] set [autonum] = [autonum]+@1

WHERE [tablecode]=@2

SELECT autonum, tablecode FROM cpwarn WITH (NOLOCK)

WHERE tablecode='prog\DONUMREG\''001''\''2016 '''...

Thanks - but these are estimated plans. If possible can you post up actual plans? An actual plan of the SELECT is straightforward, use the query from...

Post the whole query.

Capture actual execution plans for each operation against the table, and post them as .sqlplan file attachments.

This should be close:

SELECT --DISTINCT

x.[Facilitator],

[Funded Apps] = SUM(CASE WHEN y.[Status] = 'Funded'...

Sure. There's a ton of redundant joins and stuff in it but something...

rmurray 17656 (7/13/2016)

---

I have a Calculation in a query that is producing two different results. when used in a query statement the result is 160.442873, However when I use...

J Livingston SQL (7/11/2016)

---

I'll tell you what I'll do Chris......as its only a...

Assuming you're in a playpen, CHECKPOINT then dbcc dropcleanbuffers. You might free up a few kb 😀

Eliminated that pesky spill:

== JLS1 ==========================================================================

SQL Server parse and compile time:

CPU time = 0 ms, elapsed time = 8 ms.

Table 'testtable'. Scan count 34, logical reads...

J Livingston SQL (7/11/2016)

---

== CJM2 ==========================================================================

Table 'testtable'. Scan count 9, logical reads 24440, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads...

Try with this index G, I'm getting about 10% improvement.

-- CREATE UNIQUE NONCLUSTERED INDEX [idx_Code_Dates] ON [dbo].[testtable] ([Code] ASC,[enddate]...

J Livingston SQL (7/11/2016)

---

I dont get the same results Chris....any thoughts ??

PRINT '==...