Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,506 through 47,520 (of 59,095 total)

RE: Field Type to use for Elapsed Time in HH:MM?

Heh... here's just some of the problems you can run into if you mess around with dates, times, and durations...
http://www.sqlservercentral.com/Forums/Topic595094-8-1.aspx
--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 31, 2008 at 10:48 am

#892469
RE: Field Type to use for Elapsed Time in HH:MM?

Michael Valentine Jones (10/31/2008)
It’s usually better to store elapsed time in a datetime column as an offset from zero time, 1900-01-01 00:00:00.000. It then allows you to use all...
--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 31, 2008 at 9:45 am

#892424
RE: using CLR assembly

Jonathan Kehayias (10/30/2008)
As resistent as you are to CLR inside SQL, it is actually becoming more and more popular, even among MVP's for things just like this.
Heh... even 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)

October 30, 2008 at 7:18 pm

#892138
RE: SQL Data Counter

You don't need a counter for that... just store a date on every row and then count the rows in a data range.
--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 30, 2008 at 7:12 pm

#892137
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

jlcampos71 (10/29/2008)
Thanks Again Jeff!
I almost Figured that out... but I didn't at all... I was figuring out that I should make in fact, 3 passes, because there is a second...
--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 30, 2008 at 6:46 pm

#892135
RE: Is a Recursive Query what I need?

No problem... thanks for the feedback.
--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 30, 2008 at 6:35 pm

#892132
RE: Assigning current of _Cursor to local @variable

J (10/30/2008)
I am wondering WHY the HINT should be necesswary in the statement
UPDATE Products
SET @PrevF2 = F2 = CASE WHEN F2 IS NULL THEN @PrevF2...
--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 30, 2008 at 6:26 pm

#892129
RE: Is a Recursive Query what I need?

Lynn Pettis (10/29/2008)
Jeff, I guess I should add that one to my sig block as well.
Seems like there have been a lot of reasons to use it, lately.
--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 29, 2008 at 10:16 pm

#891598
RE: Is a Recursive Query what I need?

jsteinbeck (10/29/2008)
I knew you would post...lol
I'll check it out...
But i did figure it out, see my other post
Running Total isn't working in the UPDATE CLAUSE... doesn't that look...
--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 29, 2008 at 10:15 pm

#891596
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

jlcampos71 (10/29/2008)
This "Passing Parameters" Stuff is great... it almost solves my problem...
I might sound like a beginner next to you but this is the best I have found...
I have 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 29, 2008 at 10:11 pm

#891595
RE: Is a Recursive Query what I need?

Solution eventually reached at the following URL...
http://www.sqlservercentral.com/Forums/Topic593999-8-1.aspx
--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 29, 2008 at 8:01 pm

#891573
RE: Using Datepart

If you'd always like it to return Jan - Mar of the CURRENT year, then you don't even need to know what the current year is...
SELECT ID
...
--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 29, 2008 at 7:57 pm

#891572
RE: using CLR assembly

evaleah (10/29/2008)
Sorry about the missing information.
I deployed it to SQL 2005 and it appears in the Assembly area. The routine creates an iCalendar formatted email message and then sends...
--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 29, 2008 at 7:44 pm

#891571
RE: SELECT DISTINCT returns random duplicate rows

Why? Try this and see why I ask... ask yourself "What is 1 divided by 3 times 3?" 😛
DECLARE @A DECIMAL(3,0), @b-2 DECIMAL(18,0),@F FLOAT
SET @A = 3
SET...
--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 29, 2008 at 7:30 pm

#891567
RE: Segmentation fault in tempdb

Is the "autoshrink" option turned on on TempDB??? If so, it must be turned off!.
Also, you need to figure out what the largest it will grow to, add 20 or...
--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 29, 2008 at 7:23 pm

#891564

Viewing 15 posts - 47,506 through 47,520 (of 59,095 total)