Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,336 through 13,350 (of 59,101 total)

RE: OPENROWSET when Excel worksheet name is unknown

Hansiehans - Friday, June 27, 2014 1:46 AM
This is the code I used...enjoy 🙂
-- Get table (worksheet) or column (field) listings from...
--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 23, 2017 at 8:29 am

#1973332
RE: To Index a Computed Column...

daniness - Wednesday, December 20, 2017 9:30 AM
Thank you for your feedback, Jeff. That was very helpful and I was finally able...
--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 22, 2017 at 9:56 pm

#1973320
RE: Suggestions on a query plan

Chris Harshman - Friday, December 22, 2017 11:01 AM
ScottPletcher - Thursday, December 21, 2017 3:11 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 22, 2017 at 9:18 pm

#1973319
RE: Suggestions on a query plan

ScottPletcher - Thursday, December 21, 2017 3:11 PM
The key lookups should cost more than the sort for only 7 rows (I know...
--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 22, 2017 at 8:35 pm

#1973317
RE: Suggestions on a query plan

Lynn Pettis - Thursday, December 21, 2017 2:40 PM
Joe Torre - Thursday, December 21, 2017 2:36 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 22, 2017 at 8:32 pm

#1973316
RE: Trigger Based Change Data capture

I could be wrong (I won't load this code to test it) but this appears to record not only data that has changed, but also records data in all of the other columns...
--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 22, 2017 at 5:42 pm

#1973311
RE: Difference between dates displayed in days, hours, minutes and seconds

robinson.netdevelop - Monday, December 18, 2017 9:14 AM
It is right?
CREATE FUNCTION dbo.ufn_DifferenceBetweenDates
(
@Date1 Datetime, -- Dia inicio
@Date2 Datetime -- Dia...
--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 22, 2017 at 3:00 pm

#1973303
RE: I don’t know how to help with database…

Grant Fritchey - Friday, December 22, 2017 6:21 AM
A yahoo email address, so I suspect spam too.
However, in the interest of being...
--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 22, 2017 at 9:28 am

#1973277
RE: Can someone explain how this works

macbaze72 - Thursday, December 21, 2017 4:04 PM
This code works, but I don;t understand it. The part I need some clarification is...
--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 22, 2017 at 9:26 am

#1973275
RE: Suggestions on a query plan

vsamantha35 - Thursday, December 21, 2017 12:48 PM
Thanks Lynn. One more thing, I want to ask is that, how can we make...
--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 22, 2017 at 6:48 am

#1973258
RE: usage of DISTINCT OPERATOR

From the code alone posted so far, it's a bit difficult to make out what you're actually trying to do. From the description and a couple of hints 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)

December 22, 2017 at 6:37 am

#1973257
RE: Split a Record using Substring

mk.kamalanand - Friday, December 22, 2017 1:53 AM
Hi All,
I have records stored in a table in below formats . Want the result...
--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 22, 2017 at 6:05 am

#1973255
RE: t-sql 2012 split function

wendy elizabeth - Tuesday, December 19, 2017 2:02 PM
How about what is wrong with what I just submitted? The splitter function works...
--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 21, 2017 at 6:23 pm

#1973237
RE: views,tables,stored procedures are rolled back to previous versions

adisql - Thursday, December 21, 2017 2:57 PM
is there any way to find what jobs modifying these objects .
because these objects are...
--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 21, 2017 at 4:07 pm

#1973223
RE: Graph DB edge tables

Lynn Pettis - Thursday, December 21, 2017 9:41 AM
Jeff Moden - Thursday, December 21, 2017 9:24 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 21, 2017 at 3:51 pm

#1973220

Viewing 15 posts - 13,336 through 13,350 (of 59,101 total)