Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,756 through 31,770 (of 59,099 total)

RE: How to add new column in SSIS Package at run time

Charmer (12/6/2011)
hxkresl (12/4/2011)
OK, thank you very much for replying!!!
so, I've changed my approach. I've manually added the column in source file and on destination sql table as smallint. ...
--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)

December 6, 2011 at 4:58 am

#1417233
RE: What, When and who? Auditing 101

I'll definitely wait for the other articles from Roy but, right now, I'm thinking I'll still with some good ol' fashioned, high performance audit triggers.
--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)

December 5, 2011 at 7:56 pm

#1417095
RE: How to add new column in SSIS Package at run time

hxkresl (12/5/2011)
Hi Jeff. Well, I thought my OLE DB output was overwriting destination table each time I ran the package but I was wrong. When I truncated 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)

December 5, 2011 at 7:52 pm

#1417094
RE: Splitting a Date range

Evil Kraig F (12/5/2011)
Jeff Moden (12/3/2011)
Evil Kraig F (12/1/2011)
Ugh, nasty. You need a row-repeater. Which means... To the TALLY!
BWAAA-HAAA!!!! Beer popsicles... Dust Bunnies... nicely done Tally Table...
--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)

December 5, 2011 at 7:50 pm

#1417092
RE: Calcation of Date difference

Not sure how you're going to get all of the dates anywhere, then, Krishna. And generating the dates using the Tally Table aren't really going to take but an...
--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)

December 5, 2011 at 7:48 pm

#1417091
RE: Make selection in the table in various schemas.

cristiano.testai (12/5/2011)
Thanks..
I did what I need.
That's cool. Would you mind sharing what you did? Two way street here... 😉
--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)

December 5, 2011 at 7:44 pm

#1417090
RE: SSRS- Needs to display All month

Ninja's_RGR'us (12/5/2011)
Jeff Moden (12/5/2011)
satheyaraaj.tamilmani (12/5/2011)
U vil try to pivot concept & Unpivot concept..
Uh huh... you might want to explain how that's going to work if you have data missing from...
--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)

December 5, 2011 at 5:22 am

#1416602
RE: What, When and who? Auditing 101

Kind of, Roy. It's not actually negatives with CT... I'd be more likely to call it a lack of positives. CT doesn't appear to actually audit, in...
--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)

December 5, 2011 at 5:16 am

#1416595
RE: How to add new column in SSIS Package at run time

Gosh, Helen... my apologies. I've reached the limit of my SSIS knowledge (which is quite small, actually) and don't know the answer to your latest problem. Hopefully, someone...
--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)

December 5, 2011 at 5:09 am

#1416591
RE: SSRS- Needs to display All month

satheyaraaj.tamilmani (12/5/2011)
U vil try to pivot concept & Unpivot concept..
Uh huh... you might want to explain how that's going to work if you have data missing from an entire time...
--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)

December 5, 2011 at 4:53 am

#1416582
RE: How to load the filename and the data from multiple text file using SSIS package at the same time?

Koen Verbeeck (12/5/2011)
Jeff Moden (12/4/2011)
deepakagarwalathome (12/4/2011)
I have never worked with SSIS but I need to work with it now!
If expert knowledge of SSIS were gasoline, I wouldn't have enough to...
--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)

December 5, 2011 at 4:41 am

#1416576
RE: Calculating interest query

Sorry... posted to the wrong thread... post removed.
--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)

December 4, 2011 at 8:19 pm

#1416465
RE: Count Words in Text Field and/or Column (frequency of use)

texpic (12/4/2011)
That tally table is neat. I'm going to try and figure out how to apply this to my table. It is about 300,000 rows.
Then you want 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)

December 4, 2011 at 7:49 pm

#1416464
RE: How to assign sql parameter with many values returned from SQL statement

Lynn Pettis (12/4/2011)
mos-prog (12/4/2011)
Sorry, but i face one problem as it is my first time i deal with Database Mail,
when i try to send the Email it give me error...
--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)

December 4, 2011 at 7:40 pm

#1416460
RE: How to assign sql parameter with many values returned from SQL statement

mos-prog (12/4/2011)
Jeff Moden (12/4/2011)
There are several methods to accomplish the same goal. If you lookup sp_send_dbmail in Books Online, you'll find a parameter for the sproc called "@Query". ...
--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)

December 4, 2011 at 7:36 pm

#1416459

Viewing 15 posts - 31,756 through 31,770 (of 59,099 total)