Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,821 through 23,835 (of 59,102 total)

RE: How to make the report to display week wise data

pietlinden (4/20/2014)
If you're using a normal database and not an SSAS cube, then you can use a Calendar table. Here's the article on it: http://www.sqlservercentral.com/articles/T-SQL/70482/
Basically, the Calendar table has...
--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)

April 20, 2014 at 9:03 pm

#1707368
RE: Convert Bigint time to datetime

Jack Corbett (4/17/2014)
gbritton1 (4/17/2014)
Something to consider:
select datediff(m, '0001-01-01', '9999-12-31')
returns 119987
That is the largest difference in minutes between the earliest and latest dates handled by SQL Server. 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)

April 20, 2014 at 6:35 pm

#1707360
RE: Convert Bigint time to datetime

gbritton1 (4/17/2014)
Just do it in a loop, ...
I hope your not serious. Let's see the code that does it in a loop.
--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)

April 20, 2014 at 6:33 pm

#1707359
RE: Deployment Failure Heirarchy

cook155 (4/20/2014)
Working on analysis services tutorial where i am modifying measures and my heirarchy and this is my error message.
Warning1Dimension [Date] : Avoid visible attribute hierarchies for attributes used...
--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)

April 20, 2014 at 6:31 pm

#1707358
RE: Get Table Structure of Stored Procedure Output Table

Tom Brown (4/15/2014)
However on this particular project they don't like linked servers/openquery etc - So I don't have the Access level required - and almost certainly the DBA here...
--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)

April 20, 2014 at 6:29 pm

#1707357
RE: Get Table Structure of Stored Procedure Output Table

Ok... I have to ask. What do either of those functions do for creating a table other than returning some meta-data that you could write some dynamic T-SQL 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)

April 20, 2014 at 6:12 pm

#1707355
RE: Unexpected View Performance

@thom-2 Bolin,
I might be the only one but I like the title of "Unexpected View Performance" because use of the UNION operator seems to be much more prevalent in views...
--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)

April 20, 2014 at 5:27 pm

#1707352
RE: Unexpected View Performance

pandeharsh (1/11/2011)
Hi,
Can you draw the conclusion in other words ?
I think a better question would be, after reading the article and doing all of the tests, what is YOUR conclusion?...
--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)

April 20, 2014 at 4:17 pm

#1707348
RE: Unexpected View Performance

N_Muller (4/18/2014)
What would be the expected behavior had the tables been defined with varchar(9) and varchar(10), instead of char(9) and char(10)?
What would you have expected? Do the experiment. ...
--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)

April 20, 2014 at 4:16 pm

#1707347
RE: Calculate the Running Total for the last five Transactions

stephenejones1960 (4/19/2014)
Thanks for the code. I just have a general question: Does someone know how to change the code so that the five items can be multiplied, instead of added?...
--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)

April 20, 2014 at 12:49 pm

#1707337
RE: Are the posted questions getting worse?

WayneS (4/20/2014)
Steve Jones - SSC Editor (4/19/2014)
Greg Edwards-268690 (4/19/2014)
Steve -
Although attention to details is part of or job, I wonder if something could be done at some time to at...
--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)

April 20, 2014 at 12:09 pm

#1707335
RE: Today's Random Word!

Revenant (4/19/2014)
TomThomson (4/19/2014)
rhythmk (4/19/2014)
Ed Wagner (4/18/2014)
Revenant (4/18/2014)
BWFC (4/18/2014)
crookj (4/17/2014)
Ed Wagner (4/17/2014)
SQLRNNR (4/17/2014)
pretense
assumption
postulation
Theory
Science
Thought
Concept
idea
horse (just could not resist, Tom)
Sense.
--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)

April 19, 2014 at 4:04 pm

#1707297
RE: Doing What It Takes To Get The Job Done

Eric M Russell (4/16/2014)
It is possible to create a solution quickly and cheaply and also not sacrifice quality, so long as the scope is constrained. For example, I consider Chipotle...
--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)

April 19, 2014 at 4:00 pm

#1707296
RE: Select all months bewtween two dates

feroz_tt (4/16/2014)
Hi All,
I'm getting some problem here
;with Numbers (Number) as
(select row_number() over (order by object_id)
from sys.all_objects)
select dateadd(month, number, '2014-09-01')
from Numbers
where number <= datediff(month, '2014-09-01', '2016-03-31')
Low no of months.
Select datediff(month,...
--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)

April 19, 2014 at 3:47 pm

#1707294
RE: SQL script to LOOP in and find sequence gap on Unique column

LearnSQL!!! (4/15/2014)
Need help !!!
Example of table structure :
CREATE TABLE [dbo].[MaintenanceTable](
[TableName] [varchar](50) NOT NULL,
[Note] [varchar](250) NULL,
[MaintenanceOrder] [int] NOT NULL,
CONSTRAINT [PK_ReplicationTableMaintenance] PRIMARY KEY CLUSTERED
(
[TableName] ASC,
)WITH ON [PRIMARY],
CONSTRAINT [UNQ_MaintenanceTable_MaintenanceOrder]...
--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)

April 19, 2014 at 3:34 pm

#1707293

Viewing 15 posts - 23,821 through 23,835 (of 59,102 total)