Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,196 through 18,210 (of 59,069 total)

RE: Mystery data type conversion

PHXHoward (3/4/2016)
The sys_updated_on column is datetime2(7)
I think that the suggestions to explicitly format the data that is going into the varchar(10) column will solve the problem. It is really...
--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)

March 4, 2016 at 11:54 am

#1863258
RE: Substring from RIGHT

John Mitchell-245523 (3/4/2016)
REVERSE the string, use SUBSTRING, and then REVERSE it again.
John
Got code?
--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)

March 4, 2016 at 11:50 am

#1863254
RE: programming within SELECT statement

etl2016 (3/4/2016)
thanks.
But, its a bit more programming, involving local-scoped variables, some Queries, some aggregation and a final result.
Can we say something like, SELECT col1, col2, (DECLARE local_variable INT; SET @local_variable...
--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)

March 4, 2016 at 11:49 am

#1863253
RE: How to create a Stored Procedure from this Code

Phil Parkin (3/4/2016)
If someone offered me the choice between
a) Modifying one long and complex piece of code, and
b) Modifying several small and well-organised pieces of code, where the function of...
--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)

March 4, 2016 at 11:47 am

#1863252
RE: Many conditions - best practice

Luis Cazares (3/3/2016)
Here's an example on how to work with iTVFs, actually 2.
For more information about iTVFs and how they compare with normal scalar functions, check this article written by...
--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)

March 4, 2016 at 7:44 am

#1863118
RE: tempdb local drive ssd versus attached storage

tcronin 95651 (3/4/2016)
Loads to the a data warehouse from source databases. I also have a 3rd party db I support with awful design (no control over it) so tempdb...
--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)

March 4, 2016 at 7:40 am

#1863111
RE: generate unique id for each row within a range

bismsit.29 (3/4/2016)
sure john i will let you know all in detail. i would look forward for your suggestion in this.
this is a new table which will get offer feed from...
--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)

March 4, 2016 at 7:21 am

#1863100
RE: tempdb local drive ssd versus attached storage

tcronin 95651 (3/4/2016)
THis is a data warehouse with monster ETL's I have seen great things about the Fusion product. The fact is it is cheaper than adding the SSD...
--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)

March 4, 2016 at 6:55 am

#1863086
RE: How to show Quarters Dynamically in SQL

mandymvn (3/3/2016)
Hi Jeff,
"do you want the report headings to auto-magically change based on today's date (whatever it is)?"
is there a way to do it ? I am not sure If...
--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)

March 4, 2016 at 12:08 am

#1862996
RE: generate unique id for each row within a range

bismsit.29 (3/3/2016)
Hi All
I want to assign one unique id to each row in a table and the range is from 1 to 99999. there will be a flag for active...
--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)

March 3, 2016 at 6:22 pm

#1862971
RE: How to show Quarters Dynamically in SQL

mandymvn (3/3/2016)
Hi,
At present am showing quarters from 2015-Q1 to Q4 , it should be like that, because report must show data for last 4 quarters only.
Whenever i 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)

March 3, 2016 at 6:15 pm

#1862970
RE: Trouble Deploying CLR functions

fxferguson (3/3/2016)
I have some CLR functions that were compiled and under .Net framework 2.0 for SQL Server 2008. I modified and recompiled them under framework 4.0 to run on 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)

March 3, 2016 at 6:10 pm

#1862969
RE: Trigger for Table Updates

TJT (3/3/2016)
Hi SSCoach, do you have an example of a holding table? Also do you have an example of retrieving data from the " inserted or deleted virtual tables"?
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)

March 3, 2016 at 6:09 pm

#1862968
RE: Only one expression can be specified in the select list when the subquery is not introduced...

...and thing like this...
WHERE (DATEDIFF(D, sod.ConfirmDate, GETDATE()) > 0)
... make it impossible to do index seeks and generally slow code way down because it has to calculate for every...
--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)

March 3, 2016 at 6:01 pm

#1862966
RE: tempdb local drive ssd versus attached storage

tcronin 95651 (3/3/2016)
Started with 300 gig tempdb, may need to expand that.
I can't really tell because I know nothing about your databases but that seems a bit much. I've...
--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)

March 3, 2016 at 5:52 pm

#1862965

Viewing 15 posts - 18,196 through 18,210 (of 59,069 total)