Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,006 through 31,020 (of 59,101 total)

RE: How to speed up Running Average View

Heh... I've been thinking about this and have decided that I probably shouldn't post solutions late at night because all the coffee has worn off. I believe that 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)

February 25, 2012 at 8:35 am

#1451702
RE: How to speed up Running Average View

{EDIT} Please see my last coded post on this thread for a better answer.
Ah... got it. Let's rebuild the test using 2,000,000 rows and I'll show you. Read...
--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 24, 2012 at 11:47 pm

#1451679
RE: How to speed up Running Average View

{EDIT} Please see my last coded post on this thread for a better answer.
The real problem is that you don't have the correct indexes on the table. Since 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 24, 2012 at 9:50 pm

#1451676
RE: Passing comma-delimited list as a parameter

Ray K (2/24/2012)
Good article! I especially liked his comment about writing a full retraction to his anti-RBAR ministry! And I'm tempted to run home and make up 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 24, 2012 at 7:39 pm

#1451670
RE: Passing comma-delimited list as a parameter

dwain.c (2/24/2012)
I had a similar problem once and used a string splitter on the list to get what I needed out of it. I happened to choose a SplitString...
--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 24, 2012 at 7:34 pm

#1451668
RE: split data of month into weeks

mahesh15dec1986 (2/24/2012)
Hi Team
i have a data of year 2012 and table structure is (SN ,Name ,DATE,Error) and i need data according to
1 Jan 2012 to 5 Jan 2012- Week...
--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 24, 2012 at 7:11 pm

#1451664
RE: split data of month into weeks

Eugene Elutin (2/24/2012)
Bipinkumar Yadav (2/24/2012)
hi Friend,
Try This way..
DECLARE
@start_date DATETIME,
@end_date DATETIME,
@start_date1 DATETIME,
@end_date1 DATETIME
...
--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 24, 2012 at 7:07 pm

#1451663
RE: split data of month into weeks

binodbabu (2/24/2012)
Bipinkumar Yadav!
i got this error msg when i tried your script. could you please let me know where i am wrong. I am new sql learner.
thanks
Msg 8115, Level 16,...
--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 24, 2012 at 6:55 pm

#1451662
RE: Better option than using Stored procedures

raghuveer126 (2/24/2012)
My team mate suggested me its beter that SQL query be in the report rather than using SP. But i have parameters and how can i put sql...
--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 24, 2012 at 6:49 pm

#1451659
RE: Column Alias name dynamically

Cadavre (2/24/2012)
Wow. . . OK.
This will generate your 11,881,376 (!!) combinations
SELECT a.alpha+b.alpha+c.alpha+d.alpha+e.alpha
FROM (SELECT SUBSTRING('ABCDEFGHIJKLMNOPQRSTUVWXYZ',N,1) AS alpha
FROM (VALUES(1),(2),(3),(4),(5),(6),(7),(8),
...
--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 24, 2012 at 6:43 pm

#1451657
RE: Column Alias name dynamically

Sorry... double post removed.
--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 24, 2012 at 6:41 pm

#1451656
RE: Cursor or multiple update statements (or something else?!)

CELKO (2/24/2012)
CREATE VIEW Applicant_Locations
AS
SELECT A.*, L.location_id
FROM Applicants AS A, Locations AS L
WHERE A.postal_code = L.postal_code;
BWAAA-HAAA!!!!! Joe, you really should read the ANSI Standards so 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)

February 24, 2012 at 6:39 pm

#1451655
RE: i need ideas

mona770118 (2/19/2012)
Jeff
thank you for your reply. I will post sample data tomorrow as I am at home now.
Did you work out an answer?
--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 24, 2012 at 6:14 pm

#1451650
RE: Script to find all objects owned by a user (loginname)

sgtmango333 (2/24/2012)
Ummmm...the failure messages.
BWAAA-HAAA!!! Please post the actual code you're using, the failure messages, and anything else that you might be able to provide to help us help 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)

February 24, 2012 at 5:53 pm

#1451647
RE: Script to find all objects owned by a user (loginname)

sgtmango333 (2/24/2012)
I used the script provided earlier in this thread. Yes, it was a varchar(max) and the resulting query built out to somewhere between 12k and 13k characters.
So, 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)

February 24, 2012 at 3:04 pm

#1451628

Viewing 15 posts - 31,006 through 31,020 (of 59,101 total)