Programming SQL

IRR calculation
You can find IRR, XIRR, and a library of other SQL CLR financial functions in a package called XLeratorDB which is at www.westclintech.com From http://www.developmentnow.com/g/113_2004_7_0_0_429699/IRR-calculation.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/ ... 4 Sep 2009 08:44

Combine Multiple Rows single column into multiple column single ro
select vst_int_id, [1] as id1, [2] as id2, [3] as id3, [4] as id4, [5] as id5 from (select vst_int_id, cpt4_int_id, rank() over (partition by R1 order by cpt4_int_id) R2 from (select vst_int_id, cpt4_int_id, RANK() over (order by vst_int_id) as R1 ... 8 Sep 2009 13:43

The database is being closed before database mirroring is fully initialized. The ALTER DATABASE command failed
ALTER DATABASE DBNAME SET PARTNER = N'TCP://??.???.???:5022' ------------------------*/ Msg 1414, Level 16, State 1, Line 1 The database is being closed before database mirroring is fully initialized. The ALTER DATABASE command failed. ... 3 Sep 2009 11:45

DATE - unable to create table using this data type
While I can successfully parse the following query... CREATE TABLE TEMP ( STARTEFFECTIVEDATE DATE, ENDEFFECTIVEDATE DATE, ) GO ....it fails with this error when I run it: Msg 2715, Level 16, State 7, Line 1 Column, parameter, or variable #1: Cannot find data type DATE. What am I doing wrong here? ... 9 Feb 2009 15:56

RSExecutionLog Error: DTSER_FAILURE (1). Options
Hi, I'm trying to implement the execution log reports for Reporting services, I've followed these instructions to the word!, (http:// www.codeplex.com/MSFTRSProdSamples/Wiki/View.aspx?title=SS2008%21Serv...) However, when I try to execute the SQL agent job, The job fails, looking at the job history I get the ... 5 Feb 2009 11:50

Calling SSIS package from TSQL
Hi all, In SQL Server 2008 64-Bit I am trying to create a stored Proc that calls an SSIS packacage to import an Excel spreadsheet using both "EXEC xp_cmdshell 'dtexec /f "\\ewrsql18\NetLocFiles\Packages\LOCTrans.dtsx"' And "EXEC xp_cmdshell 'dtexec /sq "LOCTrans" /ser ewrsql18' I can execute the package w... 9 Feb 2009 10:39

Problem with SOAP Toolkit and web service authorization
I have problem with SOAP toolkit and authorization web service --************* Utworzenie obiektu CDO.Message ************************ EXEC @hr = sp_OACreate 'MSSOAP.SoapClient30', @iMsg OUT print @hr -- testowo na moim serwerze EXEC @hr = sp_OAMethod @iMsg,'MSSoapInit',NULL,'c:\test.wsdl' print @hr EX... 29 Jan 2009 10:04

Error 5149 Trying to expand transaction log (not enough space)
i'm trying to expand my transaction log file from 7,000MB to 14,000MB Enterprise Manager reports: Error 5149: MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file. The partition the database, and log, is on (F:) h... 7 Jan 2009 09:43

sys.sql_expression_dependencies bug?
Greetings, I'm trying out the sys.sql_expression_dependencies view in SQL2008 to track dependencies of our database objects. The ultimate purpose of this is to be able to generate a list of DB objects in the order in which they need to be applied to avoid dependency errors. However, I'm encountering a st... 15 Dec 2008 18:02

SSIS:Date converting error
Hi My problem is : I need converting a column with data type nvarchar (in SQL SERVER 2000) with format “ddmmyyyy” to other column with data type datetime (in SQL SERVER 2005) also with format “ddmmyyyy”. The scene is : There is a OLE DB Source, where in SQL Command text box we have”select dtemissao from te... 11 Dec 2008 12:33