And before anyone points it out, I'd like to state that I deliberately LEFT OUT transactions from the procedure I posted to give some weight to the fact that the original procedure would have left records orphaned if it had failed within the cursor, since there was no transaction started before the cursor began. Cheers.
2003-07-24
CREATE PROCEDURE sp_calculate_depreciation_slm ( @session_id varchar(100), @asset_code varchar(50) ) as /* ----------------------------------------------------------------------------- Author : Paras Shah Date : 02-July-2003 ---------------------------------------------------------------------------- */ declare @rowid numeric(24,6), @no_of_days numeric(24,6), @max_days_in_month numeric(24,6), @asset_accumulated numeric(24,6), @depreciation_rate numeric(24,6) declare @depreciation_accumulated_temp numeric(24,6), @first_row_count numeric(24,6) declare @amount numeric(24,6), @depreciation_accumulated numeric(24,6), @asset_wdv_as_on_date numeric(24,6), @writeoff_amt numeric(24,6) set @first_row_count=0 declare curTransaction CURSOR STATIC for select rowid,no_of_days, […]
2003-07-24
2 reads
PS:Completed indicates the stored procedure has completed. RPC:Completed occurs When one instance of SQL Server send a request for another SQL Server to execute a remote procedure, the relational engine recognizes it, and shows in the profiler as RPC:Starting and RPC:Completed when it completes
2003-07-23
2003-07-23
1 reads
Cost may be the biggest reason not to place the two on an 8-way server. There are a lot of licensing options, but in general you will be paying for both engines. The published Enterprise Editions of both products on an 8-way server is roughly $480,000 US. http://www.microsoft.com/sql/evaluation/compare/pricecomparison.asp In addition to the cost of the […]
2003-07-23
Hi Jigman, quote: 'Transaction cannot start while in firehose mode' One of our developers had this when updating a table in EM The only thing I could find in BOL relating to this was... quote: The client cannot send any other Transact-SQL statements on that connection until the application has either processed all the rows […]
2003-07-23
quote: I was inserting data and was stopping every now and then to c if it worked. My last check was at ID 51. After ID 60 I stopped to check again. After I reopend my database I was alarmed because I thought the data wasn't there anymore. What had happened though was it chucked […]
2003-07-23
2003-07-22
This query should return what you need: Select Coalesce(a.year,b.year) as [Year], a.value as 'ValueOfSubID1', b.value as 'ValueOfSubID2' from (Select * From MyTable WHERE ID = 1 and SubID = 1) a FULL OUTER JOIN (Select * From MyTable WHERE ID = 1 and SubID = 2) b On a.Year = b.Year and a.ID = b.ID
2003-07-22
2 reads
2003-07-18
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers