That is because he missed that you had a cte named estimated. The...

Koen Verbeeck (8/29/2013)

---

Sean Lange (8/29/2013)

---

Koen Verbeeck (8/29/2013)

---

WITH CTE_NoZero AS

(SELECT ID, ReadNo, deviceNo FROM DeviceReading WHERE ReadNo <> 0)

SELECT ReadNo, deviceNo

FROM

(SELECT ReadNo, deviceNo, RID = ROW_NUMBER() OVER (PARTITION BY deviceNo ORDER...

CSV = Comma Separated Values. 😀

Stylez (8/29/2013)

---

Select engine From Units Where UnitNumber = '170272'

Result:

engine

------------

CAT C-15

What i Want to Achieve:

select MFGCODE,model from UASSEM where UNITID = '170272'

MFGCODE ...

Koen Verbeeck (8/29/2013)

---

WITH CTE_NoZero AS

(SELECT ID, ReadNo, deviceNo FROM DeviceReading WHERE ReadNo <> 0)

SELECT ReadNo, deviceNo

FROM

(SELECT ReadNo, deviceNo, RID = ROW_NUMBER() OVER (PARTITION BY deviceNo ORDER BY ID DESC)

FROM CTE_NoZero)...

Stylez (8/29/2013)

---

Hi Guys,

I would need to run the function across a querry that returns more than one values

do i need to create a cursor for this to be able...

Stylez (8/29/2013)

---

Good Afternoon Guys,

The EngineMakeModel is The Raw Column that is not Yet Concatenated and would need to be split into th

EngineMake Columnd and Model Column Separately. The Input would...

The reason I...

Alan.B (8/29/2013)

---

Sean Lange (8/29/2013)

---

Alan.B (8/29/2013)

---

The correct way to split a string using T-SQL would be to use Jeff's splitter as Louis mentioned. That said, what you are doing is quite...

What you posted is not really sample data. It is text that sort of is like sample data.

It looks like you pretty much wrote the query in your explanation...group...

Alan.B (8/29/2013)

---

The correct way to split a string using T-SQL would be to use Jeff's splitter as Louis mentioned. That said, what you are doing is quite simple; you could...

Actually the OP is doing a recursive cte. The cte is named Estimate and the second half joins to it.

You will probably have to use your cte to return the...

If your actual data is as simple as the one example you could also use PARSENAME.

select PARSENAME(replace(EngineMakeAndModel, ' ', '.'), 2), PARSENAME(replace(EngineMakeAndModel, ' ', '.'), 1)

from (values('PeterBilt MT20100')) as x(EngineMakeAndModel)

You are welcome for the links. I keep them handy. 😉

I don't envy you in trying to clean this one up. It is a long and painful road for sure....

saravanakumar.G (8/28/2013)

---

Hi,

Thanks for the reply.

Yes. the SP is working if we put single quotes across the tablename ('schemaname.tablename').

I want to try whether is...