Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,111 through 37,125 (of 59,072 total)

RE: Plzz help me in replacing the cursor with Normal Sql Statements

inampudianil (8/24/2010)
Hey Wayne,
Any update on this..plzz help me out..:-)
I'd help but I just don't have the time to fix your data and table so they work together. If 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 24, 2010 at 6:49 pm

#1211395
RE: Plzz help me in replacing the cursor with Normal Sql Statements

WayneS (8/10/2010)
See how this works for you.
-- since you already have a clustered index, we need to dump the table to a temp table
-- where we can build the clustered...
--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 24, 2010 at 6:41 pm

#1211394
RE: Plzz help me in replacing the cursor with Normal Sql Statements

Mike01 (8/13/2010)
How about using a CTE?
Mike... 2k forum. 🙂
--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 24, 2010 at 6:40 pm

#1211393
RE: Performance tuning

TheSQLGuru (8/24/2010)
1) You should do it when it needs to be done. many variables to that answer.
And, remember, if you do it while you're writing code by following best...
--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 24, 2010 at 6:34 pm

#1211391
RE: Normalize a table query

jayraj0071 (8/24/2010)
Try soemthing like this!!!
select ID, [Description], Field =
case when ID = 1 then Field1
...
--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 24, 2010 at 6:18 pm

#1211388
RE: Decoupling in Relational Databases

Shawn.Shi (8/24/2010)
SQL ServerCentra.com should validate new posts.
Articles like this waste space and readers' time, and of course should be filtered out.
I've seen many sites (some quite famous and quite popular...
--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 24, 2010 at 5:56 pm

#1211385
RE: array & multilist

harshinderkaur (8/24/2010)
thanx for replying jeff. i want to create a table named book & an array to store the name of authors(maximum 10) of any book . each author name...
--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 24, 2010 at 5:47 pm

#1211383
RE: The Semantics of NULL in SQL Server 2008

Hugo Kornelis (8/24/2010)
Alex-668179 (8/24/2010)
Yes, I find that a lot of the confusion goes away by not calling NULL a "value" but seeing as a state (or state indicator).
Agreed. I think...
--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 24, 2010 at 6:41 am

#1210962
RE: The Semantics of NULL in SQL Server 2008

Hugo Kornelis (8/24/2010)
I rated this article "poor". A lot of the information is correct, and relevant - but there is a very important error, right at the start of 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)

August 24, 2010 at 6:14 am

#1210950
RE: XP_cmdshell DIR

chrs-513176 (8/23/2010)
The file size is greater than 2GB. Is that the max this method can return? Unfortunately, I'm still on 2000 so CLR is not an option for me.
The 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)

August 23, 2010 at 10:01 pm

#1210778
RE: tsql retrieve records on date

Thanks, Kingston. 🙂
--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 23, 2010 at 9:56 pm

#1210775
RE: Today's Random Word!

dbowlin (8/23/2010)
Ray K (8/23/2010)
Brandie Tarvin (8/23/2010)
flood
"Noah . . . I want you to build an ark . . . "
Lord...What's an ark? (From an old Bill Cosby stand...
--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 23, 2010 at 9:54 pm

#1210774
RE: SQL for normalizing repeating groups in a text file

marerose888 (8/23/2010)
I created a table in Access (don't have access to SQL server today) with the repeating fields of colors, then ran sql in my ETL tool and I got...
--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 23, 2010 at 9:49 pm

#1210773
RE: Search part of string within part of string

Gosh... I just wouldn't do this, folks. Too many possible problems. For example, there's just no guarantee that the following orgs are the same org...
The Society for Back...
--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 23, 2010 at 9:48 pm

#1210772
RE: Linking to the Previous Row

niyinks (8/23/2010)
ItemID OldPrice RangePrice ...
--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 23, 2010 at 9:39 pm

#1210770

Viewing 15 posts - 37,111 through 37,125 (of 59,072 total)