Jeff Moden (8/16/2015)

---

Gosh, I'd be real careful here, Eirikur. While your good code certainly does what was asked, it will fail if table SampleData2 is ever correctly used for...

Thanks for the feedback and you are most welcome.

😎

ErikMN (8/14/2015)

---

I'm trying to find a specific string (a name) and replace it with another inside of a VARCHAR(7000) field. Unfortunately, there are names like Ted and Ken that I'm...

ManiDBLover (8/15/2015)

---

Hi Guys,

I have a requirement to Insert Column 1 and Column 2 based on below condition only. Looking for a Store procedure or query

Condition : Allow Insert when...

Quick suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

;WITH SampleData (PERSON, STARTDATE, ENDDATE, INPUNCH, OUTPUNCH, HOURS,PAYCODE) AS

(

SELECT 1125,'08/11/2015','08/11/2015','08:00', '12:00',4.0, 'REGULAR'

UNION ALL SELECT 1125,'08/11/2015','08/11/2015','13:00', '17:00',4.0, 'SICK'

...

Do you have a schema...

Here is one way of doing this, maybe not the most efficient but it works.

The method is almost identical to what Chris posted before and works with the sample...

Jeff Moden (8/14/2015)

---

Eirikur Eiriksson (8/14/2015)

---

Trying to put my finger on this, just cannot find which kind of XML phobia is plaguing you Jeff:Whistling:, so...

Gail, thank you for the correctio back there, makes me feel kind of sheepish

😎

GilaMonster (8/14/2015)

---

Eirikur Eiriksson (8/14/2015)

---

Chris.Hubbard4U (8/14/2015)

---

I queried...

Trying to put my finger on this, just cannot find which kind of XML phobia is plaguing you Jeff:Whistling:, so far I've checked these

😎

Ablutophobia...

drew.allen (8/14/2015)

---

Eirikur Eiriksson (8/14/2015)

---

Further, I was only stating that with a properly written XQuery, using the text() function is much quicker, I was not commenting or comparing to yours or...

Are you connected to...

Jeff Moden (8/14/2015)

---

Eirikur Eiriksson (8/14/2015)

---

Ed Wagner (8/14/2015)

---

Eirikur Eiriksson (8/14/2015)

---

Alvin Ramard (8/14/2015)

---

Eirikur Eiriksson (8/14/2015)

---

SQLRNNR (8/14/2015)

---

Eirikur Eiriksson (8/14/2015)

---

Sometimes one wonders what drives the responds when one points out that the posted solutions...

tjs8984 (8/14/2015)

---

Hello,

It is implied that if there are two occurrences of the same [Name] element then one will have the AnnualizingFactor of 2080.

Correct. When two occurrences with...