Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,791 through 11,805 (of 59,099 total)

RE: How to GROUP BY XML column

lexcerm - Wednesday, July 18, 2018 6:47 AM
I have added all the columns in the select one-by-one, but it keeps bombing out...
--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)

July 18, 2018 at 1:26 pm

#1998093
RE: Seeking advice to determine a good option for table row comparisons

vsamantha35 - Wednesday, July 18, 2018 12:04 AM
Hi All,
We have a requirement where we need to compare table rows and merge...
--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)

July 18, 2018 at 1:20 pm

#1998091
RE: sproc question

mjohnson 71479 - Wednesday, July 18, 2018 1:03 PM
Thank you! I have rewritten it and it is working as intended.
Very cool. Thanks...
--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)

July 18, 2018 at 1:16 pm

#1998090
RE: Need Help to convert DATETIME result into DATE on SQL Server

meichmann - Wednesday, July 18, 2018 10:39 AM
Jeff Moden - Monday, July 16, 2018 3:58 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)

July 18, 2018 at 12:12 pm

#1998080
RE: Need Help to convert DATETIME result into DATE on SQL Server

sgmunson - Tuesday, July 17, 2018 7:34 AM
Jeff Moden - Monday, July 16, 2018 3:58 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)

July 18, 2018 at 12:11 pm

#1998079
RE: Converting Excel Formula into TSQL

Ronnie Rahman - Wednesday, July 18, 2018 11:39 AM
Phil Parkin - Wednesday, July 18, 2018 11:36 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)

July 18, 2018 at 12:03 pm

#1998074
RE: weird issue? green arrow disappear

Dunno then. I've not had nor have been able to duplicate that problem if running as administrator.
--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)

July 18, 2018 at 12:01 pm

#1998071
RE: Database query performance is very poor

saptek9 - Wednesday, July 18, 2018 1:33 AM
Sue_H - Tuesday, July 17, 2018 6:44 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)

July 18, 2018 at 11:55 am

#1998069
RE: Converting Excel Formula into TSQL

Ronnie Rahman - Wednesday, July 18, 2018 10:40 AM
Lynn Pettis - Wednesday, July 18, 2018 10:34 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)

July 18, 2018 at 11:32 am

#1998057
RE: weird issue? green arrow disappear

bissagars - Wednesday, July 18, 2018 11:15 AM
Jeff Moden - Wednesday, July 18, 2018 11:07 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)

July 18, 2018 at 11:25 am

#1998055
RE: Storage that Expires

Sergiy - Wednesday, July 18, 2018 2:25 AM
Think of those #metoo activists - do the even have a case?According to the new...
--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)

July 18, 2018 at 11:22 am

#1998054
RE: sproc question

Yes there is. Done correctly, there's no chance of SQL Injection, either. Please see the article at the following link, which I consider to be the definitive article on 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)

July 18, 2018 at 11:16 am

#1998052
RE: weird issue? green arrow disappear

bissagars - Wednesday, July 18, 2018 11:04 AM
I have been using SQL Server 2008 SP2 for 2 years and didn't face 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)

July 18, 2018 at 11:07 am

#1998049
RE: The Age of Multiple Databases

xsevensinzx - Monday, July 16, 2018 8:33 PM
Yeah, it's not that big in comparison to what's out there obviously, but it's many...
--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)

July 18, 2018 at 8:46 am

#1998014
RE: Flat File csv with double quotes

gothaimviii - Wednesday, July 18, 2018 8:01 AM
sestell1 - Wednesday, July 18, 2018 6:55 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)

July 18, 2018 at 8:40 am

#1998013

Viewing 15 posts - 11,791 through 11,805 (of 59,099 total)