Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,771 through 31,785 (of 59,099 total)

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

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 drive a sugar-ant's mino-bike...
--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 5:53 pm

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

With a bit of dynamic SQL to interogate the schemas, you could create a view that looks like the following...
SELECT columnlist
FROM companyx.Activities
UNION ALL
...
--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 5:42 pm

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

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". Here's a description...
--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 5:18 pm

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

hxkresl (12/4/2011)
The column status returned was: "The value violated the integrity constraints for the column.".
Will you please give me some idea why?
Any nulls in the data? Does 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 5:09 pm

#1416446
RE: Reverse Treeview

Alan Stanley (10/19/2011)
Jeff
I mentioned that there were too many recursions using a second cte, and ordering the tree was nigh on impossible.
Heh... who said anything about using CTEs, especially recursive...
--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 3:34 pm

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

Sarath Vellampalli (5/7/2007)
i want to add one new column in the destination table at package runtime.
Even in the world of ETL, never mind that of an RDBMS, this is normally...
--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 3:08 pm

#1416441
RE: T SQL to track changes

snigdha.mishra190 (12/4/2011)
Hi,
I have a requirment which i have never worked on and need some help to proceed.
I have a list of cutomers with their effective date and exp date for...
--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 2:31 pm

#1416439
RE: No Overtime

dg81328 (12/4/2011)
Overtime abuse is definable as free hourly labor. If you agree to a salary of 100K and a 40 hour week the employer can legally assume a 60 hour...
--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 2:21 pm

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

bitbucket-25253 (12/4/2011)
I searched the archives for this and could not find a solution.
I have a comment table and would like to get a word count.
Are you aware of SQL Server's...
--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 2:15 pm

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

texpic (12/3/2011)
I searched the archives for this and could not find a solution.
I have a comment table and would like to get a word count.
So for example, if comment #1...
--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 2:11 pm

#1416436
RE: Dropping and restoring DB to fix file fragmentation

My apologies. I'm not sure if the "DROP EXISTING" will cause the problem with FKs. I mistook you to mean that you were doing explicit drops. Using...
--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 12:45 pm

#1416435
RE: Execute As

califny (11/27/2011)
Hi, I follow the steps on 2008R2. When I execute
EXECUTE AS LOGIN = 'ApplicationUser'
I got error:
Cannot execute as the server principal because the principal "ApplicationUser" does not exist,...
--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 11:51 am

#1416434
RE: Adding a column alias to be the field name in a new table

patrickmcginnis59 (11/28/2011)
Jeff Moden (11/27/2011)
...There should only be one an only one column in common between the two and that should be the SalesOrderID...
In my experience, SQL Server doesn't enforce unique...
--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 11:47 am

#1416433
RE: Last day of Month

Post withdrawn... Books Online was totally wrong about what would happen on something and I'm testing more on the subject of datatype precedence.
--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 11:10 am

#1416430
RE: Last day of Month

Post withdrawn... Books Online was totally wrong about what would happen on something and I'm testing more on the subject of datatype precedence.
--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 10:35 am

#1416428

Viewing 15 posts - 31,771 through 31,785 (of 59,099 total)