That is a totally different schema and set of data to what you have provided all ready.

Please post the correct DDL and the correct data along with your expected outcomes...

There is no BIN folder in SSRS as your not creating an application.

All you need to do once you have configured the target server URL and developed the report is...

You should see records like this

Recovery of database 'DBName' (DBID) is 0% complete (approximately 124308 seconds remain). Phase 1 of 3. This is an informational

message only. No user action...

;WITH CTE AS

(

SELECT DISTINCT branch, groupid FROM companies where groupid <> 0

)

SELECT

branch,

sum(num)

FROM

(

SELECT branch, count(groupid) as num FROM companies where groupid = 0 group by branch

union all

SELECT branch, count(groupid) as...

Thats right, you have two records for branch 2 in the sample data

But checking your expected results you only want 1, what is the logic to only get 1 and...

SELECT branch, count(groupid) as num from companies group by branch

I have attached the quick reference guides to licensing for 2008R2 and 2012, you might still be able to purchase 2k8 licenses but if not you will need to follow...

Thanks to Lowell for the image

Keep your eye on the SQL error log, it should post the current step and estimated time left on the recovery process.

If you could read the second link in my signature on posting code it will help us out in future as we will have readily consumable data to which anyone...

Sample data in consumable format

DECLARE @Table1 TABLE (RPTTypeCode CHAR(2), Firstname VARCHAR(50), LastName VARCHAR(50), BarrowerID INT, LoanTransID INT)

INSERT INTO @Table1 VALUES ('B1','Anu','k',1,1),('C1','Swetha','SS',2,1)

DECLARE @Table2 TABLE (LoanAppID INT, LoanTransID INT, LoanNumber VARCHAR(10))

INSERT INTO...

Technically no, but as its Visual Studio, it might need a reboot to register some components in the GAC.

Side note - Think I have just found my new avatar

Please follow the second link in my signature on posting code & data, but we will need DDL, sample data, logic and expected outcome.

With that information we will be able...

% outside of a like clause is the MODULO operator and returns the remainder of the division of the calculation

Modulo - TSQL