Chirs, I can use IF EXISTS but as it will perform row by row so when there is bulk data arounds 5-10 lakhs that my procedure will take long time...

Yes I am trying to insert rows which does not exists and update rows if already exists...

Can you please convert my posted query into the solution that you are suggesting...

ChrisM@Work (1/30/2014)

---

It's by design, Kapil. There are two steps to the update/insert - a read to determine the rows which will be affected (by the join to source) and then...

kapil_kk (1/15/2014)

---

Abu Dina (1/15/2014)

---

kapil_kk (1/15/2014)

---

Abu Dina (1/15/2014)

---

Abu Dina (1/15/2014)

---

kapil_kk (1/15/2014)

---

I have created a foreach container to capture values from a query and run a script for each line. For some...

Abu Dina (1/15/2014)

---

kapil_kk (1/15/2014)

---

Abu Dina (1/15/2014)

---

Abu Dina (1/15/2014)

---

kapil_kk (1/15/2014)

---

I have created a foreach container to capture values from a query and run a script for each line. For some reason...

Abu Dina (1/15/2014)

---

Abu Dina (1/15/2014)

---

kapil_kk (1/15/2014)

---

I have created a foreach container to capture values from a query and run a script for each line. For some reason though I can't...

Abu Dina (1/15/2014)

---

kapil_kk (1/15/2014)

---

I have created a foreach container to capture values from a query and run a script for each line. For some reason though I can't get past...

Thanks Miller for your advice 🙂

It will be easy for us to help you if you provide some sample data........

ChrisM@Work (1/2/2014)

---

kapil_kk (1/2/2014)

---

ChrisM@Work (1/2/2014)

---

FOR XML PATH is used for concatenating values from different rows - the value you are attempting to assemble is a concatenation of values on the same...

ChrisM@Work (1/2/2014)

---

FOR XML PATH is used for concatenating values from different rows - the value you are attempting to assemble is a concatenation of values on the same row. Just...

this is what I am doing but stuck at not getting column values:

SELECT STUFF(

(SELECT ',' + '"'+sc.name+ '":' + '"' + column values+ '"'

FROM sys.columns sc

INNER JOIN sys.tables st...

Amount column in query is present in two tables....

From which you are extracting the amount?

May be one your table data contains negative values...

Place table name with Amount in select query...

Try this,

this is what i can do without table structure:

;WITH CTE AS

(SELECT Top 1 Amount+VATAmount AS TOTAL

FROM FAAccKitty WITH(NOLOCK)

inner JOIN FAAccWinners on FAAccKitty.PlaceID=FAAccWinners.PlaceID

INNER JOIN Reservations WITH(NOLOCK) ON (Reservations.PlaceID...

BlackIceAngel (12/31/2013)

---

Getting syntax errors for this

Msg 102, Level 15, State 1, Line 5

Incorrect syntax near ')'.

Msg 156, Level 15, State 1, Line 11

Incorrect syntax near the keyword 'AND'.

Msg 156, Level...