Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,036 through 10,050 (of 59,102 total)

RE: SQL Query Help - PIVOT or CROSS APPLY?

amy26 - Thursday, January 17, 2019 8:20 PM
Hi, I have a dataset that looks like this:

CREATE TABLE [dbo].[PivotData](
[PayPlan] [nvarchar](255) NULL,
[CategorySubGroupCode]...
--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)

January 17, 2019 at 8:51 pm

#2019317
RE: Why do we use SQL limitations? Which constraints can we use while making a database in SQL?

Sue_H - Thursday, January 17, 2019 4:01 PM
drew.allen - Thursday, January 17, 2019 1:15 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)

January 17, 2019 at 7:43 pm

#2019314
RE: T-SQL Multiple Rows into One Row

SQL Espo - Wednesday, January 16, 2019 11:16 AM
I have the following rows
UserShiftID
--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)

January 16, 2019 at 7:25 pm

#2019175
RE: T-SQL Multiple Rows into One Row

drew.allen - Wednesday, January 16, 2019 1:17 PM
patrickmcginnis59 10839 - Wednesday, January 16, 2019 12:45 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)

January 16, 2019 at 7:18 pm

#2019174
RE: Large Suspect Database

Luke L - Wednesday, January 16, 2019 2:49 PM
In the end as we were heading toward the end of the business day,...
--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)

January 16, 2019 at 7:04 pm

#2019173
RE: Fun with Dates and Times

bdcoder - Wednesday, January 16, 2019 8:32 AM
I have been programming for over 40 years now and for the life of me...
--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)

January 16, 2019 at 6:49 pm

#2019172
RE: Session stuck in killed\roll back

Feivel - Wednesday, January 16, 2019 12:15 PM
Jeff Moden - Wednesday, January 16, 2019 8:49 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)

January 16, 2019 at 5:52 pm

#2019169
RE: Run New PowerShell Process As A Different User

Coozie - Wednesday, January 16, 2019 6:44 AM
Summary:
I'm trying to automate a process.
In the process I create sql credentials and 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)

January 16, 2019 at 5:49 pm

#2019168
RE: Session stuck in killed\roll back

This sound symptomatic of a problem we had last year. Simple SELECTs getting stuck and going into a KILLED/ROLLBACK that couldn't be killed. It crippled us a couple 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)

January 16, 2019 at 8:49 am

#2019104
RE: split text into rows: The maximum recursion 100 has been exhausted before statement completion

Jonathan AC Roberts - Wednesday, January 16, 2019 6:40 AM
marc.corbeel - Wednesday, January 16, 2019 6:14 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)

January 16, 2019 at 8:10 am

#2019092
RE: Fun with Dates and Times

mark.edwards-1115881 - Wednesday, January 16, 2019 7:29 AM
This whole date thingy ought to be a lot simpler than all what this rhetoric...
--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)

January 16, 2019 at 7:43 am

#2019085
RE: Fun with Dates and Times

Jerry Kelk - Wednesday, January 16, 2019 7:05 AM
Maybe so. My point, perhaps poorly made, was that it's not stored 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)

January 16, 2019 at 7:10 am

#2019078
RE: Why do we use SQL limitations? Which constraints can we use while making a database in SQL?

agrawalanjita123 - Wednesday, January 16, 2019 5:05 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)

January 16, 2019 at 6:46 am

#2019071

RE: Are the posted questions getting worse?

Lynn Pettis - Tuesday, January 15, 2019 10:35 PM
Not sure the hospital would approve and he hasn't had alcohol in 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)

January 16, 2019 at 6:41 am

#2019067

RE: Fun with Dates and Times

Jerry Kelk - Wednesday, January 16, 2019 6:17 AM
They are always stored as a long decimal. It's about how you choose...
--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)

January 16, 2019 at 6:36 am

#2019065

Viewing 15 posts - 10,036 through 10,050 (of 59,102 total)
Prev
1
2
3
…
669
670
671
…
3,939
3,940
3,941
Next