Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,796 through 33,810 (of 59,099 total)

RE: Comparing strings

My recommendation would be to lookup the "LIKE" operator in Books Online.
--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)

May 31, 2011 at 7:24 pm

#1332329
RE: PK Identity as a convention, always more effective when there is a single int natural key?

Grant Fritchey (5/29/2011)
You're right, this can be practically a religious war.
Heh... "It Depends". In my shop, they do it my way or I take them out for a nice...
--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)

May 31, 2011 at 7:22 pm

#1332328
RE: DW NOVICE Question - How Best To Exploit OLAP

Just to add one more that you already have access to... do a search in the BOL index for "Tutorial".
--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)

May 31, 2011 at 7:20 pm

#1332327
RE: Inserting Blank Rows in the Output

Almost forgot... here're the stats output from my desktop...
(100000 row(s) affected)
(100000 row(s) affected)
SQL Server Execution Times:
CPU time = 625 ms, elapsed time = 3332 ms.
(100099 row(s)...
--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)

May 31, 2011 at 7:15 pm

#1332325
RE: Inserting Blank Rows in the Output

What I've found is that if a "pretty" graphical output isn't required, that it takes a whole lot longer to transfer the data to something like SSRS or Crystal, time...
--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)

May 31, 2011 at 7:09 pm

#1332324
RE: dynamic sql

Lucky9 (5/31/2011)
I have to write a stored procedure which serves as a universal stored procedure for all the tables in the database...
From the application side he will pass me 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)

May 31, 2011 at 5:37 pm

#1332312
RE: dynamic sql

CELKO (5/31/2011)
Do you also believe in the Magical, Universal Elixir that will cure all diseases and restore youth?
Hell YES!!! It's called "Beer"! 😀
--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)

May 31, 2011 at 5:24 pm

#1332311
RE: HTML Report using SQL

opc.three (5/31/2011)
(replaces sp_makewebtask too
BWAA-HAAA!!!! In my eyes, there will never be a sufficient replacement for that wonderful tool. 🙂
--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)

May 31, 2011 at 5:22 pm

#1332310
RE: Concatinating the results of selected rows

Hi Thomas.
Nice setup. Thanks.
If you write the code to return the food ID and the list of animals that like the food (food ID and animal name make 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)

May 31, 2011 at 5:19 pm

#1332309
RE: Are the posted questions getting worse?

The Dixie Flatline (5/31/2011)
Could 42 possibly be the airspeed velocity of an unladen swallow?
Nope... it's the terminal velocity for a pork chop with a bone in it. 😀
--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)

May 31, 2011 at 4:36 pm

#1332301
RE: Are the posted questions getting worse?

SQLRNNR (5/31/2011)
Craig Farrell (5/28/2011)
*chanting*
I will not smack Syed with a heavy hand...
I will not smack Syed with a heavy hand...
I will not smack...
*mumbles off to another room, still chanting*
I'm thinking...
--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)

May 31, 2011 at 4:33 pm

#1332298
RE: Problem With Recursive CTE

David-155102 (5/31/2011)
Jeff/Magoo,
Thanks both for your suggestions; I've very quickly tested Magoo's code against my sample data and it does return the expected results. I'm going to need a bit 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)

May 31, 2011 at 6:12 am

#1331916
RE: Query Help

flash.rsn (5/29/2011)
CREATE TABLE tbl
(
APC DATETIME ,
ACS DATETIME ,
AET...
--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)

May 31, 2011 at 12:00 am

#1331798
RE: Query Help

CELKO (5/29/2011)
...we hate all procedural code! I have written five cursors in my career and I know I would not need to use three of the five today.
But 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)

May 30, 2011 at 11:54 pm

#1331794
RE: Problem With Recursive CTE

Magoo's code seems to do the trick for leaf-node detection. I decided to go "Full Monty" so that other "questions" could be asked of the hierarchy.
First, here's...
--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)

May 30, 2011 at 10:56 pm

#1331783

Viewing 15 posts - 33,796 through 33,810 (of 59,099 total)