Viewing 15 posts - 571 through 585 (of 1,295 total)
select c1.*
from #categories1 c1
where not exists(select 1
from #categories2 c2
...
March 28, 2021 at 8:10 pm
These 2 queries produce the output you're looking for. It should be said this is not a properly normalized data model. There seemingly are "non-modelled" relationship(s) in the data which...
March 28, 2021 at 3:09 pm
Nicely done The Dixie Flatline 🙂
March 25, 2021 at 7:54 pm
What about checking @@rowcount? This way 0 would only show up if there are no rows
SELECTCount(InvNo) AS RecordCount, BatchID
FROMBatchOrders
GROUP BY BatchID;
if @@ROWCOUNT=0
SELECT 0,...
March 25, 2021 at 7:04 pm
COUNT doesn't return 0 because you've also requested BatchID in the SELECT list. The FROM clause is evaluated first and there are no rows. On its own COUNT will always...
March 25, 2021 at 5:10 pm
Ok, Category appears to not be a reserved word and appears in white. Period and Value are both blue. So it's brackets, no brackets, and brackets instead of brackets, brackets,...
March 22, 2021 at 2:53 pm
To subtract the values the rows would need to be joined in some way. Since maybe some Category(ies) is/are not always present for each Period you could try OUTER APPLY...
March 22, 2021 at 12:24 pm
Like what Mr Brian Gale described you could try a combination of LEAD and LAG functions
with lead_lag_cte as (
select *,
...
March 19, 2021 at 11:51 pm
Interesting news. Thank you. Please reach out if there's anything I could do that might help. Regarding the forum there was never a UI built so it's currently DDL, SQL...
March 19, 2021 at 8:15 pm
That's really awesome Steve. I know a lot of people are going to be happy you've picked up the ball with this and in this way too. That's awesome. It's...
March 19, 2021 at 6:33 pm
It was very quick, and I knew about it yesterday, but didn't really do much other than give a vote to try. Still amazed it happened.
Comments, suggestions,...
March 19, 2021 at 3:03 pm
What needs to be dynamic?
March 19, 2021 at 11:38 am
Maybe something like this
with part_cte as (
select PartId,
sum(case when CodeType=1885 then 1...
March 18, 2021 at 9:50 pm
Yes it could be put in the same function
March 18, 2021 at 11:16 am
Wow, that is so much faster. Thank you Steve. Now let me take a look to understand the code, is it the fnTally make it so much faster?
It's true...
March 17, 2021 at 6:31 pm
Viewing 15 posts - 571 through 585 (of 1,295 total)