Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,656 through 26,670 (of 59,099 total)

RE: Display all the days in a months in a matrix

mysorian (6/10/2013)
Use a parametrized query.
Yeah... and all you have to do to get to the Moon is build a rocket ship that will support human life.
Seriously... post some code....
--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)

June 10, 2013 at 8:40 pm

#1622683
RE: Delay in Print

Krishna1 (6/9/2013)
Dear All
I have procedure A,B,C. Procedure A calls B and C. Procedure B and C have loops and print statement in the loop (for me to understand whats happning)....
--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)

June 10, 2013 at 4:56 pm

#1622661
RE: Delay in Print

OTF (6/10/2013)
You can use the RAISERROR Statment with the NO WAIT option to achieve the behaviour you want.
You should probably tell the "rest of the story" there. 😉
--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)

June 10, 2013 at 4:46 pm

#1622658
RE: Accelerator products such as Fusion IO

TheSQLGuru (6/10/2013)
Tim Walker. (6/10/2013)
Can anyone share their experiences with accelerator products such as Fusion IO?
I'm interested to know how easy they are to implement and what benefits / issues 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)

June 10, 2013 at 4:31 pm

#1622653
RE: please help

arun1_m1 (6/10/2013)
Hi,
For the past few days...
Past few "[font="Arial Black"]days[/font]"??? :blink: BWAAA-HAAAA!!!!! Welcome to America where a whole lot of people have had the same problem for the past few...
--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)

June 10, 2013 at 4:20 pm

#1622648
RE: The Importance of Reading Comments

Nice article, Mannie. Yes... I absolutely agree. Reading the comments is important. That's why most of the scripts I post on the forums say "Details are in...
--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)

June 10, 2013 at 4:03 pm

#1622647
RE: DB Size Growing after moving fields

scorchpc 96170 (6/10/2013)
will do, I'll let you guys know the results
Thanks again!
Simplify the code by removing the FILLFACTOR part of the code. The indexes will rebuild with the original...
--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)

June 10, 2013 at 2:36 pm

#1622631
RE: How to get results from an SP into a table.

ben.brugman (6/10/2013)
Sean Lange (6/10/2013)
Secondly, this now has to create a second connection to the same server. Yes it can be done but you have to jump through a lot of...
--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)

June 10, 2013 at 2:33 pm

#1622629
RE: How to get results from an SP into a table.

Sean Lange (6/10/2013)
g_demetriou (6/10/2013)
IIRC you can use OPENROWSET after the FROM clause
It is a bit more complicated than that. First of all you have to have ad hoc queries turned...
--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)

June 10, 2013 at 1:17 pm

#1622601
RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

opc.three (6/10/2013)
Eh, and really, who needs it? 😀
Everyone who wants to avoid increasing the surface area by firing up SSIS. 😉
--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)

June 10, 2013 at 1:07 pm

#1622597
RE: Are the posted questions getting worse?

Kingston Dhasian (6/6/2013)
dwain.c (6/5/2013)
Stefan Krzywicki (6/5/2013)
Don't you hate it when you finally figure out a solution for a difficult problem and it creates 5 more problems that the old way...
--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)

June 10, 2013 at 12:59 pm

#1622589
RE: Are the posted questions getting worse?

The Dixie Flatline (6/4/2013)
Jeff Moden (6/4/2013)
Brandie Tarvin (6/4/2013)
My Recovery Plan
1) SCREAM really loudly so everyone knows there is a problem.
2) Run out of the building as fast as possible.
3) Update...
--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)

June 10, 2013 at 12:53 pm

#1622585
RE: Are the posted questions getting worse?

Brandie Tarvin (6/7/2013)
...users can always find a way to mess with our data no matter how dummy-proof we make it.
Idiot's Razor: "If you make something idiot proof, only idiots will...
--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)

June 10, 2013 at 12:52 pm

#1622584
RE: Are the posted questions getting worse?

Brandie Tarvin (6/7/2013)
Overheard from a boss / co-worker conversation:
Co-worker points out problems with future process.
Boss responds: "Don't bring reality into this..."
And yes, he was joking. It was a commentary on...
--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)

June 10, 2013 at 12:43 pm

#1622581
RE: help getting return of function and loop into stored proc

plivingstone (6/10/2013)
hi,
it would be Tuesday
An example from last month:
May 27th was Bank Hoiliday Monday, so if the [Date] columns shows any date after 22nd May then it cannot be deleted.
So...
--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)

June 10, 2013 at 12:41 pm

#1622579

Viewing 15 posts - 26,656 through 26,670 (of 59,099 total)