Even though I can create a synonym for "BizTechArchive.dbo", I cannot use it.

So I need to create individual synonyms for each table like BizTechArchive.dbo.Table1

Is there any alternative for this?

Dear friend, thanks for the insight. You made my day.

I have created Synonyms & it is working.

Now I have a doubt. I have created a Synonym for 'BizTechArchive. dbo' in...

Thanks for the insight. The source query was returning duplicate records. I will use DISTINCT clause & see the output.

Thanks for the reply;

Kindly answer my last query: My customer is asking how to know that SSIS is installed in the SQL Server set up there at his location. I...

How to set sysadmin rights for my Windows authentication ?? Kindly guide me on this.

I am the Sysadmin in the instance & I am using sa login using SQL Authentication.

This login also allows me to create a folder under the SSIS catalog, a feature...

Kindly write as a query so that I can understand correctly. The result I need is as below:

Kiev SystemAdmin 11

Kiev WindowsAdmin 5

Kiev Supervisor 0

Kiev ContractWorker 0

Moscow SystemAdmin 7

Moscow WindowsAdmin 0

Moscow...

For only EmployeeCategories 1 & 2, there are records in the Employee Master table now.

Now the count is not showing for the 3 & 4, as there are no records...

EmployeeMaster has following columns EmployeedID, EmployeeName, EmpCategoryID, EmpLocationID

EmployeeCategory has following columns EmpCategoryID, EmpCategoryName, EmpCategoryDescription

EmployeeLocation has following columns EmpLocationID, EmpLocationName

select C.EmpLocationName, B.EmpCategoryName, count(A.EmpCategoryID) as CategoryCount

FROM EmployeeMaster A

INNER JOIN EmployeeCategory B ON...

GOT IT

SELECT t2.Date,
   t2.Credit,
   t2.Debit,
   SUM(COALESCE(t1.credit, 0) - COALESCE(t1.debit, 0)) AS Balance
FROM TRANSTABLE t1
INNER JOIN TRANSTABLE...

Please post the DDL for the tables involved, sample data and expected output. It will help the experts here to help you out.

Is my approach of implementing page break for showing the second tablix on new page ie.second page of the report is correct?
Is there any alternate way ?