Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,811 through 9,825 (of 59,091 total)

RE: Question on Grouping -Working number of days

sgmunson - Wednesday, February 13, 2019 7:14 AM
Okay folks. Recursion is not necessarily a problem, although it certainly can be. For smaller...
--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)

February 13, 2019 at 7:36 am

#2021917
RE: A real doozie!

zuma-1122451 - Tuesday, February 12, 2019 5:07 PM
Success! Yet, the mystery continues as I do not feel satisfied with WHY this happens...
--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)

February 12, 2019 at 6:10 pm

#2021883
RE: Increment dates for a set of records

barry.nielson - Tuesday, February 12, 2019 2:31 PM
it's a little complex but this is a set of records that maintain customer balances...
--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)

February 12, 2019 at 2:45 pm

#2021859
RE: Increment dates for a set of records

This seems like it could get out of hand storage-wise very quickly. Why do you need a fresh set of ALL rows every day? If we knew this, we might...
--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)

February 12, 2019 at 6:27 am

#2021762
RE: How to code to change text to high case for all tables?

adonetok - Tuesday, February 12, 2019 6:11 AM
Yes, I mean upper case. For example, I want to change data "Good" to GOOD".
For...
--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)

February 12, 2019 at 6:22 am

#2021759
RE: How should I reserve a set of "next numbers"?

Ah... found it in a 12 year old post of mine. Please see the following post. You can also replace the vendor's code and eliminate the possibility of getting 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)

February 11, 2019 at 8:20 am

#2021661
RE: How should I reserve a set of "next numbers"?

Chris Wooding - Monday, February 11, 2019 1:34 AM
Here's the next key table.
create table SEQ_SYSTEMKEY (LASTKEY int null) on [PRIMARY];
and...
--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)

February 11, 2019 at 8:05 am

#2021655
RE: Copy Backup File

VastSQL - Monday, February 11, 2019 5:17 AM
Eirikur Eiriksson - Tuesday, February 5, 2019 7:25 AM
--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)

February 11, 2019 at 7:58 am

#2021652
RE: Sort already comma separated list

gvoshol 73146 - Monday, February 11, 2019 6:01 AM
A VIN could be repeated after 30 years. That's because the Year character repeats...
--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)

February 11, 2019 at 7:56 am

#2021650
RE: Bulk Insert - tracking

Budd - Monday, February 11, 2019 7:37 AM
I understand that would be the best way to do this, however, I can't do...
--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)

February 11, 2019 at 7:53 am

#2021649
RE: Sort already comma separated list

jcelko212 32090 - Saturday, February 9, 2019 4:40 AM
ScottPletcher - Friday, February 8, 2019 3:47 PM
--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)

February 10, 2019 at 2:12 pm

#2021609
RE: Are the posted questions getting worse?

Grant Fritchey - Friday, February 8, 2019 5:53 AM
Hey Jeff!
Do you lend out the launcher to family & friends? If so, you'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)

February 8, 2019 at 7:06 pm

#2021586
RE: Sort already comma separated list

paul s-306273 - Tuesday, February 5, 2019 1:21 AM
Just an observation - Jeff and Lynn frequently respond to Joe's posts.
Anybody else...
--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)

February 8, 2019 at 6:46 pm

#2021585
RE: Write to table, send email, mark as sent

I don't know enough of your process to say for sure but it sounds like you have a plan that will work just fine. Guess I'd avoid NULL and use...
--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)

February 8, 2019 at 6:34 pm

#2021584
RE: The Funny Stored Procedure Name

Steve Jones - SSC Editor - Friday, February 8, 2019 8:29 AM
The reason I added this, and a few other questions, 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)

February 8, 2019 at 6:31 pm

#2021583

Viewing 15 posts - 9,811 through 9,825 (of 59,091 total)