I'm not selling anything.  I'll take it elsewhere tho.  Thanks.

Removed

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...

.

• This reply was modified 6 years, 4 months ago by Thom A.
• This reply was modified 6 years, 4 months ago by Steve Collins.
• This reply was modified 6 years, 4 months ago by Steve Collins.
• This reply was modified 6 years, 4 months ago by Steve Collins.

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...

For a C# data access library that targeted SQL Server maybe 4 or 6 month release could make sense  🙂

Stripe Change Log

That's a link to the monthly breaking changes to the Stripe API.  Words cannot express... it's too much too often... it forces you to choose between...

Stripe Change Log

That's a link to the monthly breaking changes to the Stripe API.  Words cannot express... it's too much too often... it forces you to choose between constantly...

Needs sample data or it's unlikely to work as intended the first time.

alter procedure [dbo].[_BARank]
as
set nocount on;
set xact_abort on;

begin transaction
begin try
    Declare
      @executor        ...

• This reply was modified 6 years, 4 months ago by Steve Collins.

delete tc
from
  #TradeCode tc
where not exists
  (select 1 from #MappingCodeValue mcv 
   where mcv.ChildCodeType=tc.CodeType 
        ...

This puts it all together in 2 styles.

/* Jeff's style */
 SELECT  Cust_num, Co_num
        ,Total    ...

Very very nice pre-aggregation!  Now thaaaat's the way to do it.

This is great article!  I'm going to give it a try.

select
  Cust_num, Co_num,
  sum(amount) Total,
  sum(iif(floor(datediff(d,due_date,getdate())/30)=0,amount,0)) [1-30 Days],
  sum(iif(floor(datediff(d,due_date,getdate())/30)=1,amount,0)) [31-60 Days],
  sum(iif(floor(datediff(d,due_date,getdate())/30)=2,amount,0)) [61-90 Days],
  sum(iif(floor(datediff(d,due_date,getdate())/30)>2,amount,0)) [>90 Days]
from EES_App.dbo.artran_all
group by Cust_num, Co_num;