Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,901 through 42,915 (of 59,063 total)

RE: split batch to get time

Karthik,
There is nothing in that data nor in the table to establish the order of the rows. You know you cannot rely on such a thing as the "natural...
--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)

July 19, 2009 at 9:11 pm

#1026697
RE: split field into numbers and join to table

So, Jamie... now you have 3 tables to maintain instead of just 2. The real problem is this table...
MakeID Make CategoryIDs
1 Dell 1,2,3
2 Sony 1,2
It's not normalized. Tables...
--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)

July 19, 2009 at 9:03 pm

#1026692
RE: Tsql query help

srathna77 (7/17/2009)
Can you please let me know how to do in batch process.
Did any of that work for 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)

July 19, 2009 at 9:00 pm

#1026689
RE: Rewriting a complex function as Inline

J-F,
Did you ever figure out how to do 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)

July 19, 2009 at 8:52 pm

#1026688
RE: How to add values into a variable?

lopes80andre (7/16/2009)
Lowell (7/16/2009)
it should work with some minor tweaks:
after you've done the DECLARE @acumul_error varchar(100) or whatever it is, you need to initialize it as an empty string:
SET @acumul_error...
--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)

July 19, 2009 at 8:44 pm

#1026687
RE: query running now for over 3 hours

kevinwinters (7/14/2009)
yes, that is the exact query.
*every* row of that field is null, I am trying to make every row of that field blank so I can concatenate the field...
--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)

July 19, 2009 at 8:39 pm

#1026686
RE: how to search in sql by using like operator

Here's what I'm talking about... the details are in the comments in the code below...
--===== Create and populate a test table to demo with.
-- 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)

July 19, 2009 at 8:29 pm

#1026684
RE: how to search in sql by using like operator

Doylie (7/15/2009)
.....ignore the bits in the comments that say "comma". they are meant to say "space". I have stolen this code from somewhere else and missed a few bits.
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)

July 19, 2009 at 7:59 pm

#1026680
RE: Concatenate variable length rows

Jez (7/16/2009)
I have a series of text file which I have import into a table with a single column spanning the whole line in the file and using a variation...
--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)

July 19, 2009 at 7:53 pm

#1026678
RE: Time difference in hh.mm

So, Arunkumar ... does that mean you actually have an answer to your problem or are you just posting another bit of problem code.
I know that you think what 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)

July 19, 2009 at 7:47 pm

#1026677
RE: calculate totals between dates?

ekla_pathik (7/15/2009)
You may have Customer_Created_Date in Customer table. And you have Sales_Date in Sales Table.
You can use
SELECT COUNT(Customer_ID) FROM Customer
WHERE Customer_Created_Date BETWEEN Sales_Date_1 AND Sales_Date_2
For Sales_Date_1 and 2,...
--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)

July 19, 2009 at 7:29 pm

#1026676
RE: Pivot query problem - can this be done ?

kramaswamy (7/17/2009)
I ran through your post Jeff, I'm wondering if you're doing things any differently than the way I posted in my solution. I think I actually had been originally...
--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)

July 19, 2009 at 7:21 pm

#1026674
RE: What's the job market like for remote dba work?

It's real simple, Ron... [font="Arial Black"]MIL-TP-41[/font] which stands for "Make It Like The Print For Once". Another way of putting it is "Say what you do and then do...
--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)

July 19, 2009 at 7:15 pm

#1026673
RE: study topic suggestions for 70-444

If you follow the training kit, you will undoubtably succeed.
--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)

July 19, 2009 at 4:07 pm

#1026666
RE: What's the job market like for remote dba work?

Just my 2 cents... I've never been satisfied with the service of remote DBA's (nor in house DBA's) and I'm trying to kill all such remote contracts.
Pradeep... I've seen your...
--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)

July 19, 2009 at 4:03 pm

#1026665

Viewing 15 posts - 42,901 through 42,915 (of 59,063 total)