Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,021 through 10,035 (of 59,099 total)

RE: Number of employees active per date

jcelko212 32090 - Friday, January 18, 2019 2:48 PM
astrid 69000 - Thursday, January 17, 2019 1:20 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 18, 2019 at 4:17 pm

#2019432
RE: Dynamic pivot tables

ipawelkon - Friday, January 18, 2019 11:25 AM
Hi,
I want to eliminate all nulls average by week and display like this. I know...
--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 18, 2019 at 3:19 pm

#2019426
RE: User Defined Function for following scnario

vs.satheesh - Thursday, January 17, 2019 5:46 AM
Dear All,
In my scenario, i need to generate string like
AAA,AAB,AAC.........ZZZ
My input parameter is just Total...
--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 18, 2019 at 3:16 pm

#2019424
RE: Number of employees active per date

drew.allen - Friday, January 18, 2019 10:12 AM
Alan.B - Thursday, January 17, 2019 3: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)

January 18, 2019 at 3:13 pm

#2019423
RE: SQL Query Help - PIVOT or CROSS APPLY?

amy26 - Friday, January 18, 2019 7:23 AM
Ok thank you, its not just me that's hella confused by the request. The comments...
--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 18, 2019 at 8:05 am

#2019369
RE: Are the posted questions getting worse?

frederico_fonseca - Thursday, January 17, 2019 4:10 PM
Grant Fritchey - Thursday, January 17, 2019 12:48 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 10:40 pm

#2019329
RE: Job fails but Job History shows success

triloba - Thursday, January 17, 2019 12:36 PM
We had an undetermined network issue last night. Multiple database backup jobs (full & Trans...
--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 10:21 pm

#2019327
RE: Sessions blocked in chain loop

askcoffman - Thursday, January 17, 2019 4:02 PM
askcoffman - Thursday, January 17, 2019 2:11 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 10:16 pm

#2019326
RE: Sessions blocked in chain loop

Sue_H - Thursday, January 17, 2019 3:20 PM
askcoffman - Thursday, January 17, 2019 2:11 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 10:08 pm

#2019325
RE: Number of employees active per date

astrid 69000 - Thursday, January 17, 2019 1:20 PM
Hi,
I have a very simple table

create table #employee
(
EmpNumber int,
HireDate datetime,
TerminationDate datetime
)
insert into...
--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 9:44 pm

#2019323
RE: Number of employees active per date

Duplicated post deleted.
--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 9:43 pm

#2019322
RE: Performance Issue with Simple Query /Big Tables

You're trying to return more than 56 million rows to the screen. The machine you're doing the query from has simply run out of memory.
Also, 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)

January 17, 2019 at 9:01 pm

#2019319

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