Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,016 through 18,030 (of 59,069 total)

RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

peter-757102 (3/24/2016)
@jeff Moden,
These are two new functions I like to see, with a broader scope then just string splitting (but they are suited for it).
If I had these I would...
--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)

March 24, 2016 at 8:45 am

#1867462
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

peter-757102 (3/24/2016)
Out of pure frustration I will comment my idea here as the connect site is completely and utterly broken for me (can't post or comment even after signing in).
Hopefully...
--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)

March 24, 2016 at 8:00 am

#1867429
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

mburbea (3/23/2016)
I 100% agree that without a guarantee of ordering, or an explicit item ordinal the function is not complete.
However, I want to reiterate that the function does perform...
--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)

March 24, 2016 at 7:49 am

#1867422
RE: parent/child relationships

scottcabral (3/22/2016)
for example, in the tables above you will see that Policy 100024 was a renewal of Policy UK120241 effective 11-1-2014. Policy 100024 was also renewed and became Policy 1007441...
--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)

March 23, 2016 at 8:56 am

#1867115
RE: The New Men of IT

Them: "Where do you see me in 5 years?"
Me (in my mind, not spoken): "Don't know, don't care, so long as it's not here because you lied on your...
--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)

March 23, 2016 at 8:39 am

#1867104
RE: Insert Stored Procedure Results Into New Table Without Using OPENQUERY

I've reported the fact that the rating for this article appears to have been deleted as has all of the discussion that used to be on this thread. It...
--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)

March 23, 2016 at 8:09 am

#1867089
RE: The Younger Generation

brannanliz (3/22/2016)
In college Database work was the last thing I wanted to do and SQL wasn't being taught yet. Databases sounded so boring. Then I needed a job, part time...
--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)

March 23, 2016 at 7:56 am

#1867083
RE: Looping and scalar value

drew.allen (3/22/2016)
I agree that there are cases where the order is important, but my point was that the number of cases is far smaller than most people think. Running...
--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)

March 23, 2016 at 6:50 am

#1867063
RE: Insert Stored Procedure Results Into New Table Without Using OPENQUERY

Damned Temp Tables... they're both the boon and the bane of stored procedures. :pinch:
--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)

March 22, 2016 at 11:15 am

#1866881
RE: Insert Stored Procedure Results Into New Table Without Using OPENQUERY

qbrt (3/22/2016)
Great read and thanks for taking the time to write it up and sharing.
Getting Jeff Moden's blessing and support is fantastic, as I value his opinions tremendously.
Thanks for 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)

March 22, 2016 at 9:05 am

#1866829
RE: Insert Stored Procedure Results Into New Table Without Using OPENQUERY

To quote Phil McCracken...
"SQL Spackle" is a collection of short articles written based on multiple requests for similar code or to share short methods for getting certain things done. These...
--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)

March 22, 2016 at 8:42 am

#1866808
RE: Looping and scalar value

drew.allen (3/21/2016)
Eirikur Eiriksson (3/21/2016)
kuopaz (3/21/2016)
I see, thanks. As it's scanning the tally table row-by-row from start to the predicate value, the order of N may be important in some cases...
--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)

March 22, 2016 at 7:51 am

#1866781
RE: 2014 SSMS - SA Account password changing on it's owm - how to get rid off this issue.

pradeep 69787 (3/21/2016)
Message
Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT:]
Message
Error: 18456, Severity: 14, State: 8.
It sounds to me that the application is...
--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)

March 22, 2016 at 7:44 am

#1866778
RE: Find a String in a String

quagmired (3/20/2016)
This is exactly what I'm talking about when I mention "cumbersome TSQL solution". For arbitrary 0s, I'd say a tally table would have to have over 2 billion records
That...
--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)

March 21, 2016 at 11:57 pm

#1866667
RE: The New Men of IT

Gary Varga (3/21/2016)
Jeff, do you have "BWAAA-HAAA!!!" assigned to a shortcut key?
No. Ran out of shortcut keys for "BS", "WTF", "NFW", "Seriously", and a couple of more. 🙂
--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)

March 21, 2016 at 2:16 pm

#1866609

Viewing 15 posts - 18,016 through 18,030 (of 59,069 total)