Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,366 through 22,380 (of 59,072 total)

RE: Running total

GrassHopper (11/25/2014)
Tried this:
Select groupid, [line number], [to]-[from] as ToFrom,
MAX([to]-[from]) over (partition by groupid
order by [line number]
rows between 1 Preceding
AND 1 preceding) as prevToFrom,
MAX([to]-[from]) over (partition by...
--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)

November 25, 2014 at 8:01 am

#1760822
RE: Running total

pietlinden (11/24/2014)
If you use windowing functions, this isn't that hard. Since I didn't understand how the create table/insert statements were related to your question, this is a somewhat generic...
--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)

November 25, 2014 at 7:56 am

#1760820
RE: Split out a field of comma separated values based on a unique code in the same row.

Koen Verbeeck (10/21/2014)
Take a look at this excellent splitter function by Jeff Moden[/url].
Thank you for the kudo, Koen. :blush:
--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)

November 24, 2014 at 10:10 pm

#1760690
RE: Split out a field of comma separated values based on a unique code in the same row.

@ Trawler,
Are you all set on this one?
--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)

November 24, 2014 at 10:09 pm

#1760689
RE: Split out a field of comma separated values based on a unique code in the same row.

greatrajani (11/24/2014)
hi!
kindly go through below link
http://msdn.microsoft.com/en-IN/library/ms178129.aspx
there is provision of bulk insert and bcp which is ultra fast in execution
Regards
Rajani Karthik
While I applaud the innovative thought, that would mean that you...
--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)

November 24, 2014 at 10:09 pm

#1760688
RE: What Counts for a DBA: Empathy

Louis Davidson (@drsql) (11/24/2014)
And yeah, cheap is not total cost of ownership for sure... Ask anyone who owned a Yugo 🙂
BWAAA-HAAA!!! Now THAT'S funny! 🙂
--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)

November 24, 2014 at 8:43 pm

#1760679
RE: Please help with Recursive CTE to get reversed people hierarchy

I just happen to have a beautiful test bed for such testing in my "Hierarchies on Steroids" articles. When I get the chance, I'll convert the rCTE in 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)

November 24, 2014 at 5:34 pm

#1760671
RE: Clustered index failed to build with Online=ON

haiao2000 (11/21/2014)
Here is my question. I have Enterprise version of SQL Server 2012 & SQL server 2008. I understand that Image/Text/NText is obsoleted and should not be used. 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)

November 24, 2014 at 5:28 pm

#1760670
RE: SQL DBA knowing user passwords

Markus (11/24/2014)
Jeff Moden (11/22/2014)
Markus (11/21/2014)
I just tired to have a squirrel user and one small dept. app. user test out the expire users password and it basically kills them as...
--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)

November 24, 2014 at 5:22 pm

#1760667
RE: Are the posted questions getting worse?

Evil Kraig F (11/24/2014)
Jeff Moden (11/24/2014)
Eirikur Eiriksson (11/24/2014)
Just a quick question to "the thread", am I missing something or is XML getting more popular? Just noticed that this topic on...
--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)

November 24, 2014 at 4:41 pm

#1760659
RE: T-SQL Development Standards

SQLRNNR (11/24/2014)
Jeff Moden (10/25/2008)
But, ya gotta be will to and have management's support to just say "NO" to bad code.
I completely agree. Standards mean nothing if you don't have...
--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)

November 24, 2014 at 4:25 pm

#1760656
RE: Are the posted questions getting worse?

andrew gothard (11/24/2014)
David Burrows (11/21/2014)
Well Jeff would have to employ GBAG (Glass By Agonizing Glass) or get an Overflow Exception 😀
Agreeable, surely?
Unless there's no designated driver, most assuredly.
--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)

November 24, 2014 at 4:15 pm

#1760651
RE: Are the posted questions getting worse?

swoozie (11/24/2014)
I got so used to 3rd party software and automation that I had originally set up years ago that when I came to a much more rudimentary environment I...
--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)

November 24, 2014 at 4:14 pm

#1760650
RE: Are the posted questions getting worse?

Eirikur Eiriksson (11/24/2014)
Just a quick question to "the thread", am I missing something or is XML getting more popular? Just noticed that this topic on the XML forum has proportionally...
--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)

November 24, 2014 at 4:11 pm

#1760647
RE: T-SQL Development Standards

Just to make sure that no one else falls upon that document, I've deleted it from my previous post. It's just too out of date and that item about...
--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)

November 24, 2014 at 4:05 pm

#1760644

Viewing 15 posts - 22,366 through 22,380 (of 59,072 total)