Jeff Moden (6/5/2009)

---

99.99% SQLServerCentral.com - I like folks like you and the others I've come to know and some of the other sites just seem to bloody rude at times.

You...

David Burrows (6/5/2009)

---

Because if the number is too big, decimals are sacrificed to make it...

Lynn, I see yet once again why we refer to you as Saint.

This gets you closer, though some decimals are still lost.

if object_id('tempdb..#d') is not null drop table #d

create table #d (column3 varchar(255))

declare @var float

set @var = 654646548463.41646646

insert into #d

select 'column-Headding'...

Now that promises to be a useful trick that I haven't seen before. Thanks for sharing it!

Bruce W Cassidy (6/4/2009)

---

[font="Verdana"]I'd go for passing in the list as XML, even for the small list. The reason is that it's not difficult to get an object in...

Well, this is pretty wide open. Do you mean with installing it? What are the new features? We're pretty good here, but we haven't mastered the brain meld thing over...

Paul White (6/4/2009)

---

Jeff Moden (6/4/2009)

---

I agree... I must think differently and use the wrong search words. It's always a PITA for me to do a search on such a...

Jeff Moden (6/4/2009)

---

WayneS (6/4/2009)

---

Jeff Moden (6/3/2009)

---

The following code creates a million row multiple account checkbook, does the "Fire Hose" cursor running total thing 5 times and follows that with the...

Help you did, I do...

Paul, I do believe that you found what was going on.

Now, I searched the net for hours, and never found any of these articles. How did you do it?

GilaMonster (6/4/2009)

---

None that I've...

Jeff Moden (6/3/2009)

---

The following code creates a million row multiple account checkbook, does the "Fire Hose" cursor running total thing 5 times and follows that with the "Pseudo Cursor" method...

Paul White (6/4/2009)

---

Well that sucks - I just got the May edition in my inbox yesterday. Where's my June copy??? Grrr!

Thanks Wayne, I will look forward to...

Paul White (6/4/2009)

---

The magazine I just...