I am game for anything...will a union qery prevent the multiplication or compounding issue I am having?
The query I have worked well until account types began to change and became more complicated. I then needed more queries to get the right data to show up in the final query which really...
qry2
SELECT Runningtotal.CDate, Sum(((Runningtotal!RunningSum*qryChangepercent2!GainPercent)-[BrokerbyAccount])) AS Gainbyaccount, Runningtotal!RunningSum*qryChangepercent2!IntPercent AS IntbyAccount, Runningtotal!RunningSum*qryChangepercent2!DivPercent AS DivbyAccount...
Sorry that was qry3. This is qry1.
SELECT Runningtotal.CDate, Sum(((Runningtotal!RunningSum*qryChangepercent2!GainPercent)-[BrokerbyAccount])) AS Gainbyaccount, Runningtotal!RunningSum*qryChangepercent2!IntPercent AS IntbyAccount, Runningtotal!RunningSum*qryChangepercent2!DivPercent AS...
qry1
SELECT Runningtotal.CDate, Sum(((Runningtotal!RunningSum*qryChangepercent2!GainPercent)-[BrokerbyAccount])) AS Gainbyaccount, Runningtotal!RunningSum*qryChangepercent2!IntPercent AS IntbyAccount, Runningtotal!RunningSum*qryChangepercent2!DivPercent AS DivbyAccount...
I'm sorry.
That is the initial data.
The first query would show the data in the same format but only 40% of the totals for each column, plus a grand total for that day for the groupid1 only.
So the second line would dissappear and the toals would be at 40%
Date | blackbeans | favabeans |...
I used left joins on date. By the way, this is for a financial database and has been simplified and modified to preserve privacy.
Data look like this:
Date | blackbeans | favabeans | navybeans | groupid
010104 25 10 34 1
010104 10...
I have a query that sums 3 other similar queries that sum slightly different data.
qry1 sums 40% of totalbeans of group 1
qry2 sums 60% of totalbeans of group 2
qry3 sums 100% of totalbeans of group3, group4 and group5
All are ordered by date and each query uses the same data but uses a...
I have been looking into this all morning and have this lead. The duplicate DC (server 2) which is the server that the second DFS root target is located on and which is cause the error above is unable to access the doamin security policy or the domain security settings. The second server does...
I get this error while creating a second DFS root target:
"Unable to update the password. The value provided as the current password is incorrect."
The second target is on another server on the network. I am hoping to set up replication, but this error is stopping that cold.
Any help on this...
Here is the answer to my own question from Microsoft:
• Simplified access to files and folders. DFS provides an intuitive way for users to access multiple file servers throughout your organization. File and folder replicas can even be made available across multiple sites to provide inexpensive...
Here's the answer to my own question from Microsoft:
• Simplified access to files and folders. DFS provides an intuitive way for users to access multiple file servers throughout your organization. File and folder replicas can even be made available across multiple sites to provide inexpensive...
Thanks Faithless.
Will DFS provide file security (ie. redundancy) or merely access to files on either server without the file being located on both servers? I would like to have to dynamic or sync'd copies of files/folders - one on each server.
David
Try these links.
For clients: http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/windowsserver2003/proddocs/entserver/sag_WINS_add_KBArticles.asp
For Servers...
Does dfs provide increased file security as far as making files available even if server 2 were to fail or is it simply a mthod of link to a file located somewhere else.
I am looking for a way to have dyanimic copies of files on 2 servers that sync.
Thanks
David
I am lost on this. Any help greatly appreciated.
I want to duplicate the fileshare on our primary server to our secondary server which will also have a file server roll. The point is to have redundancy in case of a failure. The servers will also be geographically far apart.
Thanks,
David
I added the secondary server as a "backup controller" under domain controllers folder in the active directory window of the primary server. Then I installed the domain controller role on the secondary server for an "existing domain". The two servers seems to be identical...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.