Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,551 through 26,565 (of 59,099 total)

RE: Temporary Stored Procedures

Roland Howard Boorman (6/26/2013)
You still don't get it. It is to simplfy and actually make the logic simpler.
In serious code the level of duplication and associated complexity becomes absurb...
--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 26, 2013 at 2:52 pm

#1627737
RE: Temporary Stored Procedures

Luis Cazares (6/25/2013)
All of those asking for cases on when Temp Stored Procedures would be useful ever read the entire article? At the end, it mentions some acceptable scenarios.
Yes, but...
--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 25, 2013 at 10:00 pm

#1627360
RE: Temporary Stored Procedures

Roland Howard Boorman (6/25/2013)
I have used temporary Stored Procs for many years with XML and inline code they are a very elegant wen used with temporary tables
What were the temporary...
--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 25, 2013 at 8:21 pm

#1627351
RE: Need some eyes on a SP I'm working on

Understood but you have at least one file that made you think you need a Schema.ini file. If we solve that, then it'll be one less thing to worry...
--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 25, 2013 at 3:04 pm

#1627327
RE: Need some eyes on a SP I'm working on

Ah. Understood.
If the data isn't sensitive, could you attach one of the test files so we can see if there's a better way? If it is sensitive, could...
--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 25, 2013 at 1:08 pm

#1627271
RE: Need some eyes on a SP I'm working on

I'm using a Schema.ini file because when I load these files without one, the data becomes garbled.
"Load these files" how and where? I'm asking because one of the biggest...
--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 25, 2013 at 12:40 pm

#1627260
RE: general

Dird (6/25/2013)
Wouldn't you use IS NOT NULL and > 0?
No. NULLs cannot be compared to so they would also be excluded from any check for <> 0. Try...
--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 25, 2013 at 7:46 am

#1627115
RE: Large Records -- No Successfull Result

Minnu (6/24/2013)
when i select * from USG_Data am not gettting the complete result set, after displaying some records sql server displaying that execuing query....
Want to know the reason please.
Actually, this...
--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 25, 2013 at 7:43 am

#1627113
RE: Need some eyes on a SP I'm working on

erikd (6/15/2013)
I'm replying to this mostly because the error I posted was such a quirky little thing that THIS post was coming up (on the only page of results) when...
--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 24, 2013 at 10:09 pm

#1626971
RE: How to format the data in column in sql server

+1000 to that. That's why the script I wrote converted everything to DATETIME.
--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 24, 2013 at 6:29 pm

#1626961
RE: general

Hint: NULLs cannot be compared with the correct defaul sttings. Check just for <> 0.
--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 24, 2013 at 5:06 pm

#1626955
RE: Large Records -- No Successfull Result

Is anyone else using the table? It could be blocking caused by an update or an oddball SELECT.
--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 24, 2013 at 5:01 pm

#1626954
RE: non-correlated subquery failing to fail

Larry.Findley (6/24/2013)
It's just that this seemed so counter intuitive.
Heh... yeah. For me too... I banged my head on the counter a couple of times when I first ran...
--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 24, 2013 at 4:47 pm

#1626952
RE: Append characters in a sentence after certain length

ChrisM@Work (6/20/2013)
Venkata-433090 (6/19/2013)
Thanks for your response. Its kind of when the client retrieves the data.
again, the 32 character count should start from where the pipe was placed.
Shouldn't take too...
--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 24, 2013 at 4:37 pm

#1626951
RE: Append characters in a sentence after certain length

Venkata-433090 (6/24/2013)
Thanks you all guys for your responses. I'll implement this and let you know..
My question would be, what do you want to do with "words" that are more...
--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 24, 2013 at 4:32 pm

#1626950

Viewing 15 posts - 26,551 through 26,565 (of 59,099 total)