Viewing 15 posts - 856 through 870 (of 901 total)
I had a similar issue, though my MDX is somewhat basic I found a solution, however in instead of using a Current, we had to use different type of rates...
February 21, 2011 at 3:11 am
I can understand the reason why MS are doing this, it adds on a degree of elitism to the Gold Standard, as it was very very easy to get a...
February 21, 2011 at 1:50 am
I try always and use sets, I cant only think of half a dozen occasions that I've resorted to a cursor, and most of those were due to time constraints...
February 17, 2011 at 8:21 am
Surely your Calendar Dimension has Year, Quarter, Month and Day Attribute Hierarchies?
If it has then simply make the Month Hierarchy visible and replace it as a filter on the Spread...
February 14, 2011 at 6:55 am
You need to use a NOT EXISTS clause (see below)
insert into LapLine_InString
(DateRan
,GearSetSN
,GearSetPN
,MntgDimPinion
,MntgDimGear
,ProdOrderPinion
,ProdOrderGear
,PartNumberPinion
,PartNumberGear
,HighHeadPinion
,RevLevel
,StationID)
select
DateRan
,GearSetSN
,GearSetPN
,MntgDimPinion
,MntgDimGear
,ProdOrderPinion
,ProdOrderGear
,PartNumberPinion
,PartNumberGear
,HighHeadPinion
,RevLevel
,StationID
from tmp_LapLineData_InString
where NOT EXISTS (Select 1 From LapLineData_InString
...
February 9, 2011 at 8:14 am
pgoldy (2/8/2011)
February 8, 2011 at 9:35 am
Goldy it wouldnt as you've already done a distinct Select on the Address which is the same, thus by the time you get to the outer query you only have...
February 8, 2011 at 9:16 am
I'm not sure why you arnt getting data out of the view, I take it you've tested the view in SSMS and its returning data.
Also consider using the 'SQL command'...
February 8, 2011 at 8:43 am
Depending on the the Dev tools your company uses, you could look at VS 2008/2010, as you get built in code analysis tools within the DB projects, and you can...
February 8, 2011 at 8:26 am
murat.korkmaz (2/8/2011)
To much failures, it's confusing, specially for the newbies!
Sorry, but it is a clearly written article and far from confusing. Yes there are a few errors, but they are...
February 8, 2011 at 3:14 am
A good introduction to Distinct for novices, though it it really doesnt explain why you would consider using a Group by to get a distinct list, is there a performance...
February 8, 2011 at 2:05 am
Since SQL 2005 I've tended to use Sys.Partitions over a Select Count(*), especially when I need to get row numbers across all tables in a specified DB and also across...
January 28, 2011 at 2:22 am
You cant delete data out of the SSAS database, it has to be done at the Datasource (data warehouse) level.
You can incrementally process a cube, though it can often be...
January 20, 2011 at 7:40 am
I think I see whats happening, and I hope the following makes sense.
In financial terms if the year is split across years eg Apr 2008-Mar 2008, it is generally...
January 19, 2011 at 2:18 am
aaron,
I had to do something similar in a previous project but it was very much recording departure times of vehicles.
In the end I used a Time Table that had...
January 18, 2011 at 7:04 am
Viewing 15 posts - 856 through 870 (of 901 total)