Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,321 through 31,335 (of 59,101 total)

RE: Table Names in 2 Part Naming Convention in Select List

Good idea, Paul. Thanks.
--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, 2012 at 6:54 am

#1439325
RE: Convert DATETIME, trim leading zeros

Thanks, Chrissy. I always like to know these types of things so I can help better. I appreciate the time you spent on the 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)

January 27, 2012 at 6:53 am

#1439324
RE: Please help :(

mithubhudolia (1/27/2012)
please reply me of my question only .
Thanks
Sure. Answer to your question... just modify code in the following article to work with days instead of months.
http://www.sqlservercentral.com/articles/Crosstab/65048/
--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, 2012 at 6:49 am

#1439321
RE: how write split function for this store procedure

er.sivaganesh (1/27/2012)
can u plz help me
Yes. Post an example of the actual data you want split and tell us how you want it split.
--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, 2012 at 6:45 am

#1439320
RE: Table Names in 2 Part Naming Convention in Select List

SQL Kiwi (1/26/2012)
Jeff Moden (1/26/2012)
The deprecation that I remember was based on using table names instead of alias names for column callout in the SELECT list. Like this...
SELECT...
--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 26, 2012 at 11:59 pm

#1439153
RE: Table Names in 2 Part Naming Convention in Select List

Thanks, Paul...
The deprecation that I remember was based on using table names instead of alias names for column callout in the SELECT list. Like this...
SELECT TableName.SomeColumnName
...
--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 26, 2012 at 11:47 pm

#1439144
RE: Convert DATETIME, trim leading zeros

Forgot to ask... Jared is correct on this. This type of formatting is usually relegated to the frontend code and I'm as curious as he. Why did 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)

January 26, 2012 at 8:16 pm

#1439120
RE: Convert DATETIME, trim leading zeros

Chrissy321 (1/26/2012)
Thanks! I wasn't aware of STUFF
You bet. We could have just as easily used SUBSTRING(expression,2,10) instead of STUFF for this but glad I could introduce you to 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)

January 26, 2012 at 8:15 pm

#1439119
RE: Convert DATETIME, trim leading zeros

Lynn Pettis (1/25/2012)
Jeff Moden (1/25/2012)
This should do it, Chrissy...
DECLARE @SomeExampleDate DATETIME;
SELECT @SomeExampleDate = '01/01/2012';
SELECT STUFF(REPLACE('/'+CONVERT(CHAR(10),@SomeExampleDate,101),'/0','/'),1,1,'')
Don't you just hate it when a simple solution is staring you 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)

January 26, 2012 at 8:10 pm

#1439118
RE: How to allow a non sysadmin to run a DTSX package

IIRC, the proxy account will only help folks when it comes to running a job. It won't help them with creating or editing a job.
--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 26, 2012 at 8:04 pm

#1439117
RE: SA for database ownership?

I'll second all of that, Elliott. I'll also add that I prefer that most things are in the "dbo" schema.
--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 26, 2012 at 6:13 pm

#1439107
RE: reducing DB size

Steve Jones - SSC Editor (1/25/2012)
True, you can use views of synonyms. That might work, although performance wouldn't be great.
For dev/test, it's probably fine.
I've not experienced any noticiable slowdowns with...
--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 26, 2012 at 8:49 am

#1438866
RE: How to modify $pshome PowerShell 2.0 variable so that it points to a different directory

opc.three (1/26/2012)
Jeff Moden (1/25/2012)
babatmanpub (1/25/2012)
Just for those who would like to change $pshome : you can do it here :
with regedit
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\PowerShell\1\PSConfigurationProviders\Microsoft.PowerShell]
"ApplicationBase"="c:\\Windows\\System32\\WindowsPowerShell\\v1.0"
Nicely done.
Shifting gears a bit (and no implications...
--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 26, 2012 at 8:40 am

#1438851
RE: USING TRY...CATCH WITH OPENROWSET...BULK

No... I don't believe there is.
However, if you use BULK INSERT instead of OPENROWSET, you can route all of the errors to an error file and import that, as well.
--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 25, 2012 at 10:25 pm

#1438567
RE: Help with a SELECT statement using GROUP and SUM

Sean Lange (1/25/2012)
raisleger (1/25/2012)
Pretty close, but the "Total" column is incorrectly valued with "6" versus the expected "12" (5 + 1 + 4 + 2).
Any additional ideas?
CardType ...
--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 25, 2012 at 10:16 pm

#1438565

Viewing 15 posts - 31,321 through 31,335 (of 59,101 total)