Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,356 through 17,370 (of 59,067 total)

RE: Practical Uses for Synonyms in SQL Server

MMartin1 (6/28/2016)
I am wondering about the three part naming convention and its substitution with a synonym. I envision a scenario where the code reads like
/* block 1*/
SELECT ...
FROM ProductionDB_test.dbo.tableA
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)

June 28, 2016 at 6:00 pm

#1887469
RE: Return string between 2 characters from the end of the string

manderson 20961 (6/28/2016)
Sorry guys my first post on here. I'll try to be better the next time. Thanks for all your help!
Understood. Please see the first link under "Helpful...
--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)

June 28, 2016 at 5:48 pm

#1887468
RE: SQL Server 2016 is Out and It's Fabulous!

Steve Jones - SSC Editor (6/28/2016)
Jeff Moden (6/25/2016)
From the Article:
“This doesn’t work like it used to.”
While I agree that it probably has fewer bugs that previous releases, 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)

June 28, 2016 at 5:19 pm

#1887465
RE: Reduce Log Database

angelreynosog (6/28/2016)
It is the same query , not wanting to send it twice
I don't believe you included the results from the SELECT that Gail pointed out.
--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)

June 28, 2016 at 4:40 pm

#1887462
RE: rows to columns

durga.palepu (6/28/2016)
Yet another good alternative to learn but little complex compared to pivot solution.
It depends. Did you read the article I recommended? Pivot doesn't do so well 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)

June 28, 2016 at 4:37 pm

#1887461
RE: Update 1 of 3 tables based on parameter

ScottPletcher (6/28/2016)
Jeff Moden (6/28/2016)
David92595 (6/28/2016)
@jeff
Because I inherited this database and the person that made it thought in spreadsheets not relational tables.
@scott
Thank you! Are their any other good ways to stop...
--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)

June 28, 2016 at 4:13 pm

#1887459
RE: Update 1 of 3 tables based on parameter

David92595 (6/28/2016)
@jeff
If im going to hard code it wouldn't it just be easier (i.e. not having to create a view) to go with the IF @State = 'AZ'...
Its hard...
--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)

June 28, 2016 at 4:09 pm

#1887457
RE: Practical Uses for Synonyms in SQL Server

MMartin1 (6/28/2016)
aj2red (6/24/2016)
If you live in a universe where you control database and scheming naming conventions, then I imagine you don't need to synonyms.
However, I don't.
For example:
We have written multiple...
--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)

June 28, 2016 at 4:01 pm

#1887455
RE: Update 1 of 3 tables based on parameter

David92595 (6/28/2016)
@jeff
Because I inherited this database and the person that made it thought in spreadsheets not relational tables.
@scott
Thank you! Are their any other good ways to stop a sql injection?...
--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)

June 28, 2016 at 12:13 pm

#1887408
RE: Return string between 2 characters from the end of the string

Luis Cazares (6/28/2016)
Jeff Moden (6/27/2016)
Luis,
Quote the OPs post where he posted the data and you'll see that the spaces are not where you expect. The sub-fields within the column...
--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)

June 28, 2016 at 7:31 am

#1887286
RE: rows to columns

Charmer (6/27/2016)
The ReportDate values can be anything. I want dynamic.
Please see the following article for a simple method to make such reports dynamic.
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)

June 28, 2016 at 7:14 am

#1887277
RE: Update 1 of 3 tables based on parameter

David92595 (6/28/2016)
Hello,
I am trying to dynamically update a table (as much as possible) based on a parameter. However, because I'm trying to avoid SQL injection I'm hard coding the table...
--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)

June 28, 2016 at 7:02 am

#1887270
RE: Return string between 2 characters from the end of the string

Luis Cazares (6/27/2016)
I'm sorry, but that doesn't help. I need the column definition, apparently you're using a char column, but that's just a guess. Read the articles linked in my...
--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)

June 27, 2016 at 8:31 pm

#1887155
RE: Is there a function to format the date like this ?

mw112009 (6/27/2016)
YB:
This is not for display purposes.
It is for a TAB delimited file that goes to another company.
I am not sure why they can not handle dates in the mm/dd/yyyy...
--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)

June 27, 2016 at 8:16 pm

#1887153
RE: Drop the table and add the column

Sangeeth878787 (6/27/2016)
Hi,
I need to add new column to the table, for this requirement is move the data to temp table and drop the table and create the same table 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)

June 27, 2016 at 8:44 am

#1887068

Viewing 15 posts - 17,356 through 17,370 (of 59,067 total)