Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,526 through 21,540 (of 59,072 total)

RE: Importing spreadsheet in one single column

SSMS_2007 (2/13/2015)
I am trying to import 1 spreadsheet to a database table. I am using SSMS export import wizard to import spreadsheet. My goal is to import whole spreadsheet 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)

February 13, 2015 at 5:56 pm

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

brad.mason5 (2/12/2015)
Hey Jeff,
I created a script that will store statistics of a stored procedure which has a parameter. This parameter has 9k distinct values that can be used. ...
--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 5:43 pm

#1777640
RE: Next Business Day

Sangeeth878787 (2/13/2015)
This is the exact requirement I need to do:
We have a requirement to show 'Business Day / Working Day ' as a output for the below input parameters
Input
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)

February 13, 2015 at 5:37 pm

#1777639
RE: Update statistics with large databases

Yes, there is a performance impact but not the way some would think. It can be much worse.
When would you expect auto-updates of statistics to occur? Yeah... that'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)

February 13, 2015 at 5:28 pm

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

Viewing 15 posts - 21,526 through 21,540 (of 59,072 total)