Jeff Moden

Forum Replies Created

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

RE: Help with Trigger emial

Sue_H - Thursday, December 7, 2017 4:08 PM
pietlinden - Thursday, December 7, 2017 3:32 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 5:31 pm

#1971488
RE: Linked Server Error

Balz - Friday, December 8, 2017 12:48 AM
Hi,
I am trying to export the SQL (Server 2012) data to Excel file. 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)

December 10, 2017 at 4:55 pm

#1971487
RE: Scripting Tables with ALTER with dependencies

Arsh - Saturday, December 9, 2017 4:25 AM
Dear Experts,
Please advise how I can script all the tables of a database with ALTER...
--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 4:19 pm

#1971486
RE: "Tag" highest value in the month

Simple SQL Tips - Sunday, December 10, 2017 12:51 AM
First of all, thank you for the assistance. After running the code 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)

December 10, 2017 at 3:38 pm

#1971485
RE: adding 365 partitions to existing scheme and fucntion in sql server 2014

prem.m38 - Sunday, December 10, 2017 2:35 AM
Hi
My tables are partitioned on business date. My requirement is to add 365 partitions 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)

December 10, 2017 at 2:44 pm

#1971484
RE: STRING_SPLIT with no delimiter

Awesome thinking outside the box! Well done!
--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:38 pm

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

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