CLASSIC !

Martin (2/29/2008)

---

Thanks so far, given me some ideas, though that last one didn't work only brought out records that have the startdate as today, but I need to get records...

Sure ....

IF EXISTS (SELECT 1 FROM inserted WHERE yourField = 'yourTestValue')

BEGIN

-- your trigger code here

END

OPPS... EDITED!! I forgot ot add the...

Sure ....

IF (SELECT 1 FROM inserted WHERE yourField = 'yourTestValue')

BEGIN

-- your trigger code here

END

Like John said ...

SELECT DISTINCT

REPLACE(StaffName,'''''',' ') AS StaffName

,OutReason

,OutStartDate

,OutEndDate

,OutStartTime

...

First off, it looks like you need to swap the Staff List and out of office views around.

select ... FROM StafList LEFT JOIN outOfOffice ...

Secondly, can you post the...

=IIF(A.Value<B.Value,(A.Value/1000)*C.Value,C.Value)

you can figure out the rest from here ... 😀

My previous post should still work.

You don't need to replace them.

declare @representative varchar(255)

set @representative= 'Victaulic'

exec ('

select me.Member_Id, UPPER(me.Member_Name)as Member_Name, me.Member_City, me.Member_State, me.Member_Fax

from members me, Manufacturers m, Manufacturers_Categories mc, Categories c, Representations r

where me.Member_Id =...

Thanks!

Although that's really odd that the "Drop if exists" setting controls the scripting of the entire object. :hehe:

How about this...?

DECLARE @dates TABLE (pNo INT, val VARCHAR(10), effDate DATETIME, expDate DATETIME)

INSERT @dates

SELECT 1,'01','1/1/2006','3/31/2006' UNION

SELECT 1,'01','2/1/2006','3/31/2006' UNION

...

In my understanding, they are functionally the same. The benefit I see is that it's easier to read using COALESCE.

There is a way, and someone emailed me a link to that article. I'll search for it tonight and post it once I find it.

This may or may not be your problem, but I'm guessing it is. When you rename the job it "breaks" the connection to Reporting Services. RS uses the GUID (job...

http://www.sqlservercentral.com/articles/Development/2824/