magical dev | SQLServerCentral

magical dev

Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

RE: average value before and after a point in time **without** using a union all

andycadley - Thursday, August 16, 2018 1:03 PM
drew.allen - Thursday, August 16, 2018 12:40 PM

August 17, 2018 at 7:43 am

#2002235
RE: average value before and after a point in time **without** using a union all

drew.allen - Thursday, August 16, 2018 11:50 AM
Assuming that you really are looking for a T-SQL version, I believe that this...

August 17, 2018 at 7:40 am

#2002233
RE: average value before and after a point in time **without** using a union all

ScottPletcher - Thursday, August 16, 2018 10:08 AM
"AVERAGE" isn't a SQL Server function, afaik. It seems easy enough to get the result...

August 17, 2018 at 7:18 am

#2002224
RE: average value before and after a point in time **without** using a union all

Thom A - Wednesday, August 15, 2018 3:05 PM
That doesn't look like T-SQL. There's no GROUP BY and AVERAGE isn't a function...

August 17, 2018 at 7:07 am

#2002220
RE: Check constraint where all records with the same effective date add up to one

ALZDBA - Thursday, April 26, 2018 6:31 AM
Ever considered a trigger ( for insert / update / delete ) which checks your...

April 26, 2018 at 7:12 am

#1988340
RE: Check constraint where all records with the same effective date add up to one

sgmunson - Thursday, April 26, 2018 6:00 AM
Have you thought this through? If you had such a CHECK constraint in place,...

April 26, 2018 at 7:07 am

#1988338

Viewing 6 posts - 1 through 6 (of 6 total)