Hello,

You need to check two things:

1. Wheter SSAS server is installed or not. for this please open SSMS --> Click on Conect in top left of Object explorer and select...

Hello,

As per my understanding of your question, you are looking for joining given two tables.

You need to use join features of SQL Server for joining these tables

i.e. Inner Join, Left...

Hello,

Your problem is example of many to many relationship designing.

For maintaining it you need to create one more table which will contain only OrderID and TransactionID and it will work...