Here is the table structure of GV_Voucher for your reference

USE [GVApp]

GO

/****** Object: Table [dbo].[GV_Voucher] Script Date: 05/07/2013 17:32:18 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE...

ChrisM@Work (5/7/2013)

---

You're having problems with this mainly because you are working with one row at a time. Your control table is updated once for each row inserted, instead of updating...

can you please provide some more details so that we can help you

Hi Chris, I didn't get your point

Here is my stored procedure script in which I have to achive isolation:

ALTER Procedure [dbo].[BS_Voucher_CreateVoucher]

@vouchertypeID int = 1,

@denomination int = 100,

@quantity int = 10,

@amountvalue int = 100,

@userid varchar(50) = 1,

@validateDays...

Hugo Kornelis (5/6/2013)

---

wolfkillj (5/6/2013)

---

Good question - I appreciate the QotDs that demonstrate quirky behavior.

It bears mention that Microsoft has slated the "timestamp" syntax for deprecation in favor of "rowversion"...

Sean Lange (5/6/2013)

---

kapil_kk (5/6/2013)

---

Hi, I have a scenario in which I am performing insertion on a table using a stored procedure. For every insertion there is a ID generation for...

Lynn Pettis (5/6/2013)

---

kapil_kk (5/6/2013)

---

Sergiy (5/6/2013)

---

Yes, it is correct.

In fact,...

Thanks Vinay for the question... 🙂

I was not aware of the thing that if we use DISTINCT then Column names specified in the ORDER BY clause, must be defined in...

Sergiy (5/6/2013)

---

Yes, it is correct.

In fact, "RETURN @pSTN "...

Instead of RETURN I have added a SELECT @pSTN statement for the different different conditions and its working 🙂

Is it correct?

Me too lose the points 🙁

malleswarareddy_m (5/4/2013)

---

Because Id value 4 is not exits in t2 table. Thats why you getting error.

If you have foreign key then the reference column value must exists in parent...

+1 🙂

Please provide us more detail so that we can answer your question more clearly...