Viewing 15 posts - 1,021 through 1,035 (of 1,161 total)
One issue with stored procedures in reporting services is that if the stored procedure is quite complex, e.g. has multiple select statements, that SSRS has trouble parsing them correctly to...
April 18, 2013 at 10:50 am
Try this also...
With Member [Measures].[Thing Count YTD] As
AGGREGATE(YTD([Effective Date].[Year-Week].CurrentMember)
, [Measures].[Thing Count] )
SELECT
[Measures].[Thing Count YTD] ON 0,
[Effective Date].[Year-Week].[Week].[2013 Week 6] ON 1
FROM
[Cube]
This keeps whatever it is you are...
April 18, 2013 at 10:42 am
It's good if you still have friends there that can give you a reference. So don't burn your bridges completely.
🙂
April 18, 2013 at 10:30 am
Sorry to hear this. I won't ask for details.
Cheers
April 17, 2013 at 11:41 am
INFORMATION_SCHEMA columns do not have exactly the same information as sys.columns, but it may work depending on the need. Overall, sql server 2000 just does not have all of the...
April 17, 2013 at 10:58 am
Maybe the clustered index that re-arranged the pages created disk fragmentation?
April 17, 2013 at 10:49 am
Also be sure your column emp_status does not contain nulls or else a
emp_status !='01'
will not return the nulled columns. I don't know if this is the intended behavior.
April 17, 2013 at 10:45 am
So you deleted a local user account? Be careful this does not cause issues in other areas.
April 17, 2013 at 10:32 am
Hi,
the total of contracts started in that year, having status different than '101', divided by the total of contracts ended in the previous year
Look into the function "ParallelPeriod" in...
April 11, 2013 at 5:11 pm
The US post office has a NCOA (national change of address) service. They in the process maintain a standardized version of US addresses. There are companies that buy/rent this data...
April 11, 2013 at 4:56 pm
Model your business processes, that will light what are your facts and subsequently your dimensions. If you are familiar with your business this shouldn't trouble you too much.
April 11, 2013 at 4:48 pm
Certainly. Code repository systems work on this concept.
April 11, 2013 at 4:38 pm
there is a record for every application and what term they are starting in, among other things
I wouldn't be surprised if the OP has something similar looking in the relational...
April 11, 2013 at 4:36 pm
I don't believe the forum users in general like the idea of clicking on obscure links.
April 11, 2013 at 11:35 am
Might incorporating this work?
select case when isnumeric(left(DCPI_Date,4))=1
then DCPI_Date
else '19000101'
END
when doing your insert into dbo.Reliance_Master
Then later in your SSIS redirect those rows that have 1900-01-01 as the date to...
April 11, 2013 at 11:33 am
Viewing 15 posts - 1,021 through 1,035 (of 1,161 total)