Viewing 15 posts - 16 through 30 (of 594 total)
It is not my proc. From error message, it is clearly a security context issue. When I run:
master..xp_sendmail @recipients='blah@blah.com', @message='Hello from SERVERXXX'
I receive the...
October 16, 2003 at 7:41 am
Well, I use this to get the contents of a file into a temp table. I'm sure you can figure out how to cursor through the rows and build...
October 16, 2003 at 6:53 am
quote:
CREATE FUNCTION dbo.f_TransParts(@part int, @comp int)RETURNS tinyint AS
BEGIN
DECLARE @Transitive table(Part int)
INSERT @Transitive
SELECT Part
FROM Bom WHERE Comp = @Part
WHILE @@ROWCOUNT > 0
INSERT @Transitive
SELECT...
September 19, 2003 at 1:46 pm
Scrap the whole thing and use Windows network logins. Use SQL Server and Windows authentication (sometimes called mixed mode). In Enterprise Manager, right click the DB, go to...
September 19, 2003 at 1:35 pm
This is more than likely to be something that your interface and design should handle. If you can't standardize to something similar to my first suggestion, you will probably...
September 19, 2003 at 12:39 pm
quote:
...What about building a table that has all the indirect relations.
...
What purpose would such a...
September 19, 2003 at 9:35 am
In my experience, the performance results have depended on the size of the dataset being manipulated. SQL Server uses slightly different methods of creating worktables and temporary tables. ...
September 19, 2003 at 6:14 am
No, the functionality you are describing is unique to SQL2K in its User Defined Functions and TABLE datatype.
--
You will have to use temporary tables, AFAIK.
September 18, 2003 at 3:59 pm
Your procedure will have to do a self-join from itself to a derived table of itself that is grouped by the primary key you are describing. In order to...
September 18, 2003 at 3:58 pm
Use SCOPE_IDENTITY instead of @@IDENTITY. Check out BOL for more info.
September 18, 2003 at 3:49 pm
If you are using SQL2K and the resultset is less than ~10K records or so, you can use a TABLE datatype to store the return. If not on SQL2K...
September 18, 2003 at 3:45 pm
The job is not what is taking so long...it's the stored procedures that it runs. Go ahead and post the procedure and we'll take a look for mistakes or...
September 18, 2003 at 3:40 pm
One way might be to structure the component part number to follow a logical greater than rule. Meaning: no component can have a component with a part number greater...
September 18, 2003 at 1:24 pm
Consider the OPTION (FAST n) (See BOL) for your client. Is it absolutely necessary to return that many rows? Also, if you post the query, we could help...
September 18, 2003 at 12:06 pm
Not quite sure what you are asking for. What would the parameters for your procedure be, and what would you want to return?
September 18, 2003 at 11:53 am
Viewing 15 posts - 16 through 30 (of 594 total)