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.

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...

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...

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...

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

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...

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...

I guess it was slowly changing dimension, topic is closed

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...

It's int, Abhijit.

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...

Finally passed from misunderstandings 😀

I've created a table to insert a result to a table

CREATE TABLE [dbo].[Result](

[Staff No] [nvarchar](50) NULL,

[Staff Name] [nvarchar](50) NULL,

[DateIn] [datetime] NULL,

[DateOut] [datetime] NULL,

[Duration] [float] NULL,

[DateNumber] [int]...

Hi Forum,

I'm so sorry that I posted the same massage again and again. I'm totally new, and I didn't realize that my posts are getting to the next page....

Hi Jeff Moden.

I face some problems while building the cube. Need your help to finish the project. Can we sum total seconds by day, and do splitting by day if...

Hi Jeff Moden.

I face some problems while building the cube. Need your help to finish the project. Can we sum total seconds by day, and do splitting by day if...