Viewing 15 posts - 4,096 through 4,110 (of 8,753 total)
Alan.B (1/4/2016)
I been banging my head trying to beat that mTVF for several months :hehe:
Anything to ease the pain cause that got to hurt:-D
😎
January 4, 2016 at 2:27 pm
Alan.B (1/4/2016)
Eirikur Eiriksson (1/4/2016)
Worse still are the multi-statement table-valued functions, in fact there is no excuse or justification for using those.
I agree with this 99.9999% of the time but I...
January 4, 2016 at 2:02 pm
crookj (1/4/2016)
TomThomson (1/4/2016)
HappyGeek (1/4/2016)
Ed Wagner (1/4/2016)
DonlSimpson (1/4/2016)
whereisSQL? (1/4/2016)
Eirikur Eiriksson (1/4/2016)
Ed Wagner (1/4/2016)
Grumpy DBA (1/4/2016)
Ed Wagner (12/31/2015)
Luis Cazares (12/31/2015)
Ed Wagner (12/31/2015)
DonlSimpson (12/31/2015)
YodaQui-Gon
Obi-Wan
Anakin
Whiner
Users
Function
Dysfunction
Staind
Paint
Red
Flag
Banner
Slogan
January 4, 2016 at 11:42 am
bjh1977 (1/4/2016)
Small correction required - UDFs came in as part of 2000 didn't they?
That's correct.
😎
January 4, 2016 at 10:41 am
Phil Parkin (1/4/2016)
TheSQLGuru (1/4/2016)
lucien.jacquet (1/4/2016)
January 4, 2016 at 10:39 am
Koen Verbeeck (1/4/2016)
A bit late, but best wishes for everyone!
BLTN:-D
😎
January 4, 2016 at 7:44 am
Ed Wagner (1/4/2016)
Grumpy DBA (1/4/2016)
Ed Wagner (12/31/2015)
Luis Cazares (12/31/2015)
Ed Wagner (12/31/2015)
DonlSimpson (12/31/2015)
YodaQui-Gon
Obi-Wan
Anakin
Whiner
Users
Function
January 4, 2016 at 6:19 am
Another quick solution, similar to John's apart from this one is counting in both directions
😎
USE tempdb;
GO
SET NOCOUNT ON;
/* SAMPLE DATA SET */
;WITH SAMPLE_DATA(RN,NAME) AS
(
SELECT 1,'Mary'...
January 4, 2016 at 6:12 am
Raastarr (1/4/2016)
Thanks for all of the responses.I've gone with the first solution from Eirikur as it did exactly what was required :-).
You are very welcome and thanks for the feedback.
😎
January 4, 2016 at 4:55 am
Thank you Mickey for this article, good Monday morning reading.
The part I find hard to agree with is "When to Use Scalar Functions", particularly when the example given can easily...
January 4, 2016 at 2:01 am
Jeff Moden (1/3/2016)
January 3, 2016 at 11:42 pm
Good job with the DDL and the sample data Raastarr, made this very quick and straight forward question to answer;-)
😎
There are few ways of doing this, here is the first...
January 3, 2016 at 2:11 pm
Timing the different methods using the previously posted test data set
😎
Test harness
-- TEST: Different ways of calculating duration
-- DATA SET: ...
January 3, 2016 at 8:01 am
This is not possible in this way, the over clause cannot be used with user defined functions.
😎
January 3, 2016 at 7:23 am
Jeff Moden (1/1/2016)
Eirikur Eiriksson (12/31/2015)
Careful here Jeff, the type cast to decimal is expensive, consider using float which does not need a type cast is less costly.
Understood. FLOAT only...
January 2, 2016 at 7:24 am
Viewing 15 posts - 4,096 through 4,110 (of 8,753 total)