Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,366 through 16,380 (of 59,101 total)

RE: How to use a CSV as parameter in a query

Henk Schreij (11/10/2016)
It's the company policy that the DB is used for storing the tables (with FK's including cascades, defaults). But no stored procedures or functions.
Yowch!. I did some...
--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)

November 10, 2016 at 5:46 am

#1911623
RE: Are the posted questions getting worse?

Lynn Pettis (11/9/2016)
Jeff, I actually excepted you to have some interesting comments about the code I emailed you, or didn't you get it?
Ah. sorry. I did see it 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)

November 9, 2016 at 8:39 pm

#1911524
RE: is it possible to determine the max length of a field in a csv file?

Alan.B (11/9/2016)
Jeff Moden (11/8/2016)
Alan.B (11/8/2016)
You can accomplish this using NGrams2B which can be downloaded from here[/url] at the end of the article.).
I must be tired and I'm not seeing...
--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)

November 9, 2016 at 8:36 pm

#1911523
RE: Are the posted questions getting worse?

Brandie Tarvin (11/9/2016)
Eirikur Eiriksson (11/9/2016)
No offence Jeff, just thought this was funny
😎
That is kind of funny.
Base 36 is f____g funny. 😉 Saw that when I was looking at 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)

November 9, 2016 at 5:06 pm

#1911518
RE: Random 64 Characters alphanumeric String

Eirikur Eiriksson (11/9/2016)
Jeff, have you been thinking about this for the last 7 years?
😎
Nah... just ran into the post. Just went through this in the company I work 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)

November 9, 2016 at 4:36 pm

#1911514
RE: Does the SQL Import wizard imports data in sequence?

halifaxdal (11/9/2016)
Jeff Moden (11/8/2016)
ZZartin (11/8/2016)
Yes it will process text files in line order, that is no guarantee however that they'll come out of a database table in that order. ...
--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)

November 9, 2016 at 7:30 am

#1911410
RE: How to use a CSV as parameter in a query

Henk Schreij (11/7/2016)
@"Quick question, how many parameter values do you expect in a single call?"
Not more then 5. It's the count of the Themes of the Trip.
The number of trips...
--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)

November 8, 2016 at 11:47 pm

#1911332
RE: Table valued fucntion or scalar valued function

sqlfriends (11/7/2016)
A further question, if function are not worked efficiently, why T_SQL has this table valued functions?
In which case we should create functions?
I can think of is for calculation, parse,...
--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)

November 8, 2016 at 11:37 pm

#1911331
RE: Finding Duplicates Across Columns

dec_obrien (11/8/2016)
Hi,
Yes, that works thanks. I think I need to find out why though: I haven't used CROSS APPLY before.
It's basically the same thing as a correlated subquery in 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)

November 8, 2016 at 11:30 pm

#1911330
RE: Does the SQL Import wizard imports data in sequence?

ZZartin (11/8/2016)
Yes it will process text files in line order, that is no guarantee however that they'll come out of a database table in that order. The line counter...
--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)

November 8, 2016 at 11:25 pm

#1911327
RE: is it possible to determine the max length of a field in a csv file?

halifaxdal (11/8/2016)
This has been discussed before but I couldn't find a case/answer that might apply to my situation:
From time to time I have raw data in text to be imported...
--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)

November 8, 2016 at 11:22 pm

#1911326
RE: is it possible to determine the max length of a field in a csv file?

Alan.B (11/8/2016)
You can accomplish this using NGrams2B which can be downloaded from here[/url] at the end of the article.).
I must be tired and I'm not seeing what you're talking...
--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)

November 8, 2016 at 11:10 pm

#1911324
RE: Random 64 Characters alphanumeric String

I know this is a really old thread but, to avoid building a random foul word generator, there's an easy method to do this.
SELECT REPLACE(CONVERT(CHAR(36),NEWID())+CONVERT(CHAR(36),NEWID()),'-','')
p.s. This does sound like...
--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)

November 8, 2016 at 11:01 pm

#1911323
RE: how to pick the first file first from specific folder using for each in SSIS

drew.allen (11/8/2016)
The files are processed in alphabetical order. If you follow the naming convention of having a fixed filename prefix with a timestamp suffix in YYYYMMDDHHMMSS order they will...
--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)

November 8, 2016 at 2:04 pm

#1911293
RE: Big data: transfer x-number of rows per batch?

Sergiy (11/7/2016)
Jeff Moden (11/7/2016)
Sergiy (11/2/2016)
The fastest data transferring channel is a truck loaded with DVD's
:hehe:
Or an overnight care package with a monster hard disk in it. 😀 Did 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)

November 8, 2016 at 6:40 am

#1911173

Viewing 15 posts - 16,366 through 16,380 (of 59,101 total)