Viewing 15 posts - 1,051 through 1,065 (of 1,413 total)
It's conditional counting. Sql is terrible at this.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 22, 2020 at 7:54 pm
Yeah I noticed that too. My next attempt would be to use CROSS APPLY containing IIF function(s) (as many as necessary) and pass in a ton of variables.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 21, 2020 at 5:41 pm
This appears to work but it's not simple. It defines the anchor records as having the minimum ArrivedDate where the doc_row_num<=2 and doc_row_num<= doc_count. Then it inserts additional rows calculating...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 21, 2020 at 2:12 am
/* without STRING_AGG */
;with
ErrData1(tran_no, ref_no, ref_tamt) as (
select t1.tran_no, t1.ref_no, t1.ref_tamt
from @tran_dtl1 t1
where t1.ref_tamt >...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 19, 2020 at 4:45 pm
Maybe STRING_AGG instead of COALESCE?
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 17, 2020 at 7:25 pm
Well I have no sample data so that was a stab in the dark. Makes sense though! Maybe more iif's
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 17, 2020 at 4:22 pm
select
concat(iif((columnproperty(object_id('dbo.TempparsedHeaderCSVData'),'Footnote','ColumnId') IS NOT NULL) and
(columnproperty(object_id('dbo.TempparsedHeaderCSVData'),'Footnote2','ColumnId') IS NULL),
...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 17, 2020 at 4:07 pm
drop table if exists #anchorj;
create table #anchorj(
UserId varchar(10),
SalesDate date,
SalesAmount ...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 16, 2020 at 5:06 pm
Sorry, I was happy because my project worked. I'm not trying to sell anything. You won't miss this post so it's gone.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 16, 2020 at 1:57 pm
I'm not selling anything. I'll take it elsewhere tho. Thanks.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 16, 2020 at 1:51 pm
Removed
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 16, 2020 at 1:00 pm
The goal is to release completed work quicker. Every feature you've completed is inventory. It's work in progress while you wait for QA, packaging, scheduling, and deployment. The absolutely...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 16, 2020 at 12:07 pm
.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 15, 2020 at 10:41 pm
DevOps is a culture, but the culture isn't to write sloppy code faster. It's to release the changes, backwards compatible, quicker. From code commit to release is quick, not...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 15, 2020 at 9:03 pm
For a C# data access library that targeted SQL Server maybe 4 or 6 month release could make sense 🙂
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
April 15, 2020 at 2:26 pm
Viewing 15 posts - 1,051 through 1,065 (of 1,413 total)