vinu512 (2/7/2013)

---

I worked it out. This is the query that would get you the results you want:

--Creating Table

Create Table Ex1

(

Id Int Identity(1,1),

AllLevels Varchar(MAX)

)

--Inserting Sample...

carlosaamaral (2/7/2013)

---

Good Morning,

to 200,000 lines is very, very slow ..... :crying:

    to 1 line, it's good ...

I will continue using the...

demonfox (2/7/2013)

---

ChrisM@Work (2/7/2013)

---

There was a thread covering exactly this, fairly recently. I'll try to track it down. IIRC the conclusion (for...

There was a thread covering exactly this, fairly recently. I'll try to track it down. IIRC the conclusion (for most folks)...

~nano (2/7/2013)

---

Hi there

I had this frustrationg error on a query as well, all though the dataset I was using for a join didnt even contain anything other than numbers.

I got...

DougG (2/6/2013)

---

...I guess what I missed from Scott's post was that all of the "THEN"s will be evaluated even if it does not pass the "WHEN" or

if a previous WHEN...

ALI100 (2/6/2013)

---

SetFormattedValue =CASE

When rg.ReferredFieldType='NUM'

Then CAST(#PointedMslValues.Value AS NUMERIC(18,cAST(rg.ReferredDecimalPoints) )

more cases .

END

I am generating a dynamic query which is giving error actually it...

greg.bull (2/7/2013)

---

...Would you mind explaining what the "working" line does in the cross apply line (ie is this the trigger for a new episode ?)

Regards, Greg.

PS I often get called...

Apologies, I missed a column from the GROUP BY:

SELECT DT.MO_OF_YR_NM ...

You commented out the query hint. Can you run it without the query hint commented out, please?

Like this?

SELECT

t.*,

x.*,

y.*,

z.*

FROM (SELECT Target = 100) t

CROSS APPLY (

SELECT

DataValue = CAST(t.[Target] AS DECIMAL(15,4)),

DataType = 'C'

) x

CROSS APPLY (

SELECT vcDataValue = CONVERT(VARCHAR(20),x.DataValue,1)

) y

CROSS APPLY (

SELECT FormattedData...

Have another read of Scott's...

Try using APPLY for prototyping this. When you're done, converting to an inline function is little more than copy & paste:

SELECT

t.*,

x.*,

y.*,

z.*

FROM PSBPR_Tree t

CROSS APPLY (

SELECT

DataValue =...

DougG (2/6/2013)

---

ChrisM@Work (2/6/2013)

---

T.Target isn't one of the numeric datatypes. You're only trapping one string value from being bassed in to the function, are you sure there are not more? Have...