If I am reading you correctly, you want to always grab the previous fiscal year.  This means that your month and days will always be the same because your fiscal year...

Are you saying that your want to put the transaction logs on the same mirrored set of disks with the OS?  Where is your paging file?

The ideal situation would be seperate...

How are you scheduling it, SQL Agent?  Who is the job owner?  Which account is your SQL Agent running under?  How were you logged in when you ran it manually?

Ken's example does just that.  Why don't you follow Remi's advice and post some sample data and your expected output?

You're going down the right path, but try using decimal data type and setting the precision and scale.  For example,

declare @money money

set @money = 150.2315

select CAST(@money as decimal(18,2))

Your error is comming from your UNION statement.  Look up UNION versus UNION ALL in BOL.  UNION is pretty much the same as doing a DISTINCT on the UNIONed recordset...

Well, what was the problem?

I would step through your code and find out what the value of @sHMC and @iRowCounter are right before the error.  I think you'll find that the value already exists. ...

Can you post your table DDL (including indexes) for the Person table?  Also, are you starting with an empty table?  The only way to get this error is if the...

The row already exists in the index PersonUserName.  Whether or not you've ran a previous INSERT, the row already exists.  That is the only way to produce this message!  It...

When you look at your DTS package in the designer window, you should see arrows between tasks/connections.  These arrows show you the order of operations for your package.  Add in...

N'A01' tells SQL Server to treat the contents of the string, in this case A01, as Unicode.  If you look at the sysusers.name column, it is of data type SysName. ...

You can use an INSERT INTO #tmpTable(col1, col2, etc) SELECT EXEC sp_stored_procedure @parameter1, @parameter2, @etc

There are some pros/cons you may want to know regarding this approach that I do not have...

Based on the code you've posted, it is unclear as to exactly what you are trying to accomplish.  What are you doing with the results from the SELECT?  Is there...

Thanks for the example Jeff. 

Faizjmc, it is important to note that Jeff set the ROWCOUNT back to zero after he was finished.  Don't forget to do this!  Forgetting to...