Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,571 through 24,585 (of 59,099 total)

RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

Jerry_Boutot (1/30/2014)
Nice article, well written. As a developer that has had to do a lot of work around date and time functionality, I can appreciate this article. You are correct...
--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 30, 2014 at 8:56 am

#1684716
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

Jerry Kelk (1/30/2014)
Fair comment Jeff. Point taken.
Fortunately, I don't have huge data or paying customers, so on a horses-for-courses basis, the method suits me well enough.
Food for thought though,...
--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 30, 2014 at 8:47 am

#1684708
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

Sean Lange (1/30/2014)
Thomas Abraham (1/30/2014)
When I went to review this spackle, I found the current rating was "Good". Can't agree. Jeff has, as usual, taken a problem of some import,...
--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 30, 2014 at 8:41 am

#1684701
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

Thomas Abraham (1/30/2014)
When I went to review this spackle, I found the current rating was "Good". Can't agree. Jeff has, as usual, taken a problem of some import, broken it...
--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 30, 2014 at 8:27 am

#1684695
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

vitex2003 (1/30/2014)
SELECT RangeType,StartDate,EndDate,Comment
FROM dbo.TestTable
WHERE convert(char(10),EndDate,102) >= cast('01 Oct 2013' as datetime)
AND convert(char(10),StartDate,102) <= cast('01 Nov 2013' as...
--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 30, 2014 at 8:14 am

#1684692
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

Jerry Kelk (1/30/2014)
This deals with the time problem without having to give it a thought.
Thanks for the feedback and the code, Jerry, but you've just exemplified one of the reasons...
--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 30, 2014 at 8:10 am

#1684689
RE: Are the posted questions getting worse?

rodjkidd (1/30/2014)
Serious Doh! Moment today.
... {snip}...
Went to talk to one of the Prod DBA's as my access on the server is limited, and he spots that the server has run...
--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 30, 2014 at 8:01 am

#1684686
RE: Are the posted questions getting worse?

rodjkidd (1/30/2014)
Another awesome SQL Spackle from Jeff today.
Cheers Jeff!
Rodders...
Thanks Rodders. This one was aimed mostly at helping newbies to SQL Server understand the problem especially since there have been...
--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 30, 2014 at 7:39 am

#1684673
RE: Comparing string with date

Lempster (1/29/2014)
Jeff Moden (1/29/2014)
Too bad because I finally learned how to copy'n'paste my SARGable solution correctly. :blush:
Could you post your solution anyway Jeff?
Regards
Lempster
Sure. With the understanding that such...
--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 30, 2014 at 7:24 am

#1684664
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

vitex2003 (1/30/2014)
Everything is right, but there are and other ways how to make your code bullet proof.
Thanks for the insight. Would you post some code for said bullet proofing?...
--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 30, 2014 at 7:09 am

#1684651
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

danielfountain (1/30/2014)
Excellent article. A problem that i have never come across but may do. The train of thought on the problem was insightful.
That, good sir, is 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)

January 30, 2014 at 7:01 am

#1684644
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

Thanks guys. I appreciate it.
--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 30, 2014 at 6:58 am

#1684637
RE: Shrinking a Databse (pro\con)

jbarry 87949 (1/29/2014)
OK, as a rule, I think shrinking a database or database file is bad. I would not normally allow for such behavior but I have a rather...
--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 29, 2014 at 6:54 pm

#1684515
RE: Padding zeros after decimal

james.grondalski (1/29/2014)
Hey... can anyone tell me the best way to migrate Reporting Services 2008 (not 2008 R2) to 2012. The Microsoft migration tool does not work... Just wondering what 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 29, 2014 at 5:22 pm

#1684507
RE: Padding zeros after decimal

sqlsean (1/29/2014)
i have a table like
[A]-------------
[0]-------------[0.012345]
[1]-------------[0.002345]
[0.2145]------[0.1457]
I need both columns A and B to be padded with zeros at the end upto 9th place after decimal...
--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 29, 2014 at 5:21 pm

#1684506

Viewing 15 posts - 24,571 through 24,585 (of 59,099 total)