Thank you for the content. When I saw the title I was thinking that "conditional" meant that the join would or would not be executed depending on a criteria but in both examples, the joins are always executed and the displayed value is conditional depending on a criteria.
Thanks for suggesting this scenario. A dynamic SQL might achieve this requirement. DECLARE @IsExternal char(1) = 'X' DECLARE @sql VARCHAR(MAX) = 'SELECT * FROM Emp E JOIN ' + IIF(@IsExternal = 'X',' DeptExt DE ON DE.DeptId= E.DeptId','Dept D ON D.DeptId = E.DeptId') EXEC(@sql)
Hello Madam, Please make video on following scenario of material requirements. Material code, description, base_unit, order unit, daily_requirement, stock_qty, pending_po then total qty(stock_qty+pending_po) and then total qty/daily^requirement as material available for days in sql server and how many different tables I have to create please suggest. Thanks in advance for your best help. I am waiting for your favourable reply. Please help me...🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻
Thank you for your comment. MRP is a specialized system and one needs good understanding of the process to implement a solution. There are various vendors like SAP that provide the specialized software. If you search for MRP examples and solutions you should be able to get some good references to design your solution. One reference link is copied below - www.slideshare.net/LuciaGarrido1/mrp-exercises Hope it helps!
Thank you for the content. When I saw the title I was thinking that "conditional" meant that the join would or would not be executed depending on a criteria but in both examples, the joins are always executed and the displayed value is conditional depending on a criteria.
Thanks for suggesting this scenario. A dynamic SQL might achieve this requirement.
DECLARE @IsExternal char(1) = 'X'
DECLARE @sql VARCHAR(MAX) = 'SELECT * FROM Emp E JOIN ' + IIF(@IsExternal = 'X',' DeptExt DE ON DE.DeptId= E.DeptId','Dept D ON D.DeptId = E.DeptId')
EXEC(@sql)
Another useful video. I use the conditional joins at work. We get the correct data only because of it.
Thank you
I am union approach
Just wants to know which one is optimised/ recommend ?
I have a lot of respect for your work, please keep it up
Thank You!
Superb explanation 👌 👏 👍 , nice content
Thank You
Such useful videos,keep them coming please
Thank you
great job
best regards
from Brazil
Glad it was helpful.
Great..
Thank You!
hi can get classes from your trainings.
All our video trainings are available on TH-cam. Please SUBSCRIBE for latest videos!
Hello Madam,
Please make video on following scenario of material requirements.
Material code, description, base_unit, order unit, daily_requirement, stock_qty, pending_po then total qty(stock_qty+pending_po) and then total qty/daily^requirement as material available for days in sql server and how many different tables I have to create please suggest.
Thanks in advance for your best help.
I am waiting for your favourable reply. Please help me...🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻
Please reply or help me
Thank you for your comment. MRP is a specialized system and one needs good understanding of the process to implement a solution. There are various vendors like SAP that provide the specialized software.
If you search for MRP examples and solutions you should be able to get some good references to design your solution. One reference link is copied below -
www.slideshare.net/LuciaGarrido1/mrp-exercises
Hope it helps!
@@LearnatKnowstar I want to create it manually in sql server. So, Please suggest, if possible please make video tutorial on that please