I already have a SP which generates unique IDs. But i cannot use that SP in INSERT INTO ... SELECT statement as SP cannot be used in selects. So I...

Hi... Isn't there any simpler method. May be by using some other stored procedure or function to do the same task?

Because most of the shared servers do not allow use...

Download link :

http://www.microsoft.com/downloads/details.aspx?FamilyID=b352eb1f-d3ca-44ee-893e-9e07339c1f22&DisplayLang=en

Best Practices Analyzer Tool for Microsoft SQL Server 2000 1.0

Microsoft SQL Server Best Practices Analyzer is a database management tool...

it is jst a "note". You can ignore it.

If you use hfnetchk from Shavlik. It will show you something like:

* SQL Server 2000 SP3

NOTE ...

Hey Thankx A TON!

I shall test this code out tomorrow morning ie abt 10 hrs from now! and get back to you.

I shall try and get the other part of...

CREATE PROCEDURE sp_calculate_depreciation_slm

(

@session_id varchar(100),

@asset_code varchar(50)

)

as

/*

-----------------------------------------------------------------------------

Author : Paras Shah ...

I know it is a hard decision to take to use cursors. But there had been no other solution for me. I have to take data from one row and...

I am not at all using any kinda of Transactions.

Cursors are important for me as I need to fetch rows, calculate the output and update them.

It would not be possible...

Its a good practice to return only error codes using return (RETURN @@ERROR). All other values to be returned should be done using OUTPUT variables.