WITH cteSports AS (

SELECT * ,sn = ROW_NUMBER() OVER (PARTITION BY name ORDER BY sport)

FROM #example

)

SELECT

cte.name

, cte.city

, cte.entryDate

, sport1 = MAX(CASE WHEN cte.sn =...

When SQL processes a batch of records, it's an all or nothing process. If one of them has an error, all are aborted.

The only way to do skip a...

Here are 3 different approaches that will acheive the same results

-- Using cte with ROW_NUMBER

WITH cte AS (

SELECT CustID, PrintedDate, rn = ROW_NUMBER() OVER (PARTITION BY CustID ORDER...

Since your query does not have an ORDER BY clause, you are not guaranteed of any specific order.

Perhaps adding the following to the end of your query will help

ORDER BY...

spectra (1/5/2017)

---

DesNorton (1/5/2017)

---

INSERT INTO PRIOR_DIST (_ID, COSTS_DST, IS_ACTIVE)

SELECT

@_id,

ROUND(CASE WHEN ta.const1 IS NULL OR ta.const1 != 0 THEN pd.COSTS_DST * ta.const1 / @const2

...

INSERT INTO PRIOR_DIST (_ID, COSTS_DST, IS_ACTIVE)

SELECT

@_id,

ROUND(CASE WHEN ta.const1 IS NULL OR ta.const1 != 0 THEN pd.COSTS_DST * ta.const1 / @const2

...

I am a relative noob, with sooo much to learn.

Just glad I could be of help.

spectra (1/5/2017)

---

Thank you.

I wish to add one condition in my code i.e a zero value checking .

like this ...

if(@const1!=0)

INSERT INTO PRIOR_DIST (_ID, COSTS_DST, IS_ACTIVE)

SELECT

@_id,

COSTS_DST*@const1/@const2,

'Y'

FROM PRIOR_DIST

WHERE _ID = @id_prev;

else

INSERT INTO...

You could also use a virtual tally table

declare @startdate DATE = '2016-04-01'

, @enddate DATE = '2016-04-30'

...

spectra (1/5/2017)

---

What is the datatype of COSTS_DST?

If it is...

INSERT INTO PRIOR_DIST (_ID, COSTS_DST, IS_ACTIVE)

SELECT

@_id,

COSTS_DST*@const1/@const2,

'Y'

FROM PRIOR_DIST

WHERE _ID = @id_prev;

Take a look at the COALESCE function

ma701ss (1/3/2017)

---

Forget returning the user id or data from any other columns, is it possible to amend the code to just return one value, i.e. either -2, -1 or 1?...

It would appear that the [Id] field in AspNetUsers contains GUIDS.

However, your proc declares @userid as INT, and then tries to assign a GUID to an INT...

Is product not possibly a view?