Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,566 through 14,580 (of 59,097 total)

RE: How to do incremental loading without date filters

upendar.dilytics - Tuesday, August 22, 2017 6:39 AM
We need to load the data which is inserted or updated in last four days...
--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)

August 22, 2017 at 9:16 am

#1956189
RE: Spreading monthly inserts to weekly grain

Matthew Cushing - Tuesday, August 22, 2017 8:40 AM
My apologies, I appreciate you getting back to me with so little to work...
--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)

August 22, 2017 at 9:02 am

#1956186
RE: Send and save a copy of an email (as .msg)

Thom A - Tuesday, August 22, 2017 8:49 AM
Jeff Moden - Tuesday, August 22, 2017 8:37 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)

August 22, 2017 at 8:58 am

#1956184
RE: Send and save a copy of an email (as .msg)

Thom,
I'm not sure where you'd set it up but couldn't you simply build a special email address for Outlook, setup a folder for each customer within Outlook that would...
--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)

August 22, 2017 at 8:37 am

#1956180
RE: Send and save a copy of an email (as .msg)

Grant Fritchey - Tuesday, August 22, 2017 5:21 AM
Flat out, they're asking for crazy stuff.
Heh... to coin a phrase... "If you...
--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)

August 22, 2017 at 8:34 am

#1956179
RE: Fill in missing gaps on intergers

Geoff A - Tuesday, August 22, 2017 8:12 AM
Jeff Moden - Tuesday, August 22, 2017 8: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)

August 22, 2017 at 8:16 am

#1956172
RE: Fill in missing gaps on intergers

I had forgotten that I was doing some experiments with the function and that the E16 line had been changed to "only" go to "E12" size. It won't affect 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)

August 22, 2017 at 8:15 am

#1956171
RE: Fill in missing gaps on intergers

Geoff A - Tuesday, August 22, 2017 8:02 AM
we are running Dynamics AX 2012 for Retail here. (all in azure but that...
--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)

August 22, 2017 at 8:05 am

#1956167
RE: Fill in missing gaps on intergers

Geoff A - Tuesday, August 22, 2017 7:42 AM
thanks Jeff. Much appreciated. Will you be in Seattle this year? we could catch...
--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)

August 22, 2017 at 7:51 am

#1956163
RE: Fill in missing gaps on intergers

Hi Geoff. Long time no see.
First, create this function. It's a "programmable" Tally function.

CREATE FUNCTION [dbo].[fnTallyProg]
/**********************************************************************************************************************
Purpose:
Given a start value, 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)

August 22, 2017 at 7:32 am

#1956153
RE: How to reduce the space /shrink SQL Server 2008 R2 Data file (MDF) and Log file (LDF)

srik18 - Monday, August 21, 2017 5:58 AM
Jeff Moden - Sunday, August 20, 2017 9:34 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)

August 21, 2017 at 8:48 pm

#1956075
RE: Trying to create function to create folders (and sub folders)

If you don't mind a little help from "undocumented code", the following will easily do exactly what you want. This is what SQL Server uses to make directories for backups. ...
--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)

August 21, 2017 at 2:04 pm

#1956061
RE: Hiring Heterogeneously

djackson 22568 - Monday, August 21, 2017 8:50 AM
Jeff Moden - Monday, August 21, 2017 12:22 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)

August 21, 2017 at 12:24 pm

#1956044
RE: Hiring Heterogeneously

TomThomson - Sunday, August 20, 2017 7:09 PM
David.Poole - Thursday, August 17, 2017 4:03 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)

August 21, 2017 at 12:22 am

#1955944
RE: RAMDisk? Use it for TempDB?

JakDBA - Sunday, August 20, 2017 10:46 PM
Gail Wanabee - Wednesday, November 30, 2016 3:05 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)

August 21, 2017 at 12:20 am

#1955943

Viewing 15 posts - 14,566 through 14,580 (of 59,097 total)