Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,591 through 46,605 (of 59,095 total)

RE: how to convert vb function to sql function

I don't agree with returning a 0.00 for an invalid fraction, but it's not my code nor requirements. Replace the following section of code in my code and the...
--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)

December 15, 2008 at 10:02 pm

#912936
RE: how to convert vb function to sql function

Jedi Master (12/15/2008)
Here's my final (?) function... Do you see any ways to improve it? It takes all sorts of inputs into consideration, even if you enter "a1/2"...
Simple test says...
--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)

December 15, 2008 at 9:50 pm

#912933
RE: how to convert vb function to sql function

Jedi Master (12/15/2008)
Here's my final (?) function... Do you see any ways to improve it? It takes all sorts of inputs into consideration, even if you enter "a1/2"...
Thought you didn't...
--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)

December 15, 2008 at 9:44 pm

#912928
RE: how to convert vb function to sql function

Thanks for the feedback... the question now is do you really need the individual pieces?
--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)

December 15, 2008 at 9:42 pm

#912927
RE: Are the posted questions getting worse?

Soooooo.... no pooping... no walking away... don'cha ever get constipated? 😛
--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)

December 15, 2008 at 9:38 pm

#912925
RE: Are the posted questions getting worse?

Lynn Pettis (12/15/2008)
Jeff Moden (12/15/2008)
Just to be sure... you're a heck of a better man than me, Lynn... I looked at your posts and you were quite the gentleman in...
--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)

December 15, 2008 at 9:30 pm

#912922
RE: Guest Editorial: On writing SQL

Not ever, it sounds like. Well done.
--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)

December 15, 2008 at 9:22 pm

#912917
RE: Are the posted questions getting worse?

Just to be sure... you're a heck of a better man than me, Lynn... I looked at your posts and you were quite the gentleman in explaining the facts of...
--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)

December 15, 2008 at 9:19 pm

#912915
RE: How do you archive data?

Oh yeah... almost forgot... plan for it now... if you leave the long term archive as daily tables, you'll have a hell of a time doing a search for a...
--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)

December 15, 2008 at 9:11 pm

#912913
RE: How do you archive data?

Interesting idea... and, if you really do that, there is no reason for a purge process. Just create the new table on a daily basis and have a script...
--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)

December 15, 2008 at 9:09 pm

#912912
RE: Are the posted questions getting worse?

Lynn Pettis (12/15/2008)
Well, call me a softy, but I gave him something to work with. Hope it takes the comments to heart and takes the time to provide us...
--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)

December 15, 2008 at 9:05 pm

#912909
RE: how to convert vb function to sql function

I thought this was a fun problem to solve and also gave the opportunity to demo both the power and readability of "Cascading CTE's".
Here's the function...
CREATE FUNCTION dbo.ConvertFractionToDecimal
/**********************************************************************************************************************
...
--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)

December 15, 2008 at 8:54 pm

#912906
RE: how to convert vb function to sql function

Damned nice try, Peter... thought you had it, but not quite...
SET STATISTICS TIME ON
SELECT '5' , dbo.fnResolveFractionals('5') ...
--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)

December 15, 2008 at 8:43 pm

#912905
RE: Are the posted questions getting worse?

Heh... here's my twit for the week... gotta love the arrogance...
http://www.sqlservercentral.com/Forums/Topic619172-1291-1.aspx#619380
--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)

December 15, 2008 at 6:37 pm

#912886
RE: Filling in blanks

sognibene (12/15/2008)
Thanks, Jeff. I was wondering what I was going to have for dinner tonight.
Heh... mmmmmm... p-o-r-k c-h-o-p-s... gaaaahhhh... 😛
--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)

December 15, 2008 at 6:20 pm

#912885

Viewing 15 posts - 46,591 through 46,605 (of 59,095 total)