Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,621 through 37,635 (of 59,098 total)

RE: Very Tough CSV Data Import to SQL 2005 DB Table Challenge

Does that mean that you're all set?
--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 18, 2010 at 12:11 pm

#1194647
RE: SUBSTRING coding problem

Agreed... trailing spaces could come into play (and I always forget about them). Nicely done.
--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 18, 2010 at 12:05 pm

#1194646
RE: Generating SubTotals using GROUPING

Hugo Kornelis (7/17/2010)
Jeff Moden (7/16/2010)
Nice job, Sunil. I especially liked the fact that you compared what some folks go through with multiple queries (in one form or another) 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)

July 18, 2010 at 11:55 am

#1194645
RE: Checking expiry dates in a table

magasvs (7/17/2010)
That was Friday's madness 🙂
SELECT * FROM YourTable
WHERE convert (datetime,YourColumn) =
DATEADD(month,1,convert (datetime,convert(varchar(10), getdate(), 101), 101))
Heh... madness indeed.
--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 18, 2010 at 11:52 am

#1194644
RE: Between Statment only for current day

jon pill (7/17/2010)
How can I check that I am permitted to create and amend tables?
Just try it manually, I guess.
--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 18, 2010 at 11:49 am

#1194643
RE: Becoming a business intelligence architect

da-zero (7/17/2010)
Jeff Moden (7/16/2010)
da-zero (7/14/2010)
Jeff Moden (7/13/2010)
Have you got a link for all of the requirements, Steve? Thanks.
:blink:
I think I have an URL where you can download experience. If...
--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 18, 2010 at 11:46 am

#1194642
RE: Are the posted questions getting worse?

Roses are Red,
Violets are Blue,
Some poems rhyme,
But this one don't.
😛
--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 18, 2010 at 11:41 am

#1194641
RE: summing up the previous row values up to date level

jprabha.d (7/16/2010)
Hi All,
How Do we Sum up the Values As Per the Date in a Particular Month ,I am Designing the Report wher i have to Drill Down...
--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 16, 2010 at 10:20 pm

#1194468
RE: Insert data into one table column with multiple values of another table column

How are you controlling the number of times the name goes into the table?
The method I showed you works. What's wrong with using that?
--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 16, 2010 at 10:18 pm

#1194467
RE: How to Increase Query Speed by 3 Orders of Magnitude with no Indexes

MikeAngelastro-571287 (7/14/2010)
I think that replies should avoid attacking the author of an article. That is not productive at all. The author took the initiative to share an experience....
--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 16, 2010 at 10:04 pm

#1194465
RE: Checking expiry dates in a table

magasvs (7/16/2010)
There ar emany ways to do it. This is just an example for the date in character format
Understood. So why not pick a simple way?
--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 16, 2010 at 10:00 pm

#1194464
RE: Checking expiry dates in a table

I don't believe that it needs to be quite that complex. Unless I'm somehow missing the big picture, something like the following should do...
SELECT * FROM dbo.YourTable
...
--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 16, 2010 at 9:55 pm

#1194462
RE: Insert data into one table column with multiple values of another table column

juanpablosiller (7/16/2010)
Hi,
I came to the conclusion that I could insert first the name values and then copy the values of one column to the other, the thing is that they...
--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 16, 2010 at 9:41 pm

#1194459
RE: 64-bit MS SQL 2008 ... is it worth it?

It would be better if MS made the realization that folks will still need to I/O with MS Office products even on 64 bit machines. As a side bar,...
--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 16, 2010 at 8:55 pm

#1194454
RE: All Joins at once, or only when View is queried?

My answer would be... try it. Check the actual execution plans of both methods and the load it puts on resources using SQL Profiler.
--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 16, 2010 at 8:50 pm

#1194452

Viewing 15 posts - 37,621 through 37,635 (of 59,098 total)