Viewing 15 posts - 376 through 390 (of 621 total)
metalray (10/12/2008)
The data is imported froman excel file.
I know this is a SQL forum, but there are times when I, and this is just me, find it easier to do...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 28, 2008 at 9:45 pm
What sticks out to me is you did not name the data type of @sql when you declared it.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 28, 2008 at 8:50 pm
Garadin (10/28/2008)
The first question is, how important is this data?
Also, does that sp actually run for you? I'm getting invalid length parameter passed to substring function based on the...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 28, 2008 at 8:46 pm
Seth
Thanks for the reply. Probably I should have mentioned that I am using the result set only as a starting set of job numbers. Certainly there are going...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 28, 2008 at 8:25 pm
sel, you could try something like this
CREATE TRIGGER tr_test_trigger
ON YourTable
FOR INSERT
AS
IF @@ROWCOUNT = 0 RETURN
IF (SELECT COUNT(*) FROM YourTable) > = 400
BEGIN
Run your alert...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 28, 2008 at 1:08 pm
Good luck, and note that my solution above will work for you, as I tested it on an Oracle server. In Oracle, || replaces + in concatanation.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 28, 2008 at 10:04 am
rbarryyoung (10/28/2008)
The only string function that I can think of that is valid in the target of an assignment is STUFF(), which may fit your bill.
The OP is using Oracle,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 28, 2008 at 7:20 am
I don't believe you can update a substring of a field in place. What you will have to do is add the portion you want to keep to the...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 28, 2008 at 6:41 am
Molly, maybe this would be easier...
WHERE DATEDIFF(m,asofdate,GETDATE()) < = 13
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 27, 2008 at 2:11 pm
This will show them to you...
SELECT
*
FROM tblAdd
WHERE address LIKE '%"%'
To remove them, look up REPLACE in BOL.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 27, 2008 at 10:17 am
Ahh, what relief. I get it, the trigger would fire when it updates the field in question, which would cause it to fire again. Never thought of that....
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 25, 2008 at 2:23 pm
Matt Miller (10/21/2008)
Just be sure to disable recursive triggers...:)
Now wait a minute...no one ever mentioned that one to me before. I'm not sure exactly what that means. ...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 24, 2008 at 2:18 pm
john.steinbeck (10/24/2008)
Is my code that messed up to work only once in awhile?
John, that's a pretty subjective question, but there are countless auditing methods out there. I found one...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 24, 2008 at 8:04 am
John
I'm not sure about a MDB, but with ADP, all permissions come from the Server, not the Access front end. I believe the a MDB has built in user...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 24, 2008 at 7:40 am
John
Did you grant insert permission to public on tblAuditLog? That might cause it to not work for others. Just a thought.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 23, 2008 at 6:13 pm
Viewing 15 posts - 376 through 390 (of 621 total)