Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,156 through 22,170 (of 59,102 total)

RE: Faster way to populate number table variation with inline tally?

As always, the documentation is in the code. First, the run results.
OPERATION ...
--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 27, 2014 at 10:40 pm

#1766589
RE: NEED COLUMN NAMES FROM TABLE DYNAMICALLY

The following code will do it. It uses one form of dynamic SQL for most of it and another form for passing the impassible database name for the FROM...
--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 27, 2014 at 5:37 pm

#1766583
RE: Moving On

I read the title and went into a panic! Heh... don't scare us like that!
We have room on our electronic timesheets to make notes for each entry. 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)

December 27, 2014 at 3:45 pm

#1766582
RE: handle query

The answer would be to convert your string-based dates to real ones to get the date differentials and sums and then apply either a Cross Tab or Pivot to 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)

December 27, 2014 at 3:19 pm

#1766579
RE: Are the posted questions getting worse?

Lynn Pettis (12/27/2014)
GilaMonster (12/27/2014)
Grant Fritchey (12/27/2014)
Lynn Pettis (12/23/2014)
Okay, I have a question about PASS 2015. I can save a lot of money by registering for PASS 2015 now. ...
--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 27, 2014 at 3:03 pm

#1766578
RE: How to avoid Union/Union All?

Praxo (12/27/2014)
Limitation I was referring is from front end side, which as I mentioned generates the SQL dynamically. The front end is not having this framework and does not support...
--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 27, 2014 at 11:59 am

#1766569
RE: The Rich Rewards of Tuning SQL

jhgoodwin (12/26/2014)
Let's be clear here.
Any query that takes 30 hours to finish isn't poorly written. It's just broken. Yes, you fix that stuff.
My normal metric for a query...
--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 27, 2014 at 10:40 am

#1766567
RE: The Rich Rewards of Tuning SQL

jhgoodwin (12/26/2014)
No offense, but I think most of you are wearing rose colored glasses here.
Specifically, you have the following points backwards:
1) Failing to deliver a working product is guaranteed to...
--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 27, 2014 at 10:35 am

#1766566
RE: Restrict access to Database

Since you're using 2008, you could create a logon trigger that checks which application they're trying to logon from. You'll need to take some care because you could end...
--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 27, 2014 at 8:28 am

#1766558
RE: How to avoid Union/Union All?

Praxo (12/27/2014)
Using Union All is limitation and hence the problem.
This SQL is build dynamically by front end and it has limitation wherein it is not supporting Union All (views,...
--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 27, 2014 at 8:08 am

#1766556
RE: Order by month number in a group by

Just in case you need to sort month names in the correct order, please see the following article...
http://www.sqlservercentral.com/articles/T-SQL/71511/
--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 27, 2014 at 8:06 am

#1766555
RE: How to slect data from table ?

MMartin1 (12/26/2014)
Create a table valued function that returns the delimited string as a column in a table. Join whatever table you are working on to this table (valued function) 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)

December 26, 2014 at 4:27 pm

#1766529
RE: Getting back to SQL Server

rondebbs 48050 (12/26/2014)
Thanks for the info. I will get the developers edition. Should I start with 2012 or 2014? Is 2014 being adopted yet? I'll start...
--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 26, 2014 at 4:23 pm

#1766528
RE: Date Table

CELKO (12/26/2014)
It's all Betty Crocker's fault. 😉
Actually, Fanny Farmer's Cook book! Seriously. Her cookbook introduced the concept of using standardized measuring spoons and cups, as well as level measurement. She...
--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 26, 2014 at 4:19 pm

#1766527
RE: Date Table

CELKO (12/26/2014)
it's funny that you bring up the metric system. I remember doing some work concerning solar heat and I had a question. Someone on that particular forum...
--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 26, 2014 at 3:11 pm

#1766523

Viewing 15 posts - 22,156 through 22,170 (of 59,102 total)