Viewing 15 posts - 38,236 through 38,250 (of 39,720 total)
February 18, 2002 at 9:55 am
Thanks for the update. For anyone reading, the correct way to do this is:
CREATE TRIGGER [tr_addtotimeline] ON [paper_orders]
FOR INSERT
AS
DECLARE @publication_id INT
DECLARE @delivery_date DATETIME
/* get pub_id and date from the...
February 18, 2002 at 9:52 am
I tend to agree with Andy from your description.
I've run some inventory things and for reconciliation and high accuracy, we used to use separate tables for calculations.
Steve Jones
February 18, 2002 at 9:48 am
Yikes. Can't see doing that. I'd have to strangle someone if they insisted on my sending them a db to update.
Steve Jones
February 16, 2002 at 11:03 am
February 16, 2002 at 10:56 am
February 15, 2002 at 4:31 pm
Not sure what's wrong. I'd try the install and then search for all files changed in the last day. Should clue you in.
Steve Jones
February 15, 2002 at 4:28 pm
February 15, 2002 at 3:46 pm
no reg expressions. I have a tamestrings series that looks at some tricks, but none are really a "grep".
http://www.sqlservercentral.com/columnists/sjones/tamethosestringspart7.asp
Steve Jones
February 15, 2002 at 3:45 pm
Having such a table is definitely the fastest way to do it, but you have to maintain that table. I built a system where we did this and the first...
February 15, 2002 at 3:44 pm
February 15, 2002 at 3:42 pm
February 15, 2002 at 3:42 pm
February 15, 2002 at 2:24 pm
I've got a few articles on how I do it.
http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart2.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart4.asp
Steve Jones
February 15, 2002 at 2:21 pm
Is this the only word in the field? If not, you might need to do:
IF EXISTS (SELECT rma FROM table1
WHERE rma like '%end' )
to get end at the end of...
February 15, 2002 at 2:19 pm
Viewing 15 posts - 38,236 through 38,250 (of 39,720 total)