sayedkhalid99 (6/28/2015)

---

how to round the nearest value after round of decimal and return integer. thanks.

declare @data decimal(18,2)

set @data = 5.55

-- output

select '5'

set @data = 5.58

-- output

select...

Jeff Moden (6/28/2015)

---

Ok. I've decided to get to the bottom of this once and for all. I've posted the following on the MVP email site. We'll see...

Jeff Moden (6/28/2015)

---

Even with that fine hypothesis, it's not conclusive proof that the table spool is being read one row at a time for each row or one page at...

ChrisM@home (6/28/2015)

---

Also Assert, unless you've unlimited MAXRECURSION.

So what, in this example, has data organised as 8k pages?

Or to put it another way, why should spools be expected to...

ChrisM@home (6/28/2015)

---

This is about the simplest rCTE that I can think of. No 8k pages anywhere yet Statistics IO reports logical reads:

SET STATISTICS IO ON;

WITH rCTE AS (

SELECT n =...

ChrisM@home (6/28/2015)

---

This is about the simplest rCTE that I can think of. No 8k pages anywhere yet Statistics IO reports logical reads:

SET STATISTICS IO ON;

WITH rCTE AS (

SELECT n =...

Done some testing on rCTEs in the passed, couldn't correlate the logical reads to rows/recursions.

😎

Simple test code

USE Test;

GO

SET NOCOUNT ON;

/* Recursions from 1-20,30,40,50,60,70,80,90,100 */

GO

DECLARE @SAMPLE_SIZE INT...

Quick cross-tab suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @OracleEngData TABLE

( [OMNI_NUMBER] INTEGER

, [TIMESTAMP] INTEGER

, [DATA_TYPE] NVARCHAR(24)

, [DATA_TYPE2] NVARCHAR(24)

, [PARAMETER] NVARCHAR(32)

, [PARAMETER_VALUE] NVARCHAR(132));

INSERT INTO @OracleEngData

(OMNI_NUMBER,TIMESTAMP,DATA_TYPE,DATA_TYPE2,PARAMETER,[PARAMETER_VALUE])

VALUES

(506026,1413240436,'test_data','cnr',211250000,54.8)

,(506026,1413244259,'test_data','cnr',211250000,53.2)

,(506026,1413244679,'test_data','cnr',211250000,53.1)

,(506026,1413309646,'test_data','cnr',211250000,53.4)

,(506026,1413315987,'test_data','cnr',211250000,53 )

...

Ride

jonathan.crawford (6/26/2015)

---

pshaw, that's nothing compared to your...

Orbit

Water

I'll give it a try;-)

The error is coming from the Decrypt function when attempting to assign the output of DecryptByKey to the @Result...

Piling on the NOLOCK discussion, the behaviour is different between temporary tables and normal heap tables. When using #temp tables, the NOLOCK hint will not only have a shared (S)...

Did you look at the thread in my...