Jeff Moden

Forum Replies Created

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

RE: Audit table

Chris Harshman - Tuesday, August 22, 2017 1:19 PM
the problem is this isn't so straightforward in SSIS as you might want it...
--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:29 pm

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

Thom,
I might have found the answer for you and, believe it or not and despite the fact that all of the original code in the examples at 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)

August 22, 2017 at 7:44 pm

#1956259
RE: Audit table

I notice this post is 2 weeks old and you never got an answer. I don't even know how to spell "SSIS" but I do think that this is 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)

August 22, 2017 at 9:35 am

#1956191
RE: Using The SQL Server Debugger

TheSQLGuru - Tuesday, August 22, 2017 7:35 AM
IMHO the SQL Server debugger is essentially useless. Which is a damn shame...
Heh... I actually...
--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:29 am

#1956190
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

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