It's good practice to use a staging table...

Grouping by customer; get min date, max date, row count (transaction count).

Dividing the difference between the two dates by the row count will give you the average interval between sales.

Dave Ballantyne (6/28/2010)

---

Quick ...

SELECT AcctNo, RowID = IDENTITY(INT,1,1)

INTO #Temp

FROM (

SELECT 123 AS AcctNo UNION ALL

SELECT 123 UNION ALL

SELECT 124 UNION ALL

SELECT 125 UNION ALL

SELECT 126 UNION ALL

SELECT 126 ...

Fused

Beratung (6/25/2010)

---

I ran that exact script to test for numerics and a few others and they all came back as numerics. In regards to T.ORTRXAMT, even if I don't...

/****** Drop Table If It Exists ******/

--if object_id('#RiverRd_Precip_15') is not null

drop table #RiverRd_Precip_15

/****** Create Table ******/

CREATE TABLE #RiverRd_Precip_15 (

[T_TIME] datetime,

[T_DATA] float

)

/****** Insert Data Into Table ******/

INSERT INTO...

Is it always the last hour, the last 3 hours, the last 6 hours which you want to retrieve?

As a single row?

For each site?

Ryan

The column 'Arrears' is generated by a CASE in the inner query.

CASE WHEN TEN.[curr-balance] >0

THEN TEN.[curr-balance]

ELSE 0 END AS 'Arrears'

There are two ways...

What exactly is meant to be output to column 3? What datatype is T.ORTRXAMT?

DECLARE @ORTRXAMT DECIMAL(10,2)

SET @ORTRXAMT = 999.99

SELECT TRXAMOUNT =

CAST(

RIGHT(

LEFT('0000000000' + CAST(@ORTRXAMT *100 as varchar(50)), LEN('0000000000' + CAST(@ORTRXAMT...

jamón ibérico

She was cute. Oh boy I worry about you sometimes 😉

Funny - I remember their stuff from the mid-70's - soft, folksy, musical. So did the kid who recognised her at the Floyd concert, about 1/3...

Barley malt & hops

Why not convert it into a view?

You could also resolve out all the UDF's to improve performance - since you'd be left with a single code chunk.

You could also remove...