Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,681 through 25,695 (of 59,099 total)

RE: Convert comma to single quotes

sqlfriends@sql.com (8/17/2012)
I want to convert the column like as
Sometimes a better solution can be made if we know the reason why you would want to do such a thing....
--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)

October 9, 2013 at 8:28 pm

#1657366
RE: import string with array into table

dwain.c (10/9/2013)
And it can't split comma delimited strings as fast as DelimitedSplit8K.
As you said in your fine article, it's only because it was designed to do just one thing but...
--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)

October 9, 2013 at 8:22 pm

#1657363
RE: import string with array into table

dwain.c (10/9/2013)
Jeff Moden (10/9/2013)
Mike Saunders NL (10/7/2013)
Hello again,
I am running into a problem importing a string containing an array into a table.
My string looks like '[{mark,peters,mr}{jane,fonda,mrs}{john,doo,mr}{james,bond,mr}]'
I want to import this...
--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)

October 9, 2013 at 8:19 pm

#1657362
RE: import string with array into table

Mike Saunders NL (10/7/2013)
Hello again,
I am running into a problem importing a string containing an array into a table.
My string looks like '[{mark,peters,mr}{jane,fonda,mrs}{john,doo,mr}{james,bond,mr}]'
I want to import this into a temp...
--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)

October 9, 2013 at 5:37 pm

#1657345
RE: BCP through XP_CMDSHELL not responding

diegoanckizes (10/9/2013)
That thing:
EXEC('EXEC MASTER..XP_CMDSHELL ''BCP "SELECT * FROM [[db]]..[table]" QUERYOUT "C:\Users\processos\teste\TESTE.TXT" -t; -r -c -CRAW -U[user] -P[[pass]]''')
TY
You dont' need the double EXEC and you don't need the doubled-up brackets.
EXEC...
--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)

October 9, 2013 at 5:08 pm

#1657342
RE: Query taking over 50 mins; Stuff with XML Path

Eshika (10/9/2013)
Bellow is the code:
I think maybe not. The "C" derived table doesn't have the "townlist" column that have you in the update list. Also, why are you...
--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)

October 9, 2013 at 5:00 pm

#1657341
RE: BCP through XP_CMDSHELL not responding

Can you post the xp_CmdShell call that you're using, please? I have a couple of ideas on the problem but I need to see that command. If it'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)

October 9, 2013 at 3:51 pm

#1657331
RE: BCP through XP_CMDSHELL not responding

diegoanckizes (10/9/2013)
Hi.
I'm trying to create a file from a query executing xp_cmdshell with BCP command, but it does not finish. No error messages are shown. It keeps executing query forever....
--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)

October 9, 2013 at 11:38 am

#1657247
RE: Query taking over 50 mins; Stuff with XML Path

Eshika (10/9/2013)
Hi I am using Stuff with XML Path for concatenating the data in multiple columns like city, town etc by Zip code. ie., unique column is Zip and 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)

October 9, 2013 at 11:36 am

#1657245
RE: Number of files for database MDF

PiMané (10/9/2013)
Some queries use UNIONs between two large tables. If on table was on PRIMARY FILEGROUP and the other table on my extra FILEGROUP would there be any advantage?
Unless you...
--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)

October 9, 2013 at 11:29 am

#1657243
RE: split a comma delimited string into columns

mynkdby (10/9/2013)
Jeff Moden (10/6/2013)
J Livingston SQL (10/6/2013)
Hello
please see some code (still work in progress) below
the idea is to strip a csv column into separate columns:
the number of columns is indeterminate...
--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)

October 9, 2013 at 8:03 am

#1657166
RE: Beginner, Expert, or Both?

Matt Miller (#4) (10/8/2013)
While I don't necessarily disagree with the discussion - it's important to remember that complex is often a point of view. Jeff , what you call...
--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)

October 8, 2013 at 10:40 pm

#1656984
RE: Update script

dwain.c (10/8/2013)
The elephant on the carpet here of course is that the next statement in line is going to be:
EXEC (@UpdateScript)
And that is going to be highly prone to SQL...
--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)

October 8, 2013 at 8:33 pm

#1656976
RE: how to update column city value from 'A' to 'B' and 'B' to 'A' in single query

Tom Bakerman (10/8/2013)
It seems we've moved into the "Dating Your Employer" thread 🙂
Seems only natural... the original post was an interview 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)

October 8, 2013 at 3:47 pm

#1656934
RE: Beginner, Expert, or Both?

logitestus (10/8/2013)
I run into this type of problem everywhere I have worked. Someone states "this is the way to do it" because they saw X% faster performance. As...
--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)

October 8, 2013 at 3:36 pm

#1656932

Viewing 15 posts - 25,681 through 25,695 (of 59,099 total)