Lynn Pettis (5/11/2012)

---

Sean Lange (5/11/2012)

---

Matt Miller (#4) (5/11/2012)

---

Lynn Pettis (5/11/2012)

---

Matt Miller (#4) (5/11/2012)

---

If you're dealing with messaging and responses - you're really in the realm of talking about a SQL...

This sounds a lot like homework. I would suggest that a CTE for this is not the best way to go. See this article from Wayne. http://www.sqlservercentral.com/articles/comma+separated+list/71700/%5B/url%5D

Matt Miller (#4) (5/11/2012)

---

Lynn Pettis (5/11/2012)

---

Matt Miller (#4) (5/11/2012)

---

If you're dealing with messaging and responses - you're really in the realm of talking about a SQL Service Broker application with...

Lynn Pettis (5/11/2012)

---

Didn't see it. ...

Oh you have a hybrid with EAV going on here. UGH!!! You really should just make the extra stuff columns in your order table and not as lookup values from...

You have no column named "dateordered".

Lynn, why not the replace I posted above? It is super fast because it doesn't have to do all sorts of string manipulation.

I think the OP wants no result set at all when there is no row. 0 row(s) returned.

What is it trying to do? This can certainly be made quite a bit simpler by the looks of it.

mark.doyle (5/10/2012)

---

Hi I hope someone can help

I am reletively new to SQL and i have wrote the following basic procedure to check if a field in my table is...

Like this?

if exists

(

select 1

FROM [MantagheInfo]

WHERE (YearID = @year)

)

select

SUM(isnull([TedadTarhModiriatTafzili],0))as TedadTarhModiriatTafzili

, SUM(isnull([TedadTarhModiriatJame],0))as TedadTarhModiriatJame

, SUM(isnull([TedadKhodro],0))as TedadKhodro

, SUM(isnull([TedadMotorcycle],0))as TedadMotorcycle

, SUM(isnull([TedadGhayegh],0))as TedadGhayegh

, SUM(isnull([TedadBisim],0))as TedadBisim

, SUM(isnull([TedadDoorbinAksbardari],0))as TedadDoorbinAksbardari

, SUM(isnull([TedadDoorbinCheshmi],0))as TedadDoorbinCheshmi

FROM [MantagheInfo]

WHERE (YearID = @year)

How about nested replace. You said all you want is to remove "#" and any numbers.

SELECT rtrim(ltrim(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(REPLACE(Data, '#', ''), '1', ''), '2', ''), '3', ''), '4', ''), '5', ''), '6',...

LOL

spam reported

spam reported