Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,536 through 14,550 (of 59,097 total)

RE: Dynamic pivot and calculating total and ordering the total

Heh... bit of a long day for me. Just getting back from work. Glad you folks sussed it. Nice job, Thom!
--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)

August 23, 2017 at 11:27 pm

#1956545
RE: Interactive sorting by calculated column percentage

lucaskhall - Wednesday, August 23, 2017 11:29 AM
I am trying to add an interactive sort to a table using an expression 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)

August 23, 2017 at 4:51 pm

#1956515
RE: Potential presentation idea: What a cookbook can teach us about programming

Kevin3NF - Wednesday, August 23, 2017 11:33 AM
I can burn water....
Heh... funny that you should mention that. The monopropellant fuel that my...
--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)

August 23, 2017 at 4:46 pm

#1956514
RE: SQL Server - It's not really a Mailer Service, is it?

My humble opinion is that, as with all else, "It Depends".
I agree that SQL Server is an expensive product and it's a shame to turn it into an...
--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)

August 23, 2017 at 4:31 pm

#1956513
RE: Data flow concept - Thoughts wanted

Tom_Hogan - Wednesday, August 23, 2017 1:59 PM
Orlando Colamatteo - Wednesday, August 23, 2017 1:12 PM
--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)

August 23, 2017 at 4:13 pm

#1956509
RE: Data flow concept - Thoughts wanted

Tom_Hogan - Wednesday, August 23, 2017 7:11 AM
In the meantime, we have an intern manually loading the text files to staging...
--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)

August 23, 2017 at 3:52 pm

#1956507
RE: Send and save a copy of an email (as .msg)

Thom A - Wednesday, August 23, 2017 1:37 AM
Jeff Moden - Tuesday, August 22, 2017 7:44 PM
--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)

August 23, 2017 at 8:39 am

#1956401
RE: Dynamic pivot and calculating total and ordering the total

I'm thinking that this is actually a pretty easy thing to do using a CROSS TAB with ROLLUP and a bit of SQL prestidigitation with pre-aggregation, the summing of times,...
--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)

August 23, 2017 at 8:34 am

#1956397
RE: Best Approach For Junction Table Mainrenace

vincentshanecurtis - Tuesday, August 22, 2017 10:35 PM
Thanks for the reply. You actually hit on another question I had yet to research,...
--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)

August 22, 2017 at 11:03 pm

#1956291
RE: SQL Update with Subquery

Seems like this is becoming more and more common and I don't get it. Why do people ask a question and then never come back when people ask for clarification?
--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)

August 22, 2017 at 10:25 pm

#1956284
RE: Function quick...where clause not :(

Vets5 - Tuesday, August 15, 2017 2:00 AM
Hi,
I have a function which returns a table really quickly but when I add 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)

August 22, 2017 at 10:22 pm

#1956283
RE: Best Approach For Junction Table Mainrenace

I know it's an old post but consider an "On Cascade Delete" key or a "Delete" trigger for the DELETEs..
--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)

August 22, 2017 at 10:19 pm

#1956282
RE: export data to Excel using sql stored procedure

polo.csit - Tuesday, April 11, 2017 7:39 AM
I'm having a Sql Table which contains 1000 records...Now i want to export this records...
--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)

August 22, 2017 at 10:10 pm

#1956279
RE: Practical usage of SQLCLR: Building QueryToHtml function

Darko Martinovic - Tuesday, June 6, 2017 11:22 AM
the sqlist - Tuesday, June 6, 2017 8:34 AM
--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)

August 22, 2017 at 10:06 pm

#1956278
RE: Practical usage of SQLCLR: Building QueryToHtml function

Darko Martinovic - Tuesday, June 6, 2017 12:49 AM
Sergiy - Monday, June 5, 2017 5:50 AM
--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)

August 22, 2017 at 9:47 pm

#1956276

Viewing 15 posts - 14,536 through 14,550 (of 59,097 total)