Order by NEWID and take the TOP 400 🙂

Any idea of you giving us some readily consumable data to work on the query?

Lynn Pettis (3/22/2012)

---

ColdCoffee (3/22/2012)

---

The problem is the CROSS JOIN. why do u want to do...

The problem is the CROSS JOIN. why do u want to do a cross join...

:crazy:

Chris Harshman (3/22/2012)

---

I suppose it would be easier if...

Acually explicit conversion to FLOAT preserves all the decimal...

Chris Harshman (3/22/2012)

---

how about something like this to figure out the most decimal places used in the table:

SELECT MAX( CHARINDEX('.',REVERSE(CAST(CAST(val AS float) AS varchar(11)))) -1 )

FROM tablename

...

Here is the algorithm (as you said you needed only directions)

1. PIVOT the #ValueList table to contain 4 columns

2. Use CROSS APPLY/OUTER APPLY to apply the pivoted table to the...

Ouch :pinch: Implicit conversions are causing the rounding

Look at this:

declare @dec decimal(10,7)

set @dec = 1.6709999

select flt = CAST ( @dec as float)

...

Robert klimes (3/22/2012)

---

would something like this work for you. not what parsename is intended for but I think it does the trick.

declare @dec decimal(10,7)

set @dec = 87.01

select len(parsename(cast(@dec as float),1)...

How about this?

DECLARE @Tab TABLE ( Num DECIMAL(10,7)) ;

INSERT @Tab (Num)

SELECT 87.41

UNION ALL SELECT 1.2

UNION ALL SELECT 1.0

UNION ALL SELECT...

Yeah.. and u'r welcome chrissy..

It is doable... but we need some input from you before we start on leading you. Please provide us readily consumable data so that we can get started, as mentioned...

How many number of rows are possible for an ID ? is it alwyas 2 or it may vary dynamically ? As Drew said, it violated 1NF, the output will...

i dont think 4 UNIONs are not required.. Try this:

; WITH CTE AS

(

SELECT Company , City, Vals , Tier , TierVals

FROM #Test T

UNPIVOT ( TierVals For Vals in (Calc1,...