Hello! Greetings!

Facing this weird issue. The numbers are exactly same but are getting filtered into != operator.

?

any other details?

Copy paste not working here. Wait saving it to file then uploading :)

So I'm filtering where credit not equals debit. It's filtering these 3 lines where it's exactly the same.

maybe there are differences on some decimals...hard to say just looking at an image

what's the datatype of credit and debit?

I see, just checked, it's float. It's uploaded from excel. But that difference should be visible in the sql right?

If I do cr=dr, there are 20 rows.

@MohammadYusuf float is an approximate data type, so you can expect differences. Maybe try converting to numeric or decimal before aggregating them

Alright

SUM(CONVERT(decimal(16,2),credit))

Thank you. Float was issue as you pointed out. did this cast(sum(credit) as money)

ah well, good that it worked

Morning

Morning

Morning

Good morning

What hath I wrought? dbfiddle.uk/…

I swear that is the most unnecessary problem I have ever solved.

@bbaird - lovely piece of work! My only regret is that I wasn't first to upvote! I'll look at it tomorrow! Comhghairdeas!

@bbaird super it looks to me

here is a kind of generalization, allowing non-unique elements ;)

dbfiddle.uk/…

I just talked to the wife of a work colleague to give her advice on the job description/responsibilities for a data warehouse architect for their small growing software company that has acquired 5 companies in last year. Are there any "So you want to build a data warehouse?" resources already out there - realistic C-level stuff? I talked for about an hour about all the things that would go into it from the modeling to ETL to reporting and I felt like I could still cover another couple hours.

"Data warehouse" is so 2010s... It's "data lakehouse" now.

That was one of my points to her is that most people are doing this data lake thing where they just throw it all in and hope the queries can handle it.

To me, it seems like instead of committing to a long term (but hopefully agile and flexible) process and principles, they are playing by ear and just hoping it works out.

@CadeRoux What industry?

@Vérace I knew you would take a stab at it and lose a weekend on edge cases so I just went ahead and solved it ;)

@bbaird "software" is all I know, it sounds like a couple of the companies are on Salesforce, others on different things and sounds like it's mostly financial reporting and sales pipeline. She is supposed to send me the LinkedIn posting to review as well as share to people who might be interested. She said it's a young company that's small but growing.

I gathered from the discussion that it's more of a FTE position than a contractor/project, and that's what I would hope, because I think it's something that requires long term commitment to integrating into the company's operations. But it was mostly me explaining the overall areas normally involved and piecing in the little bits she was giving me.

The issues she has (from the CFO's office, I gathered) are getting the various things all combined into her PowerBI so she can report. It sounds like they may have made a little headway on a couple Salesforce data sources, but that the BI person who combined those two doesn't have experience building a data warehouse from scratch.

It did sounds like a couple of the common pain points of a DW project might not be so bad - getting buy in - the company is small and the growth pains have everyone motivated and it's driven by the CFO (low politics, silos based on companies, not power structures), and knowing the expected reporting needs/users (not building a DW with no actual use cases). However, the issues of disparate sources, transport issues from the divisions, etc would still remain.

@PaulWhite you removed this part (code similar to from the code, with your edit here: dba.stackexchange.com/posts/301175/revisions