Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,246 through 31,260 (of 59,101 total)

RE: Calculating Year to Date total

johnitech.itech (2/6/2012)
check these about ur problem
http://www.sqlhacks.com/Summary/Running_Total
http://www.databasejournal.com/features/mssql/article.php/3112381/SQL-Server-Calculating-Running-Totals-Subtotals-and-Grand-Total-Without-a-Cursor.htm
I'd recommend NOT using either of those methods because they both employ a "Triangular Join" which will crush your server even for relatively small sets...
--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)

February 6, 2012 at 7:36 am

#1443130
RE: Load data from excel sheet to table

Koen Verbeeck (2/5/2012)
Jeff Moden (2/5/2012)
As a sidebar, I generally don't import directly from Excel spreadsheets because you can't tell when someone might have it open. I usually tell people...
--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)

February 5, 2012 at 10:53 pm

#1442895
RE: Query question

ssc_san (2/5/2012)
Hi Jeff,
I am using it to populate list of values for my report. And it is not going to change in the future (As per User), So I took...
--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)

February 5, 2012 at 10:51 pm

#1442894
RE: Duplicate record delete

weston_086 (2/5/2012)
with cte (id,name,class,rn)
as
(select id,name,class,ROW_NUMBER() over (PARTITION by id ,name,class order by ID) from jtdup)
delete from cte
where rn>1;
select * from jtdup
That won't work if the name column is actually...
--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)

February 5, 2012 at 10:47 pm

#1442893
RE: Null values with unique key constraint

I could be wrong but I'm pretty sure it can't be done. Unique columns allow only one NULL. You might be able to pull something off with 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)

February 5, 2012 at 8:56 pm

#1442883
RE: ssis and ssrs interview questions

quynh012012 (1/6/2012)
quynh012012 (1/3/2012)
Hi,
I do not agreed with you. Any way, your points of view make me thinking about some thing for my project.
Pls try to keep posting. Tks and best...
--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)

February 5, 2012 at 7:25 pm

#1442879
RE: Please fix the "Pretty Print" class in the forums and the article "Contribution Center"

Steve Jones - SSC Editor (2/5/2012)
Noted, and passed to the publishing team.
1. I'm not sure how easy the first item is to fix, but we'll see. Definitely an issue.
2. Again,...
--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)

February 5, 2012 at 7:04 pm

#1442878
RE: Please fix the "Pretty Print" class in the forums and the article "Contribution Center"

Phil Factor (2/5/2012)
[font="Courier New"]
WITH
cteSomeCTE AS
(--==== This is Jeff's 1st test comment
SELECT yadayada
FROM sometable
)--==== This Jeff's 2nd test comment
SELECT *
FROM cteSomeCTE[/font]
Well the poor old prettifier works with...
--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)

February 5, 2012 at 6:57 pm

#1442877
RE: insert multiple rows with a trigger that invoke a function

Mark-101232 (1/18/2012)
If you can change the INSERT, you don't need the trigger at all
INSERT INTO Customer(CustomerId,Name,Value,Percentage)
SELECT CustomerId,Name,Value,dbo.GetPercentage(Value)
FROM CustomerTemp
BWAAA-HAAA!!!! MARK FOR PRESIDENT! :-D;-)
--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)

February 5, 2012 at 4:50 pm

#1442869
RE: Is there a better way to set local variables in a stored procedure?

CELKO (1/17/2012)
Please tell me that you do n ot really use BIT flags in SQL. That mess was 1950's assembly language, before we had high level abstract languages. .
Interesting....
--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)

February 5, 2012 at 4:45 pm

#1442868
RE: Not sure how to...

asm1212 (1/20/2012)
Populate this Contract Number field in the database...
Fields are SSN, Contract_Number, Effective_Date, Term_Date...
Here is the breakdown:
Think of this process as a Contract...For each contract, we have a SSN, 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)

February 5, 2012 at 4:24 pm

#1442867
RE: Question about GETDATE()

Robert Murphy UK1 (1/20/2012)
If you are going to reuse the GETDATE() result for multiple statements then you must assign it's value to a variable as you are proposing. For 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)

February 5, 2012 at 4:14 pm

#1442866
RE: Parse data

Just checking. Are you all set on this or do you need more help?
--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)

February 5, 2012 at 4:00 pm

#1442864
RE: Best practice

sampathsoft (2/1/2012)
So let me know this method (joinig tables/ outer join) is good for performance ...
Heh... "It Depends". How long does it currently take to run and how big...
--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)

February 5, 2012 at 3:47 pm

#1442863
RE: Only System Administrator can specify WITH

ALZDBA (2/1/2012)
Take control over your proprietary error codes and declare your own messages ( and alerts if needed )
Have a look at sp_addmessage in BOL:
exec sp_addmessage [ @msgnum = ]...
--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)

February 5, 2012 at 2:58 pm

#1442860

Viewing 15 posts - 31,246 through 31,260 (of 59,101 total)