Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,891 through 25,905 (of 59,099 total)

RE: Are the posted questions getting worse?

Greg Edwards-268690 (9/20/2013)
Jeff Moden (9/20/2013)
Are you good folks saying that any form of SELECT/INTO is bad? If so, why?
I sense a frozen pork chop being readied for launch! ...
--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)

September 20, 2013 at 9:50 pm

#1652101
RE: Are the posted questions getting worse?

wolfkillj (9/20/2013)
The filibustering member stops speaking during debate on the point of order but has to follow all the other rules, including remaining standing.
Sounds like some of the scrums 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)

September 20, 2013 at 9:20 pm

#1652098
RE: Calculating age

gilbert delarosa (9/20/2013)
But they wouldn't be 1 until after their BDay
or you could just
DECLARE @DOB DATETIME
SET @DOB='01/01/2013'
SELECT FLOOR((DATEDIFF(DD,@DOB,'01/01/2014')+1)/365.25)
Still doesn't work. Last I heard, you gained a year 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)

September 20, 2013 at 5:01 pm

#1652084
RE: Are the posted questions getting worse?

So, could you do the following during a filibuster? Some people have labeled this as "Navy Training". I call it "A Brief History of the Life of 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)

September 20, 2013 at 4:08 pm

#1652075
RE: Calculating age

gilbert delarosa (9/20/2013)
This seems to work
DECLARE @DOB DATETIME
SET @DOB='9/19/2000'
SELECT FLOOR(DATEDIFF(DD,@DOB,GETDATE())/365.25)
Good try but it doesn't work...
DECLARE @DOB DATETIME
SET @DOB='01/01/2013'
SELECT FLOOR(DATEDIFF(DD,@DOB,'01/01/2014')/365.25)
Results:
---------------------------------------
0
(1 row(s) affected)
--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)

September 20, 2013 at 3:55 pm

#1652071
RE: Are the posted questions getting worse?

hisakimatama (9/20/2013)
*Huff* *Wheeze* I... I did it! I managed to read the entirety of The Thread! That was... Interesting :-D. Been lurking around here,...
--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)

September 20, 2013 at 12:47 pm

#1652013
RE: Automate Your Backup and Restore Tasks

Steve Jones - SSC Editor (10/5/2010)
SanjayAttray (10/5/2010)
Why do this task with VB script when you can do the whole process with T-SQL scripts?
Do you somehow think that T-SQL is "better"
Yes......
--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)

September 20, 2013 at 12:37 pm

#1652011
RE: Systems Engineer - is it a good career goal for DBA?

Jeff Atherton (9/20/2013)
I'm going the other way. I've been a windows admin for a long time with some DBA duties on the side. Now I'm working on the T-SQL ninja...
--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)

September 20, 2013 at 12:15 pm

#1652006
RE: Temp tables vs "permanent" temp table vs User Table Type

PiMané (9/20/2013)
Jeff Moden (9/20/2013)
Heh... you asked what the best way to store XML is. I suggested shredding it and storing it in normalized tables. Are you storing 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)

September 20, 2013 at 12:12 pm

#1652003
RE: Temp tables vs "permanent" temp table vs User Table Type

PiMané (9/19/2013)
Jeff Moden (9/19/2013)
PiMané (9/4/2013)
What's the best way to store the XML?
The best way, IMHO, is to shred it on receipt and store it as properly normalized data. ...
--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)

September 20, 2013 at 7:11 am

#1651906
RE: Shift Column values to the left

eseosaoregie (9/20/2013)
I opted for the multiple update option. It is added to a larger clean up job that will run at night. It ran very quickly and gave the desired...
--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)

September 20, 2013 at 7:05 am

#1651902
RE: Are the posted questions getting worse?

Are you good folks saying that any form of SELECT/INTO is bad? If so, why?
--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)

September 20, 2013 at 7:02 am

#1651900
RE: how to write a stored procedure for this

enriquezreyjoseph (9/20/2013)
Can you show us the code??..
cheers!!
"Be Brave even though you are not no one can tell the difference" - sir bernard tan
To whom are you speaking?
--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)

September 20, 2013 at 6:55 am

#1651895
RE: Adding time intervals in minutes and display as csv

Koen Verbeeck (9/19/2013)
kalikoi (9/19/2013)
gentleman thx for the code but here is my approach
composed a udf that returns the csv
DECLARE @StartTime TIME(0) = '00:10'
DECLARE @EndTime TIME(0) = '01:40'
DECLARE @MinutesToAdd INT =...
--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)

September 19, 2013 at 10:49 pm

#1651763
RE: Want to add Text data

niladri.primalink (9/19/2013)
Thanks guys for your input
It is working awesome!!
"It"? What is "It"? What did you end up using? Please post the code that you ended up using.
--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)

September 19, 2013 at 10:18 pm

#1651757

Viewing 15 posts - 25,891 through 25,905 (of 59,099 total)