Bruce W Cassidy (4/19/2009)

---

[font="Verdana"]Only if you use code to generate the lookup table. 😀 Go...

Bob Hovious (4/21/2009)

---

Here you go. Cast/Convert the float data to dataype money

then the outer CONVERT will insert the commas for you.

declare @test-2 float

set @test-2 = 7265342.12

select @test-2,...

Hi

You can use a ROW_NUMBER and build partitions:

DECLARE @t TABLE (Date DATETIME, Id INT, Name VARCHAR(10))

INSERT INTO @t

...

Hi

If you are sure that the trailing "spaces" are tabs you can use this statement to remove them:

UPDATE clientsupplier

SET clientcode = LEFT(clientcode, CHARINDEX(CHAR(9),...

Hi

Sorry for late answer. Too much meetings...

So as Paul already indicated we have a new Tally solution with pretty strange characteristics... I already did some tests with Jeff. It seems...

Hi Phil

Sorry, I had an error in...

Hi Phil

As first, thanks again for all your input!

I included your function into my test environment and took the Moby Dick text into a new table #SourceMobyDick. Here the stats:

SourceType...

Hi Phil

Thanks for your tests! Heh... so it seems that the best way stays depending on the current case. 🙂

I just tried to reproduce but in my environment the Chars...

Hi

I will include both C# and VB.Net. I will include the most important functions:

* Paul's version which simply uses string.Split because it is a one line solution

* The RegEx solution...

Bruce W Cassidy (4/19/2009)

---

From the comments against Phil's article, I believe it's possible to build regular expressions that basically expand recursively, and if you call one from within SQL Server,...

Bruce W Cassidy (4/19/2009)

---

If you are building that translation for performance, I'd make one change:

Use an array of 256 2-character strings with the hexadecimal encoding for each byte. So...

Hi Bruce

I already started. Since now I didn't know which .Net language to take... 😛

I also enjoyed...

Hi

So with a representative feedback of three votes 🙂 with the following results "Do both but doesn't matter", "I like C#" and "I like VB" I think I will provide...

Bob Hovious (4/19/2009)

---

A thought here for some of you who might have the ear of the powers that be at Microsoft. Given that CLR is demonstrably faster at...

Lynn, Alvin

Thanks a lot for the feedback!

Greets

Flo