Hi,

You can use the same export data tool, but choose Flat File Destination and make sure to select LF as the row delimiter.

If it has worked, when you open one...

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