Jeff, quit torturing the poor guy and just give him the link

http://www.sqlservercentral.com/Forums/Topic530630-8-2.aspx

Make your Final table a view instead, so that it selects the max(createdate) for each customer. That way, even when they weren't all updated at the same time, you see...

So....what in the world are you doing where you need to know how toxic Alopecia is?

I think what you're doing is a good idea, but everyone should still be thinking about what they're presenting, who is consuming it and what they want the audience to...

question is also, why is NULL allowed? Is that an issue that needs addressed so that the SUM is actually correct data? Simply because it handles the situation doesn't mean...

I feel like I'm missing something. An inner join is necessarily an existence check, why not:

SELECT u.UserId
  FROM UserTable u
  JOIN TableA a ON a.UserId...

Why even use a CTE? Why not just join to those tables?

impacts to me have been that I can't sit outside on the deck anymore, because the neighbor now sits on *his* deck and I have to hear his conference calls...

Bueno, la única información que tenemos es que hay una "pérdida potencial de datos", tal vez el valor de origen es demasiado largo para el destino?

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/rendering-behaviors-report-builder-and-ssrs?view=sql-server-ver15

EDI format files, 834 (Enrollment) , 820 (premiums) , 270/271 (verification files), 837 (claims remittance), etc.

"The loudest critics are always those who have the least education, knowledge, experience, and judgement to do the job themselves."

No, but that's a convenient way to dismiss people giving legitimate...

It's impossible to be "caught up", because that means you'd have to have watched all the animated series' too, cared enough to follow that but still keep track of what...

stupid question time. when you guys deal with X12 spec files, is there a reasonable argument *against* loading them into tables named for loops/segments/ref numbers?

I get that they are variable...

Dearest Philip,

You seem to be asking "How do we force people to be critical thinkers"? Folks who already are, will question if any bias exists, look at multiple sources, dig...

• This reply was modified 4 years, 6 months ago by  jonathan.crawford.