Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,361 through 12,375 (of 59,095 total)

RE: Recursive with multiple first lines

I've not tested it because I'm on my way to work but I believe this will get you to where you want to be with the character based Supply Job...
--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)

May 11, 2018 at 7:41 am

#1990189
RE: Recursive with multiple first lines

Hmmm.... is there an integer column on the original supply job table that acts like a surrogate key for the Supply Job Number?
--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)

May 11, 2018 at 7:23 am

#1990186
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Friday, May 11, 2018 5:58 AM
Jeff Moden - Thursday, May 10, 2018 10:55 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)

May 11, 2018 at 7:20 am

#1990185
RE: Recursive with multiple first lines

ross.hughes - Friday, May 11, 2018 7:03 AM
Hi Jeff,
I ran in to a little wrinkle in this line:
hPath = CONVERT(VARBINARY(4000),CONVERT(BINARY(4),CONVERT(INT,ISNULL(SupplyJob,'9999999'))))
My Supply...
--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)

May 11, 2018 at 7:14 am

#1990183
RE: Rebuilding Indexes very often is good?

It was great meeting you tonight, Pra. Thank you for the great questions and thank you for introducing yourself. It was a pleasure.
--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)

May 10, 2018 at 10:57 pm

#1990142
RE: Are the posted questions getting worse?

Man, I'm in 7th heaven tonight. Chris Morris was taking a vacation in Florida with some friends that live there and he flew up here today to see myself and Ed...
--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)

May 10, 2018 at 10:55 pm

#1990141
RE: Performance Question

ah0996 - Thursday, May 10, 2018 10:53 AM
Hi there,
I have a performance question here:
how can I rewrite below highlighted area? I 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)

May 10, 2018 at 11:05 am

#1990084
RE: Automated Indexes

Stewart "Arturius" Campbell - Thursday, May 10, 2018 5:44 AM
Jeff Moden - Thursday, May 10, 2018 5:10...
--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)

May 10, 2018 at 9:30 am

#1990067
RE: Has anyone written a Faceted Search like the ElasticUI interface ... all in SQL?

bvaljalo-1000038 - Wednesday, May 9, 2018 4:30 PM
If you go to dubdubdub elasticui dotcom and look at the bottom-most screenshot, I need...
--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)

May 10, 2018 at 5:39 am

#1990010
RE: will this SQL trigger recursive

patrick-330430 - Wednesday, May 9, 2018 10:04 PM
I am new on writing and testing trigger. I am trying to write a trigger...
--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)

May 10, 2018 at 5:28 am

#1990005
RE: Corruption of the file format .mdf

The latest full, dif, and transaction log backups will probably be needed for a restore for this one.
--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)

May 10, 2018 at 5:20 am

#1990004
RE: Automated Indexes

Stewart "Arturius" Campbell - Thursday, May 10, 2018 4:52 AM
Jeff Moden - Thursday, May 10, 2018 12:28...
--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)

May 10, 2018 at 5:10 am

#1990002
RE: One Million Tables

Heh... I advise people against trying to display a million rows even in the Grid and it has no meta-data to resolve. I wouldn't expect the Explorer window to deal...
--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)

May 10, 2018 at 5:03 am

#1990000
RE: Automated Indexes

And yet they can't do a shrinkfile like Peter Norton did 30 years ago and nor can they rebuild an index without temporarily doubling its size and blowing out 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)

May 10, 2018 at 12:28 am

#1989992
RE: Friday the 13th

sgriffin-681047 - Wednesday, May 9, 2018 12:00 PM
A fun challenge! Here's a solution using a recursive cte:
DECLARE @FirstMonth DATE = GETDATE();
;WITH [cte]...
--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)

May 9, 2018 at 8:03 pm

#1989982

Viewing 15 posts - 12,361 through 12,375 (of 59,095 total)