Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,881 through 50,895 (of 59,098 total)

RE: Ordereing an IP address

Casting to an INT should actually run a bit faster over a large number of rows.
--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)

April 30, 2008 at 8:55 am

#809108
RE: Performance Problem

While you're at it... check to see what other traces you have running. Too many or the wrong kind of trace will also slow the world to a crawl.
--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)

April 30, 2008 at 8:54 am

#809106
RE: Find Last Day of Month

The code I posted work without error on my end. If you are typing, are you sure that your typing a zero and not an "OH"?
You know the rules......
--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)

April 30, 2008 at 8:53 am

#809105
RE: Combine multiple rows

Bruna (4/30/2008)
I dont know, Its dynamic...
Could be 3-4-5-6... 🙁
Putts (4/30/2008)
Dynamic is gonna cause the problem there......maybe someone else knows a way of doing a SELECT statement with a dynamic 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)

April 30, 2008 at 8:38 am

#809080
RE: User Defined Function - Passing and Processing a Table

Matt Miller (4/30/2008)
I was being funny last night - just remember the "math" version and the "stats" version actually give you different results (based on their different definitions)....
Not a problem......
--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)

April 30, 2008 at 8:05 am

#809048
RE: cursor through user databases the SEQUEL

Do you have a database with a name like %customer%???
--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)

April 30, 2008 at 8:01 am

#809046
RE: Ordereing an IP address

hb21l6 (4/30/2008)
Appologies guys,
I only needed a SQL line to run from an ASP page, I didn't want to do this through an SP as there is more going 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)

April 30, 2008 at 7:49 am

#809037
RE: Dynamic View creation is taking long time

It's not possible to help without knowing either the content of the various variables or you printing out the value of the variable you're trying to execute.
--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)

April 30, 2008 at 7:03 am

#809012
RE: Table modified

Sorry, Rajesh... didn't see the last line of your post... same idea.
--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)

April 29, 2008 at 11:57 pm

#808813
RE: Should I Buy a Kindle?

I wish all books came on a DVD... easy to search, easy to carry. Of course, a couple/three 1,400 page books make a pretty good anti-terrorist weapon on a...
--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)

April 29, 2008 at 11:56 pm

#808812
RE: Table modified

PhilPacha (4/25/2008)
If there are no foreign keys on the table, simply TRUNCATE TABLE [YourTableName]
Hey guys! Didn't you see PhilPacha's post? That's the way to do it... truncating a...
--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)

April 29, 2008 at 11:52 pm

#808810
RE: Row-By-Row Processing Without Cursor

Ummm, then why did you post that you wanted to process rows one at a time? We've all said that's a bad thing... what is it that you're trying...
--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)

April 29, 2008 at 11:46 pm

#808807
RE: Fetch Row by Row with out using cursor

The other thing to be considered, it what the new rows are in the RecipeLine table are... you'll need to pass those ID's back to the GUI, won't 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)

April 29, 2008 at 11:40 pm

#808805
RE: Fetch Row by Row with out using cursor

Oh, crud... I just thought of this... If you're using it for that, it's possible that two people could conflict with each other and get the wrong rows...
We've gotta come...
--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)

April 29, 2008 at 11:35 pm

#808801
RE: Fetch Row by Row with out using cursor

shalini_pdi (4/29/2008)
from one location to other location to reduce the time of dataentry
Perfect... that's what I was looking for. Thank you so much.
--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)

April 29, 2008 at 11:33 pm

#808799

Viewing 15 posts - 50,881 through 50,895 (of 59,098 total)