Forum Replies Created
Viewing 15 posts - 32,551 through 32,565 (of 59,099 total)
-
RE: How to save a query result in a readable format.
Jeff Moden (9/14/2011)
forsqlserver (9/13/2011)
Dear All, ThanksAs you know on servers excel doesn't exist.I have tried it option (Save to file) and saved in .rpt,.csv,.xls,.txt still finally it was opening on...
--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) -
RE: Import CSV File to SQL 2000
I believe I can make BULK INSERT work for this but... since you originally posted a file that ended in a partial line, you should first check with the provider...
--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) -
RE: MONTHS AND QUATER
komal145 (9/14/2011)
I HAVE TABLE SOMETHING LIKE THIS:CREATE TABLE #Parm_Filter
(
[Parm] [varchar](50) NULL,
[PRMLabel] [varchar](200) NULL,
[PRMValue] [varchar](200) NULL,
[PRMOrder] [int] NULL
)
WANT TO INSERT SOMETHING LIKE THIS:
PRMLabelPRMValueParmPRMOrder
January1Month1
February2Month2
March3Month3
April4Month4
May5Month5
June6Month6
July7Month7
August8Month8
September9Month9
October10Month10
November11Month11
December12Month12
1st1Quarter1
2nd2Quarter2
3rd3Quarter3
4th4Quarter4
Ummmm... I suggest that you tell us what...
--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) -
RE: Import CSV File to SQL 2000
diboy79 (9/14/2011)
this is screenshot for error:
That doesn't match any of the previous errors you listed. The error above is what you might get if part of the file got...
--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) -
RE: Import CSV File to SQL 2000
diboy79 (9/14/2011)
Jeff Moden (9/13/2011)Errors 2, 3, and 4 are caused by error 1. What delimiter ARE you trying to use for a row delimiter? I can tell 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) -
RE: Store all in one database instead of one prodcution database and one historic database
Steve Jones - SSC Editor (9/14/2011)
However the recovery time changes dramatically between 5GB and 45GB. It can be the difference between a bad delete being an inconvenience and an 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) -
RE: Are the posted questions getting worse?
Gosh... I still can't believe this is actually happening to me nor the number of posts and emails that I'd like to answer individually especially since that might help me...
--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) -
RE: Are the posted questions getting worse?
Steve Jones - SSC Editor (9/14/2011)
Congrats, Jeff! I'll owe you a beer at PASS.I'm definitely looking forward to THAT! It'll be good to see you again. This is...
--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) -
RE: Are the posted questions getting worse?
Jack Corbett (9/14/2011)
Congratulations to Jeff, well-deserved, although don't you call yourself a developer, not a DBA?:-DThat's actually spot-on, Jack. Yeah, I've got one foot in the "System DBA" camp...
--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) -
RE: Are the posted questions getting worse?
Grant Fritchey (9/14/2011)
mtillman-921105 (9/14/2011)
Grant Fritchey (9/14/2011)
You combined Jeff & FLOAT. You're going to get the lecture now about the evils of the DECIMAL data type. I'm sorry, but you've brought...--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) -
RE: Are the posted questions getting worse?
Jack Corbett (9/14/2011)
Grant,Defaulting all character columns to varchar or, even worse, nvarchar and then compounding it by using 255.
No statistics or index maintenance.
Then echoing just about everything else everyone...
--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) -
RE: Are the posted questions getting worse?
ALZDBA (9/14/2011)
jcrawf02 (9/14/2011)
Grant Fritchey (9/14/2011)
mtillman-921105 (9/14/2011)
Grant Fritchey (9/14/2011)
Changing the topic for a moment, I'd like to beg some ideas from the group, again.I'm tasked with writing another article. This 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) -
RE: Jeff Moden elected Exceptional DBA of 2011
WOW! I don't know what to say, folks! I still can't believe this actually happened (the award... not the dust bunny party)! I even got a reply...
--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) -
RE: What do you do when it's slow?
New designs for Pork Chop launchers.
Try breaking the world record for shooting cocktail olives out my belly button.
--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) -
RE: How to save a query result in a readable format.
forsqlserver (9/13/2011)
Dear All, ThanksAs you know on servers excel doesn't exist.I have tried it option (Save to file) and saved in .rpt,.csv,.xls,.txt still finally it was opening on my system...
--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)
Viewing 15 posts - 32,551 through 32,565 (of 59,099 total)