Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,911 through 11,925 (of 59,099 total)

RE: STRING_SPLIT()

Raghavender Chavva - Monday, July 9, 2018 8:26 AM
When I executed this code in SQL Server 2016, below is the error:
Procedure expects...
--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 9, 2018 at 8:38 am

#1996794
RE: execute strored procedure through OPENROWSET-SYNTAX ERROR

george.sofroniadis - Monday, July 9, 2018 7:12 AM
declare @tmp as varchar(25)
set @tmp ='Î Î‘Î Î‘Î“ÎŸÎ¥'
SELECT
*
INTO
#tmpSortedBooks
FROM
OPENROWSET(
'SQLNCLI',
'Server=MNG01\MPISDARIS;Trusted_Connection=yes;Database=Reporting;',
'EXEC...
--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 9, 2018 at 7:55 am

#1996785
RE: Dealing with Disparate Goals

My experience has been that it all comes down to proper bi-directional communications. By "proper", I mean that management drops the "I'm the boss... do it my way" attitude 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)

July 9, 2018 at 6:39 am

#1996771
RE: Importing Tricky CSV Files with PowerShell

Stewart "Arturius" Campbell - Sunday, July 8, 2018 11:34 PM
been away (out of mobile range) for a few days. This has been...
--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 9, 2018 at 6:30 am

#1996768
RE: Who Likes NULL?

Sean Redmond - Monday, July 9, 2018 1:07 AM
chrisbray - Monday, July 9, 2018 12:48 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 9, 2018 at 6:29 am

#1996767
RE: It is possible to create a dynamic table from a result set ?

Eirikur Eiriksson - Sunday, July 8, 2018 9:28 AM
Jeff Moden - Sunday, July 8, 2018 9:11 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 8, 2018 at 2:17 pm

#1996709
RE: Avoid bulk data export

Eirikur Eiriksson - Sunday, July 8, 2018 1:53 AM
frederico_fonseca - Sunday, July 8, 2018 1:17 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 8, 2018 at 11:29 am

#1996706
RE: It is possible to create a dynamic table from a result set ?

Pretty cool, Eirikur. And, "Look Ma!!!!", it's fully documented! This thread is now a part of my briefcase!
You should write an article about this bad boy. 😉
--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 8, 2018 at 9:11 am

#1996700
RE: Difference between minimum and maximum value

jcelko212 32090 - Friday, July 6, 2018 10:08 AM
Jeff Moden - Thursday, July 5, 2018 9: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 8, 2018 at 8:47 am

#1996698
RE: STRING_SPLIT()

Eirikur Eiriksson - Sunday, July 8, 2018 12:45 AM
The alleged "correct" answer is wrong.
😎
What version of SQL Server did you test...
--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 8, 2018 at 7:27 am

#1996686
RE: STRING_SPLIT()

Steve Jones - SSC Editor - Saturday, July 7, 2018 11:21 AM
Comments posted to this topic are about the item STRING_SPLIT()
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)

July 7, 2018 at 6:28 pm

#1996671
RE: Who Likes NULL?

Dennis Q Miller - Saturday, July 7, 2018 9:24 AM
So, NULL is a value for something that doesn't have a 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)

July 7, 2018 at 9:59 am

#1996662
RE: Importing Tricky CSV Files with PowerShell

Bruin - Friday, July 6, 2018 12:04 PM
Does the order of the csv have to match sql schema and what about if...
--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 7, 2018 at 9:41 am

#1996659
RE: Programatically change the time of a schedule

Thom A - Saturday, July 7, 2018 4:30 AM
Jeff Moden - Friday, July 6, 2018 7:09 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 7, 2018 at 9:39 am

#1996658
RE: SQL design question.

hcareinfosys.jgv - Friday, July 6, 2018 3:03 PM
Thank you all for your replies. I was concerned about in the off chance 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)

July 6, 2018 at 9:28 pm

#1996642

Viewing 15 posts - 11,911 through 11,925 (of 59,099 total)