SQL Server and Excel
- posted by James @ 11:10 AM

 
If you have a problem connecting to the report server from outside the domain:

Here is the problem, it is trying to open http://sqlreporting/reports and since you're outside of the domain, it must call out a Fully Qualified Domain name to successfully connect to your server. It should read Opening Page: http://sqlreporting.mynetwork.com/reportserver...
To fix this, you need to modify 2 files:
1) Reporting Services\ReportManager\RSWebApplication.config
2) Reporting Services\ReportServer\RSReportServer.config
- posted by James @ 11:10 AM

 
--DB2 SQL Syntax

--TOP 10 Example:
SELECT EMPNO, LASTNAME, FIRSTNME, SALARY
FROM DSN8710.EMP
ORDER BY SALARY DESC
FETCH FIRST 10 ROWS ONLY;

--Concatenation:
SELECT 'A' || 'B'
--Output AB

- posted by James @ 5:55 PM

 
DB2 Tricks
Use the | (pipe) character to concatenate two text fields
- posted by James @ 5:52 PM

 
SELECT * FROM QSYS2\SYSCOLUMNS WHERE TABLE_NAME = 'YourTable' and it will give you similar results to sp_columns. If you want more information, you can go to:

http://publib.boulder.ibm.com/html/as400/v4r5/ic2924/index.htm?info/db2/rbafzmst159.htm
- posted by James @ 2:51 PM

 
ActiveX SQL Server scripting to run Excel Macro
xl = CreateObject("Excel.Application")
xl.Workbooks.Open (FileName)
xl.Run ("ModuleName.MacroSubProcedureName")
- posted by James @ 11:42 AM