Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,726 through 40,740 (of 59,070 total)

RE: Confusing set of strings!

Step 1... make sure the code works as is.
Step 2... do a simple replace of ' with '' (two single quotes)
Step 3... add a ' to the very begining and...
--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)

December 9, 2009 at 11:10 pm

#1090359
RE: counting rows in a table

Bru Medishetty (12/9/2009)
schauhan13 (12/9/2009)
Solution:-
SELECT COUNT(*) AS Expr1
FROM (SELECT partnbr
...
--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)

December 9, 2009 at 11:05 pm

#1090357
RE: How to see password

As a side bar... make it company policy that there's a $5 charge for this just as if they'd lost their badge. One of two things will happen after...
--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)

December 9, 2009 at 11:04 pm

#1090356
RE: How to write self join query

sk.panda (12/9/2009)
Dear All,
Below given is the emp table i want to self join.
How to findout empno.'s manager name
employee table
empno. empfname emplname ...
--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)

December 9, 2009 at 10:56 pm

#1090352
RE: File move

Steve Jones - Editor (12/9/2009)
I would not use T-SQL to do this. User VBScript or the Powershell scripting languages to do this. They are better suited to work with files.
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)

December 9, 2009 at 10:53 pm

#1090350
RE: How to do a Grouped, Comma Separated List

Now... I helped you. Please help me. Please explain what the business requirement is to denormalize the data in such a fashion. In other words, why does...
--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)

December 9, 2009 at 10:46 pm

#1090349
RE: spliting the data using replace function

Divide'n'Conquer...
DECLARE @TestString VARCHAR(100);
SELECT @TestString = 'Number=122time=1209/n/n/nonsite=1240/n/n';
WITH
cteStart AS
(
SELECT SUBSTRING(@TestString,CHARINDEX('Number=' ,@TestString)+7,100) AS NumberStart,
SUBSTRING(@TestString,CHARINDEX('time=' ,@TestString)+5,100) AS TimeStart,
...
--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)

December 9, 2009 at 10:40 pm

#1090347
RE: Bogus data entry question

Hmmm... are you saying that the only time you want to return a count is when an EEX is followed by a CO2 that's ten day or less appart?
--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)

December 9, 2009 at 10:27 pm

#1090345
RE: Table partition for each week

sqlquery-101401 (12/9/2009)
I am looking to partition my table for 52 weeks (Per week)
Sure... let's start off by asking the single most important question about this... Why? Knowing "why"...
--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)

December 9, 2009 at 10:14 pm

#1090344
RE: change password

http://tinyurl.com/ygapycy
--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)

December 9, 2009 at 10:01 pm

#1090343
RE: Fetch the most used/retrieved rows from a table

I'm with Grant and Jack on this one... I don't know of a way to do this without changing the queries.
IF you wanted to change the queries, change them from...
--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)

December 9, 2009 at 9:56 pm

#1090342
RE: Get Out of Your Comfort Zone!

Heh... "Think outside the box". Good article, Andy. I have a framed sign on my desk that I actually commissioned an artist friend to draw for me. ...
--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)

December 9, 2009 at 9:48 pm

#1090340
RE: What do I do now? (have fun with this...)

Hmmmm... I've also seen something similar to this about 10 years ago. So, on the flip side of the coin... she's only right if she can actually do what...
--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)

December 9, 2009 at 9:39 pm

#1090339
RE: Replace cursor with while loop / compare cursor with while loop / optimize cursor

Lynn Pettis (12/9/2009)
Jeff Moden (12/9/2009)
Lynn Pettis (12/9/2009)
If Jeff suggested that you do this, I suggest you figure out how to write the query using a while loop. Give 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)

December 9, 2009 at 9:25 pm

#1090337
RE: Replace cursor with while loop / compare cursor with while loop / optimize cursor

clive-421796 (12/9/2009)
Hi Lynn, I attached the script to create the table and insert the data.
Please view attachment: script for tmpTable1.rar
Does absolutely nothing for me... I can't open a .rar file...
--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)

December 9, 2009 at 9:13 pm

#1090335

Viewing 15 posts - 40,726 through 40,740 (of 59,070 total)