Forum Discussion

izhilin's avatar
izhilin
Frequent Visitor
7 years ago

Get single value by date filter, similar to SQL LEFT JOIN / OUTER APPLY

Dear Colleagues,   I have 2 tables in my data model: Calendar (column "Date") Credit limits by customer (columns "Credit limit change date", "Credit limit change time", "Customer Nr", "Old credi...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi izhilin

Does my reply solve your question?

If not, Could you show the result table after applying SQL statement in SQL, so that i would know what i done wrong and modify to get the correct one?

 

Best Regards

Maggie