Quote from BOL, SQL server 2k8:

nchar [ ( n ) ]

Fixed-length Unicode character data of n characters. n must be a value from 1...

Client-side data entry validation....

It's explained reasonably well in BOL.

n is the number of characters, which for CHAR(n) datatype is the same as the storage requirement in bytes. The storage requirement is 2xn...

Try this.

There's an interesting article on MSDN covering nested transactions:

http://msdn.microsoft.com/en-us/library/ms189336.aspx

One last point - the sequence table which holds the next sequence number for table gltrx_all. Below is a rewrite which will accelerate the update/read:

...

Thanks for the generous feedback, troe_atl. I'd agree with Sean's comments; lurk here from time to time, try resolving a few issues yourself - you don't have to post until...

Close. I've moved some workings to outside of the transaction to mimimise the transaction duration (and any resources which might be unnecessarily affected).

USE [ISPurchasing]

GO

/****** Object: StoredProcedure [dbo].[cust_CreateJournalEntrymod] ...

Not so fast! We're not done yet! It still requires a transaction for those table updates, and a try-catch block to make it all work nicely....

-- Let's see what the date arithmetic is for:

select DATEDIFF(mm,0,getdate()) -- months since day 0

select DATEADD(mm, DATEDIFF(mm,0,getdate())-1,0) -- first day of last month

SELECT DATEADD(s,0,DATEADD(mm, DATEDIFF(mm,0,getdate())-1,0)) -- first day of last...

Just as easy without. Make...

troe_atl (8/18/2011)

---

Hi guys. I really appreciate all of the help in optimizing this sproc. Chris, I've tested the code you submitted and everything works fine but I need the results...

Troe_atl, we still have to enclose the inserts within a transaction and...

What action are you attempting to perform here?

Hello

Have a read of the link in my sig for general guidelines on posting. Included in this is a suggestion for the creation of sample data for folks to test...