inserting Commas

Question

Post reply

inserting Commas

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Garadin One Orange Chip Points: 29613 More actions · Answer 1

Jeff Moden (5/5/2010)

Here's what I get on my 8 year old desktop box for performance results...

...

I...

You...

...

So how's Windows 98 holding up nowadays?

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 2

Heh... actually, it was "cutting edge" at the time with Windows XP Pro and all. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

Garadin One Orange Chip Points: 29613 More actions · Answer 3

Wow. I had no idea windows XP had been around that long. Apparently it came out in 2001 though. I only started using XP on my home machine like 2 years ago. Never had a good reason to upgrade. Switched to windows 7 right away though.

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

karthik M One Orange Chip Points: 29139 More actions · Answer 4

karthik M

One Orange Chip

Points: 29139

May 7, 2010 at 1:36 am

#1163842

how the scalar function and ITVF are working internally?

karthik

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 5

I don't know about the "deep internals", but a scalar function has the same affect as calling a stored procedure where an iTVF used with a CROSS APPLY makes for what amounts to a nice inner join with all the properties of a correctly written correlated subquery.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions