Jeff Moden

Forum Replies Created

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

RE: Use uniqueidentifier field in place of int

Lynn Pettis - Tuesday, April 3, 2018 5:32 PM
Want my guess. In the source table the EnrollmentRecordID is a uniqueidentifier. In 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)

April 3, 2018 at 6:49 pm

#1985393
RE: Use uniqueidentifier field in place of int

daniness - Tuesday, April 3, 2018 12:08 PM
In brief, the reason I was trying to do this is to pull from 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)

April 3, 2018 at 5:15 pm

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

below86 - Monday, April 2, 2018 1:01 PM
Jeff, If you have a better solution please include it. I would really like to...
--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)

April 2, 2018 at 1:12 pm

#1985219
RE: imsage test

Seems to work well on both a direct click and opening in a new tab with a right click. How was the image placed on the page? Copy'n'paste or "drag"?
--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 9:17 am

#1985143
RE: SELECTing a hierachy

george-178499 - Friday, March 30, 2018 9:42 PM
How is the link established between School 3 and District 1. Do you 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)

March 31, 2018 at 8:54 am

#1985142
RE: SSRS - "Virus/Spyware Download Blocked"

I'd have to say that the software on all fronts is doing precisely what it was designed to do. I also don't believe there will be anything that you can...
--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:42 am

#1985141
RE: Temporal Tables - Delete Conflict

Mike Hotek - Friday, March 30, 2018 2:04 PM
Well, I'm trying to figure out a way around another massive hole in 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)

March 31, 2018 at 8:36 am

#1985140
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

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