Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,206 through 35,220 (of 59,102 total)

RE: Convert columns as rows

lefrancisco1 (1/28/2011)
Folks,
I have three subqueries i made them as single and returned three columns as a|b|c
now i need to changes this into single rows
as
a
b
c
need urgent help
Does...
--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 1, 2011 at 7:22 am

#1280919
RE: Surely there is a way to import CSV data in this situation?

Do you remember when all this text qualified CSV stuff that everyone has a problem with used to be child's play if not a touch slow? 😉
--===== Setup the Jet...
--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)

January 30, 2011 at 7:55 pm

#1280233
RE: Critique - The Modern Resume

Gosh... I understand about the title but it still sounds like a class on how to write a resume rather than how to build a resume if you understand 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)

January 30, 2011 at 7:07 pm

#1280230
RE: Can anybody give a hand with this?

joelvillegas (1/25/2011)
Ok thks jeff for the suggestion ill try that today, anyway i forgot to upload the files yesterday, i've just done it....its a link because for some reason i...
--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)

January 30, 2011 at 6:40 pm

#1280229
RE: Difference between AND & WHERE IN a QUERY ---- PLz reply

Henry Treftz (1/25/2011)
The best way to find potential performance differences between queries is to look at the estimated and actual plans using management studio.
Oh... be careful, now. You simply...
--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)

January 29, 2011 at 10:09 am

#1280094
RE: Are the posted questions getting worse?

Dave Ballantyne (1/27/2011)
Jeff Moden (1/26/2011)
Ah... sorry. I got a little behind on the thread. I see you already have enough volunteers to help.
Ill Pencil you in for Ver2...
--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)

January 29, 2011 at 9:25 am

#1280091
RE: .mdf / .bak / .ldf

athma (1/24/2011)
.ldf is a log file its not a transaction log backup,it will be created automatically when the database is created.
.mdf is a primary data file it will b created...
--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)

January 29, 2011 at 9:18 am

#1280088
RE: Any way to hide column names from result set?

puja63 (1/28/2011)
Has anyone post a solution to this?
I have the same issue that when I execute a stored procedure, thro a sql job via sql agent, I get the output...
--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)

January 29, 2011 at 9:13 am

#1280087
RE: Any way to hide column names from result set?

Lynn Pettis (2/25/2009)
jcrawf02 (2/25/2009)
SET NOCOUNT OFF before your SELECT will get rid of the rows affected. Not sure about the dashes, somebody else posted about that here recently, don't know...
--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)

January 29, 2011 at 9:11 am

#1280086
RE: Formatting Dates with 3 Character Months (SQL Spackle)

william-700725 (1/27/2011)
[font="Courier New"]About time somebody pointed out the convenience of the standardized formats. I've been using UCASE( CONVERT( char ( 11 ) , GETDATE() , 106 ) ) to create...
--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)

January 27, 2011 at 11:35 am

#1279272
RE: Display More Than 8000 Characters (SQL Spackle)

thisisfutile (1/27/2011)
nadabadan (1/27/2011)
...you will get 11 rows instead of the expect 10.
In the article, Jeff stated "I don't really care where the line "wraps", nor do I care about trailing...
--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)

January 27, 2011 at 11:20 am

#1279258
RE: Display More Than 8000 Characters (SQL Spackle)

nadabadan (1/27/2011)
"t.N BETWEEN 1 AND LEN(@LongString)/@length+1" would list an extra blank row where LEN(@LongString) is a multiple of @length.
DECLARE @longString varchar(max)
DECLARE @val varchar(max)
SET @val = 'abcdefgh'
SELECT @longString = REPLICATE(...
--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)

January 27, 2011 at 11:11 am

#1279252
RE: Display More Than 8000 Characters (SQL Spackle)

bitbucket-25253 (1/27/2011)
Jeff thanks again, going to be adding it to my tool box. Now wondering if that tool box should be renamed as "ToolboxbyJeffModen"
Yes I know the articles...
--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)

January 27, 2011 at 10:54 am

#1279240
RE: Display More Than 8000 Characters (SQL Spackle)

thisisfutile (1/27/2011)
nigel. (1/27/2011)
Thanks Jeff, nice article.
Spotted a minor typo in the first code example, has SliceDate instead of SliceData for the column alias.
I know it has no real...
--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)

January 27, 2011 at 10:44 am

#1279230
RE: Display More Than 8000 Characters (SQL Spackle)

dave.clark (1/27/2011)
Thanks for the excellent info!
I tackled this issue myself previously, but my solution is not quite as "simple" 😉
I'll have to test this and see if I can...
--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)

January 27, 2011 at 10:37 am

#1279222

Viewing 15 posts - 35,206 through 35,220 (of 59,102 total)