Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,076 through 15,090 (of 59,097 total)

RE: COMPUTED COLUMN needing to retain value

John Mitchell-245523 - Thursday, May 4, 2017 2:34 AM
The value of a persisted column is calculated at select time, not at insert...
--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)

May 4, 2017 at 12:08 pm

#1941140
RE: There is insufficient system memory to run this query.

Robin35 - Thursday, May 4, 2017 8:17 AM
sorry, this is very old thread but I just got the same error...and we had...
--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)

May 4, 2017 at 11:54 am

#1941138
RE: Are the posted questions getting worse?

Ed Wagner - Wednesday, May 3, 2017 6:17 PM
Lynn Pettis - Wednesday, May 3, 2017 3:36 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)

May 4, 2017 at 7:16 am

#1941095
RE: Are the posted questions getting worse?

Brandie Tarvin - Thursday, May 4, 2017 6:24 AM
Jeff, I take it you weren't there by the time that month and year...
--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)

May 4, 2017 at 6:53 am

#1941086
RE: Are the posted questions getting worse?

Thom A - Thursday, May 4, 2017 3:18 AM
Beatrix Kiddo - Thursday, May 4, 2017 3:09 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)

May 4, 2017 at 6:27 am

#1941080
RE: Are the posted questions getting worse?

RandomEvent - Wednesday, May 3, 2017 7:56 AM
Tom_Hogan - Wednesday, May 3, 2017 7:38 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)

May 4, 2017 at 6:21 am

#1941077
RE: Why does this amended JOIN cause a syntax error.

Actually, I found a pretty decent explanation right here on SSC. Chris M did a good job of it.
https://www.sqlservercentral.com/Forums/FindPost1583604.aspx
--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)

May 3, 2017 at 9:16 pm

#1941029
RE: Why does this amended JOIN cause a syntax error.

sgmunson - Tuesday, May 2, 2017 12:19 PM
When I write queries, I simply am NOT willing to code ANY query using any...
--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)

May 3, 2017 at 8:54 pm

#1941028
RE: How to flatten a normalised hierarchy table?
j.gale1 - Tuesday, May 2, 2017 8:56 PM
I have an OrgChart table that looks something like this:
PositionCode PositionName ...
--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)
May 3, 2017 at 8:23 am

#1940902
RE: SQL help - help me write the SQL stmt

Jason A. Long - Monday, May 1, 2017 5:14 PM
Give this a try...

WITH
    cte_AddRN AS (
        SELECT
            t.admdt,
            t.dischdt,
            t.ID,
            RN = ROW_NUMBER() OVER...
--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)

May 2, 2017 at 4:23 pm

#1940806
RE: Converting output to horizontal

Stupid spam blocker killed the OPs last two posts.
Here's what the OP had posted.

Thanks Thom. That worked out nicely and I am just learning about pivots and unpivots....
--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)

May 2, 2017 at 3:16 pm

#1940793
RE: Are the posted questions getting worse?

Lynn Pettis - Tuesday, May 2, 2017 9:21 AM
Jeff Moden - Monday, May 1, 2017 4:10 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)

May 2, 2017 at 2:21 pm

#1940785
RE: Questions for me to ask during a job interview

Since it came up... I've seen many companies that try to make a DBA decision based on 1/2 hour interviews and those people are absolutely nuts. Yes, it IS easily...
--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)

May 2, 2017 at 1:50 pm

#1940776
RE: Export data in XML to import into Word

kevaburg - Tuesday, May 2, 2017 11:44 AM
Matt Simmons - Tuesday, May 2, 2017 8:32 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)

May 2, 2017 at 1:41 pm

#1940775
RE: Are the posted questions getting worse?

Lynn Pettis - Monday, May 1, 2017 3:28 PM
Some day, Jeff, we need to setup a Skype "interview" and see just how...
--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)

May 1, 2017 at 4:10 pm

#1940622

Viewing 15 posts - 15,076 through 15,090 (of 59,097 total)