to get a total value from both query, the only way to do is UNION both query and a Select Statement on top of UNION.
SELECT Sum(Col1) as A, Sum(Col2) as B
FROM ( SELECT Col1, Col2 FROM TableA
UNION Select Col1, Col2 From TableB ) A
Archive for February, 2008
SQL – Sum a Union
Posted in MSSQL, tagged SQL on February 18, 2008 | Leave a Comment »
Active Directory 01.00.00 Documentation
Posted in Active Directory, DNN Deployment, DNN Module Development, DotNetNuke v4, dnn, dotnetnuke, tagged DNN Active Directory on February 12, 2008 | 2 Comments »
For those who wish to know more the step to configure SSO in DNN portal, please click here to download the documentation. It covered how to configure in IIS for Intranet environment.
