I'm not actually the one to ask about such things because the folks I work with found a way to do what they call "San Replication" (the network guys at...

To answer the question "can a Cust_num have more that one Co_num or not?"  yes,  in our case customers can have multiple Co_num , so need to figure a...

Shifting gears a bit, it sounds to me like the SSNs in these 45 tables are in clear text.  If that's true, please inform management that's freakin' insanely stupid and...

Hi Williams,

Thanks for making your time for reply!!

why do you need a copy of the data in the secondary database?

My reply:-Actually my task was to update  the data across...

Bloody amazing machines nowadays.  The laptop I'm currently using has the following specs...

Processor Intel(R) Core(TM) i7-8750H CPU @ 2.20GHz, 2208 Mhz, 6 Core(s), 12 Logical Processor(s) (w/automatic Overclock up to...

Post deleted.  It's no longer needed.

Great article.  Just don't settle on a single mentor because no one person knows it all.  Have many and include yourself in that.  It's amazing what you can string together...

In both solutions - I would move the calculation to a CROSS APPLY:

SELECT  Cust_num
        ,Co_num
   ...

It's not just me... we did it together.  You reminded me not only of the IIF function but also...

>> A better idea is to use the correct datatype. ,<<

I agree with that statement. In fact read his posted this in a wonderful single principal, for which a...

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

Post deleted...

Since you attempt at code and what you posted as your desired final output have several difference between the two, I split the difference and can derived the following code. ...

A better idea is to use the correct datatype.  If the column is supposed to only handle digits, then changing the datatype of the column to be an INTEGER would...

I need help with a query. If I have a list of people each with a service date and I want to sum their spend one year and two...