Viewing 15 posts - 601 through 615 (of 1,183 total)
CLASSIC !
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 29, 2008 at 10:10 am
Martin (2/29/2008)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 29, 2008 at 8:57 am
Sure ....
IF EXISTS (SELECT 1 FROM inserted WHERE yourField = 'yourTestValue')
BEGIN
-- your trigger code here
END
OPPS... EDITED!! I forgot ot add the...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 29, 2008 at 8:42 am
Sure ....
IF (SELECT 1 FROM inserted WHERE yourField = 'yourTestValue')
BEGIN
-- your trigger code here
END
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 29, 2008 at 8:40 am
Like John said ...
SELECT DISTINCT
REPLACE(StaffName,'''''',' ') AS StaffName
,OutReason
,OutStartDate
,OutEndDate
,OutStartTime
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 29, 2008 at 8:34 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 29, 2008 at 8:13 am
=IIF(A.Value<B.Value,(A.Value/1000)*C.Value,C.Value)
you can figure out the rest from here ... 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 29, 2008 at 7:07 am
My previous post should still work.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 27, 2008 at 1:09 pm
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 =...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 27, 2008 at 10:30 am
Thanks!
Although that's really odd that the "Drop if exists" setting controls the scripting of the entire object. :hehe:
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 27, 2008 at 10:27 am
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
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 26, 2008 at 10:48 am
In my understanding, they are functionally the same. The benefit I see is that it's easier to read using COALESCE.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 15, 2008 at 11:58 am
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.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 13, 2008 at 1:39 pm
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 13, 2008 at 7:59 am
http://www.sqlservercentral.com/articles/Development/2824/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 12, 2008 at 9:46 am
Viewing 15 posts - 601 through 615 (of 1,183 total)