Viewing 15 posts - 541 through 555 (of 1,413 total)
Hold a sec, the code above is making multiple replacements of the same character. 7 replaces 1 then 5 replaces 7. The reason seems to be because the order of...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
This is one of those gray areas... or idk maybe someone can explain why this actually works. For reasons unknown, afaik when the REPLACE function is used in the righthand...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
Yes a calendar table is another workable approach. What if the minDate and/or maxDate is other than the 1st or last day of the month? Maybe something like this
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
Yes sorry. It should've been included. The code is from Jeff Moden's article here on SSC. It comes in handy in many places
CREATE FUNCTION [dbo].[fnTally]
/**********************************************************************************************************************
...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
For the counting to begin at 1 maybe you could assign the value 1 to rows where the status is null. Then UNION ALL for the additional rows with the...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
There are different date calculations depending on granularity. This seems to work
drop table if exists #foo;
go
create table #foo(
[Table] sysname,
...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
Hi Joel, maybe something like this. It's pretty self-explanatory once you run it
drop table if exists #foo;
go
create table #foo(
[datetime] datetime,
tonsperhour...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
Maybe you're looking for something like this. It assumes there's a primary key column in the OfenbuchVC1212_V10 table called 'OfenbuchId'. After update of the OfenbuchVC1212_V10 table the trigger first determines...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
[Edit] I posted some code that didn't look right so I updated. Maybe something like this
select w2.RCWHS# as DC, w2.RCITM# as [Item Number],
...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
Maybe something like this
;with
cte_ntile(ReadingDateTime, ReadingValue, [Group]) AS (
select *, ntile(2) over(order by ReadingDateTime asc) AS [Group]
from #SIDataGroup),
cte_rn(ReadingDateTime, ReadingValue, [Group],...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
It turns out the median is derived from the ordered set. My query only calculated the midpoint. If the number of rows in the [Group] (calculated as 'grp_count') is even...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
Thanks for the feedback. Nice I'm happy if the code helps. Precision-wise it's maybe not ideal. I tried it with nanoseconds and there was an overflow error. Maybe microseconds would...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
Maybe something like this. The 'median_dt' column calculation adds half the difference in seconds between the min and max ReadingDateTime values within the [Group] group to the min ReadingDateTime
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
Viewing 15 posts - 541 through 555 (of 1,413 total)