I'm unaware of this as a requirement in TSQL.

I think it's more likely because...

Select case

When jdt_jty_code IN ('ISCO','ISSP','IECO','IECM','IESP','IEHD','ISHD','FRSI') Then 'Install'

When jdt_jty_code IN ('SB42','SB4W','HD42','HD4W','SA2C','SA2W','HD2C','HD2W','SNCO') Then 'Service Call'

Else 'UNKNOWN' END

norbert.manyi (10/2/2012)

---

...Ps. I understand that this particular example can be done using views, but I'm taking about the situations where you cannot do this. (I just can't find a good...

If you are using the Enterprise edition of SS2K8, then change data capture is well worth a look.

-- you have 2 rows for sector 'A', month 1

-- what do you want to do with them?

-- It's not clear from your "Required Output", which...

HowardW (10/2/2012)

---

Anyone else eagerly awaiting this?

Have to say, getting increasingly irate about e-book pricing. Why do I have to pay 50p more, given all the costs of printing, distributing and...

You have to use dynamic sql for this. The core query is this:

SELECT

a.SURV_ID,

[First Question] =...

This might have something to do with it. The first sentence of an excellent indexing article[/url] reads "Indexes are fundamental to...

jmccoy-1028380 (10/1/2012)

---

Yes! That works as desired. Thank You!

Are there other ways though, for evaluating it?

--something like:

IF isnull(@OrderNumRtrn, 0) = 0 OR @OrderNumRtrn = '000000'

...

d.aarts (10/2/2012)

---

I have been working on cleaning a database with addresses in an attempt to dedupe it. There's a lot of pollution and duplicates in the table. Due to efficiency...

Mixolydian (10/1/2012)

---

Wow! I had hoped to find a response but I am overwhelmed. Thank you all very much!

Lowell, thank you for the valuable tip. I do need to check...

dwain.c (10/1/2012)

---

😀

ChrisM@Work (9/28/2012)

---

dwain.c (9/27/2012)

---

Phil,

I think this is a pretty snappy query too.

<<snip>>

Chris - I like what you did with the CROSS APPLY and I was able to do that in...

laurie-789651 (10/1/2012)

---

laurie-789651 (10/1/2012)

---

This appears to work:

I've elected to show rows where both values are zero in case these are wrong - You can remove this if you want.

I've set MAXRECURSION...

This will get you 1 and 2:

DROP TABLE #tblHTML

CREATE TABLE #tblHTML (RowID INT, strPage ntext)

INSERT INTO #tblHTML (RowID, strPage)

SELECT

1, REPLICATE(CAST('I have a table [tblHTML] with an ntext column [strPage]...

L' Eomot Inversé (9/28/2012)

---

ChrisM@Work (9/28/2012)

---

Koen Verbeeck (9/28/2012)

---

laurie-789651 (9/28/2012)

---

Koen Verbeeck (9/28/2012)

---

Grant Fritchey (9/27/2012)

---

THREADIZENS!

Who is going to make it to any of the SQL in the City events coming up in the...