Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,551 through 14,565 (of 59,101 total)

RE: Best Approach For Junction Table Mainrenace

I know it's an old post but consider an "On Cascade Delete" key or a "Delete" trigger for the DELETEs..
--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)

August 22, 2017 at 10:19 pm

#1956282
RE: export data to Excel using sql stored procedure

polo.csit - Tuesday, April 11, 2017 7:39 AM
I'm having a Sql Table which contains 1000 records...Now i want to export this records...
--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)

August 22, 2017 at 10:10 pm

#1956279
RE: Practical usage of SQLCLR: Building QueryToHtml function

Darko Martinovic - Tuesday, June 6, 2017 11:22 AM
the sqlist - Tuesday, June 6, 2017 8:34 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)

August 22, 2017 at 10:06 pm

#1956278
RE: Practical usage of SQLCLR: Building QueryToHtml function

Darko Martinovic - Tuesday, June 6, 2017 12:49 AM
Sergiy - Monday, June 5, 2017 5:50 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)

August 22, 2017 at 9:47 pm

#1956276
RE: Practical usage of SQLCLR: Building QueryToHtml function

Darko Martinovic - Tuesday, June 6, 2017 12:45 AM
Orlando Colamatteo - Monday, June 5, 2017 6:40 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)

August 22, 2017 at 9:43 pm

#1956274
RE: Practical usage of SQLCLR: Building QueryToHtml function

Sergiy - Monday, June 5, 2017 5:50 AM
Once again - Thank you so much Microsoft for ditching sp_makewebtask.
12 years on - people...
--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)

August 22, 2017 at 9:41 pm

#1956272
RE: Practical usage of SQLCLR: Building QueryToHtml function

Darko Martinovic - Tuesday, June 6, 2017 12:42 AM
Theo Ekelmans - Monday, June 5, 2017 1:20 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)

August 22, 2017 at 9:41 pm

#1956271
RE: Practical usage of SQLCLR: Building QueryToHtml function

Orlando Colamatteo - Monday, June 5, 2017 6:40 AM
Well done. I appreciate the effort required to put an article like this together...
--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)

August 22, 2017 at 9:28 pm

#1956269
RE: Downside of a large number of script tasks in SSIS projects?

ash.j.hoff - Monday, July 17, 2017 5:26 PM
Hi Folks,
I am currently working on a SSIS project that has many sub packages, 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)

August 22, 2017 at 9:00 pm

#1956268
RE: Data flow concept - Thoughts wanted

So how'd things work out for you?
--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)

August 22, 2017 at 8:50 pm

#1956266
RE: Flat File with out headers

So how'd things work out for you?
--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)

August 22, 2017 at 8:48 pm

#1956265
RE: How to access another server temp table without any Linked server

Heh... or just do it all in T-SQL.
--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)

August 22, 2017 at 8:43 pm

#1956264
RE: Importing a Long named Excel Sheet with Spaces

Thom A - Thursday, August 17, 2017 8:33 AM
So, I felt like trying something "stupid". The file is definitely an xls (1997-2003)...
--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)

August 22, 2017 at 8:39 pm

#1956263
RE: Polling and determine the status of a job?

Jeff Moden - Tuesday, August 22, 2017 8:32 PM
info 58414 - Monday, August 14, 2017 9:29 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)

August 22, 2017 at 8:34 pm

#1956262
RE: Polling and determine the status of a job?

info 58414 - Monday, August 14, 2017 9:29 AM
Hi,
I want to get a message from a RemoteServer when a certain SQL 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)

August 22, 2017 at 8:32 pm

#1956261

Viewing 15 posts - 14,551 through 14,565 (of 59,101 total)