Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,631 through 12,645 (of 59,095 total)

RE: How to retrieve all the data group types at the same time in sql server?

below86 - Friday, March 30, 2018 1:43 PM
I modified Steve's code: This will return all 3 rows if you send the value...
--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)

March 31, 2018 at 8:30 am

#1985139
RE: Creating a statement that produces an Primary Key ID

sgmunson - Friday, March 30, 2018 1:39 PM
pietlinden - Friday, March 23, 2018 12:03 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)

March 31, 2018 at 8:27 am

#1985138
RE: Generate a unique number for a combination

patrickmcginnis59 10839 - Saturday, March 31, 2018 6:49 AM
sgmunson - Friday, March 30, 2018 1:30 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)

March 31, 2018 at 8:06 am

#1985137
RE: Generate a unique number for a combination

I still want to know the business reason behind this. Why is it that we need a unique number to represent the combination of a Loan Number and a Date...
--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)

March 30, 2018 at 6:20 pm

#1985133
RE: Generate a unique number for a combination

patrickmcginnis59 10839 - Friday, March 30, 2018 1:24 PM
Jeff Moden - Thursday, March 29, 2018 12:48 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)

March 30, 2018 at 6:17 pm

#1985132
RE: Generate a unique number for a combination

m.katrobos - Friday, March 30, 2018 10:11 AM
komal145 - Thursday, March 29, 2018 11:10 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)

March 30, 2018 at 12:49 pm

#1985108
RE: SQL Server Database Table Size Limit

Aneel Amin - Friday, March 16, 2018 3:25 AM
Hi,
Thanks for the reply. Actually we are looking for the performance aspects as well...
--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)

March 29, 2018 at 6:02 pm

#1985062
RE: Are the posted questions getting worse?

Lynn Pettis - Thursday, March 29, 2018 1:09 PM
Jeff Moden - Thursday, March 29, 2018 1:01 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)

March 29, 2018 at 1:37 pm

#1985044
RE: Are the posted questions getting worse?

Sean Lange - Thursday, March 29, 2018 1:13 PM
Jeff Moden - Thursday, March 29, 2018 1:01 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)

March 29, 2018 at 1:35 pm

#1985043
RE: Are the posted questions getting worse?

Lynn Pettis - Thursday, March 29, 2018 12:57 PM
Any one hear from R Barry Young lately?
Now that you mention it, no. I...
--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)

March 29, 2018 at 1:01 pm

#1985035
RE: Generate a unique number for a combination

komal145 - Thursday, March 29, 2018 11:10 AM
How do you generate unique number based on a Loannumber , Date columns
Example
Declare...
--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)

March 29, 2018 at 12:48 pm

#1985030
RE: How would you parse 000.024.000 into 24H?

Yep... agreed. Performance is second only to accuracy and they're both extremely important.
I was mostly referring to the bloody PARSENAME and the NVARCHAR conversion. I do know that...
--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)

March 29, 2018 at 12:40 pm

#1985029
RE: How would you parse 000.024.000 into 24H?

Jason A. Long - Wednesday, March 28, 2018 10:58 AM
Jeff Moden - Wednesday, March 28, 2018 7:44...
--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)

March 28, 2018 at 4:23 pm

#1984900
RE: How would you parse 000.024.000 into 24H?

NineIron - Wednesday, March 28, 2018 7:41 AM
Nice. I'll use replace(PARSENAME(TextTime,
--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)

March 28, 2018 at 7:44 am

#1984795

RE: Table partitioning question

Marius.D - Tuesday, March 27, 2018 8:45 AM

Standard steps for adding a new partition are create the file group, add the file,...

--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)

March 28, 2018 at 7:39 am

#1984790

Viewing 15 posts - 12,631 through 12,645 (of 59,095 total)