Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,331 through 36,345 (of 59,067 total)

RE: Date Gap Problem

WayneS (10/17/2010)
This works, but the performance is atrocious.
Because of the very large datespan from any date in this century to 9999-12-31, I'm thinking that my ol' friend the Tally 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)

October 17, 2010 at 10:06 pm

#1238209
RE: Date Gap Problem

Sorry... forgot to print out the results...
MemberIDStartDateEndDateGap
12005-10-01 00:00:00.0002006-09-30 00:00:00.0000
12006-10-01 00:00:00.0002007-12-31 00:00:00.0000
12008-01-15 00:00:00.0002008-12-31 00:00:00.00015
12009-01-01 00:00:00.0009999-12-31 00:00:00.0000
22005-10-01 00:00:00.0002006-09-30 00:00:00.0000
22006-10-01 00:00:00.0002007-09-30 00:00:00.0000
22007-02-03 00:00:00.0002007-12-31 00:00:00.0000
22008-01-15 00:00:00.0002008-12-31 00:00:00.00015
22009-01-01 00:00:00.0009999-12-31 00:00:00.0000
32005-10-01 00:00:00.0002006-09-30 00:00:00.0000
32006-10-01 00:00:00.0002007-09-30 00:00:00.0000
32008-01-01 00:00:00.0002008-12-31...
--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)

October 17, 2010 at 9:57 pm

#1238206
RE: Date Gap Problem

TheSQLGuru (10/17/2010)
My brain is mush and I just cannot work this one out. I need a good solution to find any gaps between enddate and startdate > 30 days...
--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)

October 17, 2010 at 9:53 pm

#1238205
RE: working with multiple dataset withing a table in SSRS

Doug Lane (10/13/2010)
Jack isn't saying multiple datasets are bad; he's saying trying to blend multiple datasets in the same table control is bad. RS just wasn't designed to take...
--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)

October 17, 2010 at 7:37 pm

#1238198
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (10/14/2010)
The green value, if there is one, comes not from you getting ebooks, but from 1000s of people doing this. Less paper, less energy, less...
--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)

October 17, 2010 at 7:04 pm

#1238197
RE: Are the posted questions getting worse?

WayneS (10/14/2010)
"Don't try this at home... we're professionals!"
Heh... I have the perfect SQL subject for that... Quirky Update. 😀
--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)

October 17, 2010 at 6:57 pm

#1238196
RE: Calling a Stored Procedure inside a stored procedure

Heh... screw it. If you really insist on doing it using RBAR, do it in C#. 😀
--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)

October 17, 2010 at 6:47 pm

#1238194
RE: Are the posted questions getting worse?

WayneS (10/16/2010)
GilaMonster (10/16/2010)
Swap? http://www.sqlservercentral.com/Forums/Topic1005710-265-1.aspx
Me: Run CheckDB and and post the full and unedited results
OP: I have used that command and it returned about 3000 line of error code. This is...
--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)

October 17, 2010 at 6:40 pm

#1238192
RE: Are the posted questions getting worse?

GSquared (10/15/2010)
CirquedeSQLeil (10/15/2010)
GSquared (10/15/2010)
Yesterday, whilst commuting, I was actually thinking about setting up a video camera on my dashboard, and blogging the "good parts".
Then I realized it would contain at...
--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)

October 17, 2010 at 6:37 pm

#1238191
RE: Are the posted questions getting worse?

Alvin Ramard (10/15/2010)
Grant Fritchey (10/15/2010)
GilaMonster (10/15/2010)
And just when I thought the situation at That Client couldn't get any worse....
<headdesk><headdesk><headdesk><headdesk>
(No, I'm not going into details, it's a little too sensitive 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)

October 17, 2010 at 6:34 pm

#1238190
RE: Sending multiple rows to the Database from an Application: Part I

I'm not a GUI/App programmer so I'll have to find another way to test what you propose, Solomon. Shouldn't be too difficult, though.
If I were an App programmer, I'd...
--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)

October 17, 2010 at 6:19 pm

#1238187
RE: Sending multiple rows to the Database from an Application: Part I

Gosh... my first take on this is all the people in this discussion citing XML as a good way to do this. Would you folks mind providing a little...
--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)

October 17, 2010 at 3:51 pm

#1238164
RE: Sending multiple rows to the Database from an Application: Part I

Daniel Macey (8/18/2009)
Good to see an article on a tricky and quite important piece of code.
Although, with SQL Server 2008 around, I am surprised that you did not mention 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)

October 17, 2010 at 3:41 pm

#1238163
RE: Sending multiple rows to the Database from an Application: Part I

olimp23 (10/15/2010)
Nice article with interesting approach. I would use it in SqlServer 2000, but since SqlSever 2005 has a good XML support I would choose XML. In fact I have...
--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)

October 17, 2010 at 3:39 pm

#1238162
RE: Finding Sequences (Need help ASAP)

CELKO (10/14/2010)
Jeff Moden (10/13/2010)
Very cool, Joe. I'm thinking that you didn't test it...
[font="Courier New"]Msg 207, Level 16, State 1, Line 18
Invalid column name 'part_id'.
Msg 245, Level 16, State 1,...
--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)

October 16, 2010 at 8:13 am

#1238011

Viewing 15 posts - 36,331 through 36,345 (of 59,067 total)