Kingston Dhasian (4/26/2013)

---

In your table GV_Voucher, the column TransactionID has not been defined as a UNIQUE KEY

You will have to make TransactionID a UNIQUE KEY in GV_Voucher to create this...

Kingston Dhasian (4/26/2013)

---

Is it possible for TransactionID to be duplicated in the table GV_Voucher?

If the answer is No, then you can fetch it based on VoucherNo's else you will need...

kmundt (4/25/2013)

---

Sorry...

Msg 8120, Level 16, State 1, Line 1

Column 'soh_shipmentnbrdata.Shiplist_Status' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY...

Please refer the post of Gail

kmundt (4/25/2013)

---

I am a SQL newbie that is just learning. I have 3 tables that I am joining on a Sales Order #. The first 2 tables are one...

my ROWTERMINATOR is ''

I tried that but still error was coming

ChrisM@Work (4/25/2013)

---

;WITH Sampledata (id, name) AS (

SELECT 1 , 'srinivas '...

L' Eomot Inversé (4/25/2013)

---

Good question and explanation.

Triggers that work only on single rows are a common problem, so anything that points out the pitfalls and warns people not to write...

DECLARE @string varchar(10) = 'aapail'

SELECT SUBSTRING(REVERSE(@string),3,1)

Hi,

we are not clear with your requirements..

can you plz give us more details?

Good question Hugo 🙂

This time I am able to grab the points :-P....

Last time I forgot to see the Go batch separator and comments and clicked on wrong one!!!

Thanks!!

Declare @STNno varchar(10)

EXEC dbo.GetSTNValue @storecode , 0 ,@stnno OUT

INSERT INTO GV_StoreAllocation (StoreId, STNNo, FirstVoucherNo, LastVoucherNo, Quantity)

SELECT

DISTINCT @storecode,

@STNno,

@FirstVoucherID,

@lastvoucherID,

@quantity

FROM GV_Voucher gv

JOIN GV_VoucherStatus gvs ON gv.VoucherStatusId = gvs.VoucherStatusId

WHERE gvs.VoucherStatus...

nenad-zivkovic (4/24/2013)

---

kapil_kk (4/23/2013)

---

Hi,

I was not aware of the fact that after making

SET IDENTITY_INSERT dbo.Test OFF;

identity value gets incremented. I am confused now as what is the purpose of...

Hi,

I was not aware of the fact that after making

SET IDENTITY_INSERT dbo.Test OFF;

identity value gets incremented. I am confused now as what is the purpose of making Identity_Insert...