My crystal ball says this might work:

SELECT ID,

PreviousYear_Profit,

SUM( PreviousYear_Profit) OVER (PARTITION BY (SELECT NULL)) AS PriorVersion ,

SUM( PreviousYear_Profit) OVER (PARTITION BY (SELECT NULL)) - PreviousYear_Profit AS Variance

FROM calculate

This is a...

Without sample data, I guess you need to do something like this:

SELECTph.CalculatedTotalTime,

ph.ProdHeaderDossierCode,

ph.MachGrpCode,

ph.EmpId,

pd.PartCode

FROMdbo.T_ProcessedHour ph

JOINdbo.T_ProductionHeader pd ON ph.ProdHeaderDossierCode = pd.ProdHeaderDossierCode

JOINdbo.T_DossierMain dm ON pd.DossierCode = dm.DossierCode

whereph.RegDate >= '2013-01-01 00:00:00:000' and

dm.DelDate < getdate() and

ph.MachGrpCode...

Ed Wagner (2/19/2014)

---

GilaMonster (2/19/2014)

---

Welcome to page 2150 🙂

It's not necessarily the easy questions that we moan about. It's the ones with no thought or no research or the ones that...

Has anyone played with your batch separator settings?

You could use CHARINDEX and SUBSTRING functions like this:

WITH Samp AS(

SELECT 'TL43:The product has no marked price.;' AS SomeText

)

SELECT LEFT( SomeText, CHARINDEX(':', SomeText) - 1),

SUBSTRING(SomeText, CHARINDEX(':', SomeText) + 1, CHARINDEX(';',...

You're just too kind :blush:

I'm just someone who loves to help 🙂

Maybe something like this:

SELECT MIN(id) id

FROM sample t1

WHERE EXISTS(SELECT 1

FROM sample t2

WHERE t1.islabel != t2.islabel

AND t1.mark = t2.mark)

GROUP BY mark, islabel

ORDER BY id

Do you understand how...

I'm not sure what's happening here. Maybe someone else can explain this.

It seems that you can correct this using a binary collation in the replace.

with sampledata as (

SELECT N'Something' +...

This:

where t1.mark = 0 and t2.mark = 1

Should be like this:

WHERE t1.islabel = 0 and t2.islabel = 1

Is that correct?

+10

You could think of CTEs as subqueries that are in a different position or as one-use views.

To post formatted code, you just have to put it between the code tags...

Are you sure is NCHAR(65533)?

Here's something you can use to identify it.

WITH E1(N) AS(

SELECT N FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))e(N)

),

E2(N) AS(

SELECT a.N FROM E1 a, E1 b

),

E4(N) AS(

SELECT a.N FROM E2 a, E2...

Just to be sure. Do you understand how it works? Which option did you take?

Could you use REPLACE? Or would that be a problem with your real data?

Sean Lange (2/18/2014)

---

OCTom (2/18/2014)

---

The following was in 1991 and in response to the question, "How many seminars or classes have you attended to keep up on technology?"

Answer: "I'm not really...