Viewing 15 posts - 38,266 through 38,280 (of 39,754 total)
February 18, 2002 at 10:41 am
One thing I can suggest is to remove the <>. Since you cannot test for a non-existence without scanning everything, these tend to be inefficient. If it's only positive numbers,...
February 18, 2002 at 10:37 am
You should have both procedures. When you open the code, the old object, still exists on the server. When you recompile into the new object, you are creating a new...
February 18, 2002 at 10:33 am
Get the results in text or better yet, run this from osql and pipe the results to a file. You will have the header, but that is easily deleted.
Steve Jones
February 18, 2002 at 10:13 am
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
Viewing 15 posts - 38,266 through 38,280 (of 39,754 total)