henrik staun poulsen (2/17/2006)

---

I just had the same problem.

Ihad to enable DatabaseMail on the SQL Server Agent -> properties -> Alert System (check the checkbox), and then restart SQL Server...

Glen (9/25/2008)

---

There is one more scenario. It is using synonyms in SQL 2005.

In this case this is "granted by design". You need to recreate synonym if the table on...

ARGH!

Well that helped, thanks. 🙂 On to the next step -- DOING something with the result!

Steve Jones - Editor (3/4/2009)

---

Angry Boy,

I sense some frustration, and I can definitely understand that. SSIS can be a bit annoying as you get used to it.

Does this help?

Just wanted to close this post with the answer in case anyone is searching for it.

Change the parameter type from Boolean to Integer. Change the value that goes with...

TKD-BB: Thanks, I had the same question and your two-textboxes method solved it nicely!

Edit: Then I noticed page two of this thread, saw the problem with Excel export and changed...

That's an interesting way to do it... I don't fully understand it! I'm going to have to read it a few more times and look up PARTITION. 🙂

However,...

Success! This works with my four rows of sample data....

create view viewDutyDay as

select

resourceId

, activityId

, DATEADD(dd,CAST(DATEDIFF(DAY,'17530101',startDay) AS INT),'17530101') as startDayNoTime

, sum(hours) as TotalDutyHours

from dutyday

group by resourceId, activityId, DATEADD(dd,CAST(DATEDIFF(DAY,'17530101',startDay) AS...

I have the beginnings of a thought forming. Tell me if this makes sense....

Create a view for both DutyDay and FlightDay that ignores the time portion of the startTime...

What I would like to see is something like this:

ActivityId, Hours, StartTime, EndTime

1, 1.9, Sep 5 08:59, Sep 5 10:54

1, 2.6, Sep 4 12:52, Sep 4 15:26

1, 2.9, Sep 4...

Okay, I'm back.

So what I need to do is create a report that shows the individual start and stop times from the FlightDay table, and give a total number of...

Thanks, I changed my regional settings. It's not ideal but it'll do the trick. I'm using SSRS 2005 so the other option you mentioned doesn't exist.

Any...

Thanks, Andrew. My library doesn't have the title you suggested but they do have "Data warehouse toolkit : the complete guide to dimensional modeling" by Ralph Kimball. I'll...

I'm great at writing queries 🙂 I started out as a programmer, and I've learned SQL as I went along, with a couple of courses here & there. ...

SQL. The username and password are stored within the application, so it logs on with that.

But in order for the user to get to the application in...