Showing posts with label fails. Show all posts
Showing posts with label fails. Show all posts

Tuesday, March 20, 2012

Quarterly Schedule Fails

My data driven report has been scheduled to send last quarters data on the
fifth day of a new quarter.
I set the schedule to send:
Monthly for: Jan, April, July, Oct and on
Calendar Day: 5 at 2am.
For some reason I received the report today, which happens to be May 5.
What am I doing wrong?I also check the system date on the Reporting Services Server, so that's not
the problem. Is there another way to schedule Quarterly report delivery?
"John Broomfield" wrote:
> My data driven report has been scheduled to send last quarters data on the
> fifth day of a new quarter.
> I set the schedule to send:
> Monthly for: Jan, April, July, Oct and on
> Calendar Day: 5 at 2am.
> For some reason I received the report today, which happens to be May 5.
> What am I doing wrong?
>

Monday, March 12, 2012

Qry: update person_course datetimestamp = 10/6/1900 12:00:01 AM fails!

I am trying to modify data in a SQL Server database using the query below. But it fails; why??

update person_course datetimestamp = '10/6/1900 12:00:01 AM' where personid > 470

I get
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'datetimestamp'.You need the key word SET

update person_course SET datetimestamp = '10/6/1900 12:00:01 AM' where personid > 470|||Thanks. I saw it after I had sent the message. Aaarrrgh!!! Long day I guess.