Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,701 through 32,715 (of 59,099 total)

RE: Removing redundant information

Isn't there also supposed to be some "deleted" data to go along with that "added" data?
--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 28, 2011 at 5:23 pm

#1374350
RE: Single row to multiple columns

You bet, Karthik... thank you for the feedback.
--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 28, 2011 at 5:18 pm

#1374349
RE: Are the posted questions getting worse?

GilaMonster (8/28/2011)
WayneS (8/28/2011)
Jeff Moden (8/27/2011)
Gosh... outright theft of articles just keeps getting worse and even more blatant. Take a look at the following and then click on the Feb/Mar...
--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 28, 2011 at 4:57 pm

#1374347
RE: unique problem with t-sql

J Livingston SQL (8/28/2011)
Jeff Moden (8/28/2011)
nairdeepa (8/27/2011)
Hi Jeff,
I am not clear on what you just said. could you please elaborate?
Many thanks,
Gah covered that pretty well for me. He also...
--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 28, 2011 at 4:48 pm

#1374345
RE: unique problem with t-sql

nairdeepa (8/27/2011)
Hi Jeff,
I am not clear on what you just said. could you please elaborate?
Many thanks,
Gah covered that pretty well for me. He also provided an example of how...
--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 28, 2011 at 12:28 pm

#1374313
RE: Are the posted questions getting worse?

Gosh... outright theft of articles just keeps getting worse and even more blatant. Take a look at the following and then click on the Feb/Mar 2009 magazine release to...
--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 27, 2011 at 9:19 pm

#1374273
RE: How to loop through files in a specified folder, load one by one from source folder and copy to destination folder using SQL stored procedure.

Yeah, you're right, of course. Old habits die hard.
--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 27, 2011 at 6:37 pm

#1374268
RE: comparing ip addresses in sql

Bruce W Cassidy (8/22/2011)
My suggestion would be to use varbinary(16). Convert the formatted strings (either in IP4 or IP6 format) into varbinary and go from there. IP6 addresses...
--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 27, 2011 at 5:14 pm

#1374263
RE: How to loop through files in a specified folder, load one by one from source folder and copy to destination folder using SQL stored procedure.

Sarath Vellampalli (8/27/2011)
Hi All,
How to loop through files in a specified folder, load one by one from source folder and copy to destination folder using SQL stored procedure.
My requirement is,...
--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 27, 2011 at 4:18 pm

#1374260
RE: unique problem with t-sql

nairdeepa (8/27/2011)
well i solved the problem..was excited to share how i did it:
with abc as
(select client_order_number,mmc_vendor,max(session_order) as 'max_session' from
dbo.tmp_coremetrics_order_lookup
group by client_order_number,mmc_vendor)
,abc1 as
(select * from dbo.tmp_coremetrics_order_lookup x
where x.client_order_number in...
--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 27, 2011 at 4:14 pm

#1374259
RE: Running totals

I had a thought about this last night and didn't want to proceed until I had an answer because, depending on the answer, we might be able to simplify 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)

August 27, 2011 at 10:09 am

#1374246
RE: import flat file through SSIS

Chelo (8/26/2011)
hi there! sorry I didn't get back to you, but got caught with work stuff. I briefly tried the code you sent against a txt file I created...
--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 26, 2011 at 8:08 pm

#1374179
RE: HELP...need to speed this up, taking +15 hrs now. Goal: insert rows for missing dates, based on previous date

This should do the trick for you. I didn't take the time to make much data from your original post so you might have to play with indexes to...
--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 26, 2011 at 7:45 pm

#1374176
RE: import flat file through SSIS

Marcelo,
Did that do it for you or are you still having problems?
--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 26, 2011 at 4:08 pm

#1374147
RE: Massive Blocking

Hi Orlando,
I know you know this but it'll make me feel a lot better if I say it out loud... I don't allow vendors such access. The "rule" is...
--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 26, 2011 at 4:03 pm

#1374146

Viewing 15 posts - 32,701 through 32,715 (of 59,099 total)