Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,471 through 13,485 (of 59,095 total)

RE: Can Data Save the World?

David.Poole - Sunday, December 10, 2017 2:18 AM
Jeff Moden - Saturday, December 9, 2017 9:40 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)

December 10, 2017 at 2:01 pm

#1971482
RE: joining lots and lots of tables in a vew

mark seidelin-407018 - Saturday, December 9, 2017 9:40 PM
Thx for the suggestions.
am on SQL 2016.
have got a working solution...
--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)

December 9, 2017 at 10:34 pm

#1971468
RE: Link SQL Server 2014 to a Progress Database, is it possible?

Siten0308 - Saturday, December 9, 2017 9:00 PM
UPDATE: I got it to work, when creating the ODBC... it helps if you hit...
--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)

December 9, 2017 at 10:30 pm

#1971467
RE: Query from 2 tables from 2 databases

ahsal - Saturday, December 9, 2017 2:31 PM
Thom A - Saturday, December 9, 2017 8:57 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)

December 9, 2017 at 10:22 pm

#1971466
RE: ORDER By Based on Company then SubCompany

jcelko212 32090 - Saturday, December 9, 2017 12:35 PM
Jeff Moden - Friday, December 8, 2017 2:52 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)

December 9, 2017 at 10:13 pm

#1971465
RE: Can Data Save the World?

skeleton567 - Saturday, December 9, 2017 6:54 AM
mjh 45389 - Saturday, December 9, 2017 2:02 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)

December 9, 2017 at 9:40 pm

#1971463
RE: HASHBYTES can help quickly load a Data Warehouse

TomThomson - Saturday, December 9, 2017 4:31 PM
Jeff Moden - Friday, December 8, 2017 8:05 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)

December 9, 2017 at 9:35 pm

#1971462
RE: Can Data Save the World?

jay-h - Friday, December 8, 2017 11:38 AM
For some fun, here's data to peruse
ourworldindata.org
And for some wacky fun:
http://www.tylervigen.com/spurious-correlations
BWAAA-HAAA!!!! The one about...
--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)

December 8, 2017 at 8:14 pm

#1971445
RE: HASHBYTES can help quickly load a Data Warehouse

odeddror - Friday, December 8, 2017 6:11 PM
TomThomson - Friday, December 8, 2017 4:03 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)

December 8, 2017 at 8:05 pm

#1971444
RE: SQL Battleship

below86 - Friday, December 8, 2017 1:31 PM
OMG, the game of my life. The first 6 shots I had I sank 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)

December 8, 2017 at 2:55 pm

#1971435
RE: ORDER By Based on Company then SubCompany

Seems to me that the hierarchy here won't change often. This is a prime candidate for conversion to Nested Sets, which will enable some remarkably efficient queries if the table...
--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)

December 8, 2017 at 2:52 pm

#1971434
RE: A simple example which, after 15 years of relational design work, still breaks my brain - phone numbers

Thom A - Friday, December 8, 2017 3:34 AM
I certainly agree that, if you can, store things such as phone numbers in...
--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)

December 8, 2017 at 8:02 am

#1971375
RE: No of Months between two dates in YYYYMM format

Luis Cazares - Monday, June 15, 2015 1:50 PM
sgmunson (6/15/2015)
sqlinterset (6/15/2015)
I am looking to calculate no of months between two dates which...
--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)

December 8, 2017 at 7:53 am

#1971372
RE: Job getting stuck in UAT but runs fine in Prod

coolchaitu - Friday, December 8, 2017 7:42 AM
Arsh - Friday, December 8, 2017 7:37 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)

December 8, 2017 at 7:49 am

#1971369
RE: Bulk insert into table from csv

What error are you getting for the one that doesn't work?
--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)

December 8, 2017 at 7:43 am

#1971367

Viewing 15 posts - 13,471 through 13,485 (of 59,095 total)