I have done this before but the server I tested with is no longer around so I a little lost. These are my only 2 other thoughts. Try

Select * from...

Look at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306649 should answer your question.

Also the way you are doing yuo update would be better, especially if you do a multi row update if you do the following

update...

I have never tried but the databases except possibly master but I don't see why not should restore fine to a non-clustered server. You may have to specific the restore...

As table x is an identity column you cannot normally update it so this should handle the insert.

CREATE TRIGGER trigger_name

ON x

FOR INSERT

AS

INSERT INTO z (col1) SELECT col1 from inserted

"Don't...

Not sure you can do both, what are you trying to accomplish?

You could try to parse but I know of no date format that will directly support YYYYMM in sql...

Sorry, jaspenles sound right. I must have been trippin with that last one as I completely threw it wrong.

"Don't roll your eyes at me. I will tape them in place."...

No but it does sound iteresting, if you get to work do post to the script library if you don't mind sharing.

"Don't roll your eyes at me. I will tape...

Problem I see here is it looks at startdate = startdate to decide to update startdate to startdate which for them to meet must already be so. Is this right...

Won't say it will help but try

SELECT MONTH(count_date) as cal_month

FROM DateListTable

WHERE count_date is not null

GROUP BY MONTH(count_date)

Or DATEPART(m,count_date). Also is this column indexed? If not might bennefit from one but...

The sp is the code that checks for condition alerts to notify you about. You may have the box bogged down by something else that is causing this one not...

The < is backwards you have to use > to get everything 7 days back thru today plus you need a DATEADD with day as datepart to work on -7...

Duplicate post, see reponses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3982&FORUM_ID=5&CAT_ID=1&Topic_Title=trigger+to+update+2nd+table&Forum_Title=Administration

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Try

CREATE TRIGGER trigger_name

ON x

FOR INSERT, UPDATE

AS

If UPDATE(col1)

BEGIN

update z set col1= x.col1 from x

END

insert into x values (6)

The go ends the code completely.

"Don't roll your eyes at...

Try the service pack then 5a plus post 5a patch and see if problem goes away.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...

Move the file thru Windows Explorer then just alter the @filename path associated with it to match.

"Don't roll your eyes at me. I will tape them in place." (Teacher on...