Thank you so much to all the gurus who helped me to collect the task.

Please review to the screenshot of the completed task and give your valuable comment.

Hello All,
Finally able to generate expected output result with below script. Hope this script will help as a reference to beginners like me.

DECLARE @startDate DATETIME,

Hello Experts,

Any feedback for my request. Appreciate your valuable feedback.

Best Regards,

Thank you very much for your valuable suggestions.
So you mean say in any scenario if the relationship between the tables is 1:1 then we can put all attributes in...

i am unable to understand your suggestion clearly.

Please show me where to do amendments in the query.

Thank you.

Thank you very much for your valuable support.

I am getting parse command text error...unable to identify syntax error (Incorrect syntax near the keyword 'IF').

Please review the full command text below...

Hi,

thank you very much for your valuable support and suggestions.

small money data type will cover my requirement.

Hi,

Thank you very much for your valuable support.

Can you please provide an example.

Thank you.

Hi,

Thank you very much for your concern.

For example i have a stock_items table and sales orders table and i did a relationship between stock_items:stock_id (pk) -> sales_orders:stock_id (fk) but when...