Good job with the table DDL and sample data.  You didn't show us your query that didn't work, though.  I suspect that what you need to do is number the...

Then you'll need to do a bit of investigation.  Run xp_logininfo 'DomainName\GroupName', 'members' for each to group to find out which group(s) the user is a member of. ...

Check the properties of the login.  What is its default database.  Now, does the login have access to that database?

John

You can use the same disks.  If the databases are heavily used or performance is crucial, you might want to keep them separate, though.

John

Post the code, please.

I imagine it's going wrong because you have DECLARE statements in your query text.  You should only include the actual query.

John

I just typed "running balance query" into my favourite search engine - it's amazing what you can find with a bit of research.

Now, are you really on SQL...

(1) Make sure you set max server memory such that there is sufficient memory left for the operating system and any other applications or SQL Server components on the server

(1) Back up the transaction log
(2) Restore the Full from 05/11 with no recovery
(3) Restore the differential from 11/11 with no recovery
(4) Restore all transaction log backups...

Use sp_whoisactive to see what statement is currently running.

John

Or this - it has fewer moving parts and seems to run a little bit faster than Eirikur's.

SELECT
    DATEADD(second,-DATEPART(second,create_date)%15,DATEADD(ms,-DATEPART(ms,create_date),create_date))
FROM sys.all_objects

John