p.shabbir (6/3/2016)

---

Ok. I have modified the query like below. But getting error Like "Invalid length parameter passed to the LEFT or SUBSTRING function".

WITH MyData AS (SELECT SRC_ERROR_OUTPUT FROM REJ.FILE_READ_REJECTS WHERE...

p.shabbir (6/3/2016)

---

11157243 1224314 20160523 05/22/2016 20160526 GLOB 4,000 16 72 ISASANTAELLA@HOTMAIL.COM c1e1b966-4233-11d4-85dc-080009daf0d2 373294099 XXXXX4099 ISABEL SANTAELLA DE KUBLER ISABEL SANTAELLA...

SELECT m.*

FROM mytable m

WHERE EXISTS (

SELECT 1

FROM mytable i

WHERE i.cst_org_name_dn = m.cst_org_name_dn

AND i.mbt_code = 'EM')

AND m.mbt_code <> 'EM'

Do you have a means of detecting the split point?

WITH MyData AS (SELECT MyString = '11157243 1224314 20160523 05/22/2016 20160526 GLOB 4,000 16 72 ISASANTAELLA@HOTMAIL.COM c1e1b966-4233-11d4-85dc-080009daf0d2 373294099 XXXXX4099 ISABEL SANTAELLA DE KUBLER ISABEL SANTAELLA DE KUBLER Y MORI N...

WITH MyData AS (SELECT * FROM (VALUES (11,1),(12,1),(13,2),(14,3),(22,2),(22,2),(23,4),(24,4)) d (Item, [Count]))

SELECT

[10 to <20] = SUM(CASE WHEN Item >= 10 AND Item < 20 THEN [Count] ELSE 0 END),

[20 to...

Duplicate post, the original is here.

Duplicate posts waste time and effort. The original post has useful questions and replies. Responding to this thread will lead to a fragmented domain.

Duplicate post, the original is here.

Duplicate posts waste time and effort. The original post has useful questions and replies. Responding to this thread will lead to a fragmented domain.

GilaMonster (6/2/2016)

---

Grant Fritchey (6/2/2016)

---

Great story. A...

This story probably is true because...

UPDATE eligibility SET primary_plan = 0

WHERE primary_plan <> 0

AND EXISTS (

SELECT 1

FROM temp_eligibility e

WHERE e.eligibility_id = eligibility.eligibility_id)

Might eliminate some writes.

Luis Cazares (6/2/2016)

---

I would suggest that you use the XML PATH option (unless you already use CLR)....

There are several ways to do this, most of them are compared here.

squvi.87 (6/2/2016)

---

Hi there,

Following code will do the job for me. But I wonder is there any other way to accomplish.

create table #t1 (id int , names varchar(100))

declare @a varchar(100) ,@i...

WhiteLotus (6/2/2016)

---

Hi Guys ,

I am tuning an UPDATE query by adding an index

UPDATE XYZ

SET Count = Count + 1,

LastOccured = GetDate()...