Viewing 15 posts - 16 through 30 (of 38 total)
Thanks ChrisM@Work, it worked with adding (maxrecursion 365);
at the end.
Later on I'll have to find a way how to do the same thing in the Cube, as it...
January 21, 2013 at 7:32 am
Thanks for idea @demonfox, you have got it right. But how to change it to fit my ChrisM@Work code.
Here is DDL:
--===== Create the table
CREATE TABLE...
January 18, 2013 at 7:25 am
The result is same with my previous query, I think I couldn't explain it right. By requirement for the column remaining it had to sum up all previous remaining cases....
January 16, 2013 at 8:31 pm
Thanks ChrisM@Work, it looks promising. I never thought of minus from total 🙂
just having following error, any idea how to fix that?
Msg 207, Level 16, State 1, Line 22
Invalid column...
January 16, 2013 at 9:33 am
It's too late but still,
I'd suggest you set the CHECKPOINTING to OFF in the job step. It's under the Execution options tab.
January 7, 2013 at 8:24 am
You were right Mackers,
All the time I was changing wrong DSN :w00t:. Forgot that the package works with system DNS only while running in job, and it uses User...
October 22, 2012 at 8:16 pm
I've built that, but you will need to turn those information to numbers in order to create measures. Cube without measure is impossible. Let's say u want to see number...
August 25, 2011 at 12:12 am
Jeff Moden (5/6/2010)
There've been a lot of answers to this question and they could all be unnecessary because SQL Server is very forgiving for most date formats. With that...
June 11, 2011 at 12:43 am
Hi gupta.sreekanth,
I'm not that expert in scripting, but for the starting u may use following i guess:
Select SUBSTRING(dbo.Table.Column, 0, CHARINDEX('-', dbo.Table.Column, 1,)) as Column1
March 1, 2011 at 12:09 am
Thank you very much bro, it's working pretty well, just little problem is my supervisor asked me not to use temp table, as there gonna be huge DB, in this...
November 11, 2010 at 1:00 am
Thanks Craig Farrell for that, it's running.
But when I run it on real data getting a massage: 'timeout expired'. Then I run it on 10 data only on...
November 10, 2010 at 11:57 pm
I guess it was slowly changing dimension, topic is closed
October 21, 2010 at 1:35 am
Thanks to Jan Van der Eecken, it's working exactly as I wanted :-):-)
ColdCoffee, that one i tried already, that flags the first day of last 2nd month also. If it...
June 4, 2010 at 3:29 am
That didn't help Wayne, just starts flagging second day of the month. In your note all of them are giving first day of month, week... What I need here, is...
June 3, 2010 at 10:56 pm
Viewing 15 posts - 16 through 30 (of 38 total)