You can try this

select TOP 1 count(*) as [number of occurences]
from (
select case
  when answer_count between 0 and 5 then '...

Formatted SQL code that is wider than the display box does not wrap.  There are scroll bars, but they only seem to work if you highlight text and keep going....

I am really not liking the new interface.
There is waaaay too much white space.  Makes everything look clunky.

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;