I know this is a bit old and "sort of sorted" but here is the way you can do it with "-".....

In the Value expression for the field, use

=IIf(IsNumeric(Fields!Number.value),Fields!Number.Value,0.000000)

And in...

My mistake....

Here is the correct way to do what you want....

Put this in the format for the field...

="""" & INT(Fields!Number.Value*100)/100 & """"

It will retain the original number but produce a...

You can do pretty much as Pham Trung suggested in an expression in the report as well...

=(INT(100*Fields!Value.Value)/100)

Thanks for the Article.

For further reading, anyone interested in using xml to split strings may be interested in this excellent blog post from Brad Schulz

http://bradsruminations.blogspot.com/2010/01/delimited-string-tennis-again-final.html

in which he describes a few...

PaulB-TheOneAndOnly (5/22/2010)

---

1- You have to code one insert statement for each row you want to add to the target table.

2- You cannot insert '11.25/hr' into a currency data type -...

Changing the name of the server :

1. Change the name of the Windows host

2. Reboot

3. Rename SQL Server

select @@SERVERNAME -- confirm that SQL still thinks of itself as the old...

Hi Dobermann,

Just a quick note to say that you should not bother testing with my version - it will not work and no amount of tweaking it will make it...

Quite right about that code not working....;-)

I don't think that method will extend to what you are trying to do, but I am sure Jeff's will work with only a...

Have you tried calling the stored proc 10,000 times purely in SQL server to see whether that is a limiting factor?

Dobermann (5/14/2010)

---

Hey, I know I dumped more on top of it and used even more resources 🙂 But that's the fun of it. :w00t:

Previously I had thought that Eric's...

Paul White NZ (5/14/2010)

---

I'd...

That sounds about right - the SQLCLR version is blindingly fast in my tests too....

Someone must be able to make a T-SQL version that comes close....Jeff....?

Oh and while I think...

I couldn't help it - I like trying out things....:-P

CREATE FUNCTION [dbo].[ProperCase](@text VARCHAR(8000))

RETURNS TABLE

AS

RETURN(

SELECT

A.B.value('(./text())[1]','varchar(8000)') AS [TEXT]

FROM (

SELECT...

I usually use syscomments for this - as long as the SP is not encrypted

Check that the SQL Browser service is running, failing that, check which port the instance is using and connect directly to that port.