Charles.Otten (12/16/2010)

---

if you are going to use functions, use scalars and not table based for the logic. That should allow you to maintain the code and not take too...

If i was you i would start by simplifying the logic in the loop and moving it piecemeal into the cursor statement.

ie....

(Untested)

Create function CalcField_2(@Field1 char(2),@TerminatingIOI char(<Something>),@ConnType int)

returns table

as

return

(

Select Case when...

My default answer would be it can be translated into a set based soultion , but it depends on what is happening when you say 'do the procesing and formatting...

Double post,

All replies to http://www.sqlservercentral.com/Forums/Topic1035686-391-1.aspx please

IIUC , you have a datetime datatype , and you wish to remove the time portion , correct ?

You cant , its intrinsic to the datatype, Please see this...

I...

LutzM (12/15/2010)

---

Lynn Pettis (12/15/2010)

---

I'm not in a position to test, but don't you get the same issue when using decimal(19,4) as you do when usinf money?

Now I may be wrong,...

There seem to bit a bit more going on in there :ermm:

But this should solve the 'simple' question you posed ...

select *,((counts*1.0) / sum(counts) over (partition by 1))*100.0

from @t

Can you show us how you have you attempted to solve this problem yourself ?

Craig Farrell (12/8/2010)

---

I believe that a function called for a row with the same parameters as other calls is 'remembered', but I'd have to do some testing to confirm that....

Im not clear on your issue , but in any case i would start a new thread. Most people will ignore old threads.

😉

Unpivot the data , either manually using case or the UNPIVOT operator

and then its simply top(1) ordered by DateCol desc

As it is using an index spool , that does suggest that extra indexing is needed, since that is effectively what it is doing....

Something like this ? ...

with cteRand

as

(

Select top(1000) abs(checksum(newid())) as Rand

from sys.columns a cross join sys.columns b cross join sys.columns b

)

Select *

...