Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,556 through 21,570 (of 59,098 total)

RE: Trimming Additional , at the end in csv

venkyzrocks (2/13/2015)
Hi Jeff,
Looks like a sql statement. What data flow transformation in SSIS would I use for this ?
Thanks,
V
My apologies. I read the title of the post and...
--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)

February 13, 2015 at 4:50 pm

#1777635
RE: Trimming Additional , at the end in csv

venkyzrocks (2/13/2015)
Hi ,
Some user csv's have an additional , at the end of each row. How can I trim it before the csv gets processed through the other process.
I read...
--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)

February 13, 2015 at 2:17 pm

#1777615
RE: Next Business Day

Sangeeth878787 (2/13/2015)
Hi,
[font="Arial Black"]I wrote a function,[/font] which gives the next working day with by looking into holiday table for one country. But I am not able to succeed to back...
--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)

February 13, 2015 at 1:52 pm

#1777607
RE: Are the posted questions getting worse?

WayneS (2/13/2015)
Brandie Tarvin (2/13/2015)
Gail and Jeff, I really want to thank you for your input on the SQL Server licensing issue. Not only were we able to get Developer edition...
--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)

February 13, 2015 at 10:57 am

#1777593
RE: Split single row into multiple rows based on column value (quantity)

Heh... it doesn't matter. MS reserves the right to change anything at any time.
If you follow what a lot of folks say, they recommend avoiding undocumented or...
--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)

February 12, 2015 at 8:48 pm

#1777400
RE: HOW TO ARCHIVE AND DELETE OLD RECORD IN A TABLE THAT HAS NO DATE COLUMN

deebabat (2/4/2015)
I have these two tables Log and CategoryLog, I need to archive records older than 13 months in these two tables to two separate tables and then delete 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)

February 12, 2015 at 8:19 pm

#1777396
RE: Please Help Improve My While Loop

Byzza (2/4/2015)
Hi All,
Thanks for the responses so far. I can't really do any kind of joins, is because I need to be able to allocate manufacture order qty's 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)

February 12, 2015 at 8:12 pm

#1777395
RE: chainging isloation level with in the sesssion after closing first tran is correct or not

Did you ever figure out an answer to this question?
--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)

February 12, 2015 at 7:57 pm

#1777392
RE: DATEDIFF values are different for exactly same MiliSeconds

So the question that remains is... do you need it to? Are you actually trying to calculate and display a duration?
--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)

February 12, 2015 at 7:49 pm

#1777391
RE: Copy multiple CSV files into database using stored proc , Need to Create new databases everytime

CooLDBA (2/9/2015)
Using SSIS
Or not. 😉
--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)

February 12, 2015 at 7:45 pm

#1777390
RE: Copy multiple CSV files into database using stored proc , Need to Create new databases everytime

nikki123 (2/9/2015)
hi
I need to import multiple csv files and load into table and everytime new database has to be created .
I was able to create new databases 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)

February 12, 2015 at 7:44 pm

#1777389
RE: Extract substring in SQL Statement

Tamrak (2/12/2015)
I tried to extract the information in a field
Samples of the data:
"Current Date updated ( 12/31/2015 -> 12/31/2016 )"
"Status updated ( Open -> Should be Closed )"
From example 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)

February 12, 2015 at 7:33 pm

#1777388
RE: What are First Steps for a dba in new Office?

jeffrey yao (2/12/2015)
I will first try to understand the environment I will manage, such as how many sql instances, SSAS/SSRS/SSIS instances I need to take care of, what are their...
--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)

February 12, 2015 at 5:17 pm

#1777379
RE: What are First Steps for a dba in new Office?

Megistal (2/12/2015)
IMHO I follows theses:
1- The DBA job was posted for a business reason. What it is? What management worries the most right now from their own eyes.
2- Next depending...
--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)

February 12, 2015 at 5:16 pm

#1777378
RE: Query Causing Blocking, Locks Table for 1000 Seconds, Help Needed!

I'm thinking that the following from the original code could be the real problem here. Dunno for sure because I don't know the data but it would be one...
--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)

February 12, 2015 at 5:05 pm

#1777377

Viewing 15 posts - 21,556 through 21,570 (of 59,098 total)