Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,966 through 13,980 (of 59,095 total)

RE: Need help on extracting to XML format - Solved

dcw8888 - Wednesday, October 18, 2017 11:39 AM
Hi,
I have the following table:
CREATE TABLE dbo.TimeTable (
WorkDate date,
EmpID int,
EmployeeName...
--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)

October 24, 2017 at 5:20 pm

#1965033
RE: FORMATting dates

Heh... and they say that 2 part naming of the date parts is difficult and non-obvious. 😉
--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)

October 24, 2017 at 5:19 pm

#1965032
RE: Session Scope with Temporary Tables and Dynamic SQL

Lynn Pettis - Tuesday, October 24, 2017 1:50 PM
Luis Cazares - Tuesday, October 24, 2017 11: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)

October 24, 2017 at 5:12 pm

#1965029
RE: Importing data reports data truncation in both EM and SSIS from multiple data sources

skeleton567 - Tuesday, October 24, 2017 7:42 AM
Jeff Moden - Monday, October 23, 2017 10: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)

October 24, 2017 at 5:05 pm

#1965027
RE: How Long Before Your Database Runs Out of Space?

Joe O'Connor - Tuesday, October 24, 2017 6:56 AM
Jeff Moden - Monday, October 23, 2017 8:07 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)

October 24, 2017 at 4:50 pm

#1965024
RE: Are the posted questions getting worse?

Grant Fritchey - Tuesday, October 24, 2017 6:39 AM
Ed Wagner - Monday, October 23, 2017 5:35 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)

October 24, 2017 at 7:43 am

#1964937
RE: Trying to speed up this 'GetWorkingDays' function.

lars.hesselberg 49028 - Tuesday, October 24, 2017 3:35 AM
Hi,
How about this approach:
DECLARE
--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)

October 24, 2017 at 7:30 am

#1964934

RE: Challenging string handling in T-SQL

Naveen J V - Monday, October 23, 2017 10:19 PM

Luis Cazares - Monday, October 23, 2017 7:18...

--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)

October 23, 2017 at 10:26 pm

#1964901