This is a part of the activex script of DTS package which sends out a mail.Is there any way I can format better than this
like a table which has 2 columns 1. Process Name 2.Record Count
oSendMailTask.MessageText = "**********PLEASE DO NOT REPLY TO THIS EMAIL ADDRESS*********" & VbCrLf & _...
have 3 stored procedure
1. Main Sp
2. Module Sp
3. Detail level SP
Eg:
usp_populate_ivoc is the main SP
I have module sp like usp_emp_info which is called inside the main Sp
I have different Sps called inside the Sp usp_emp_info
1. usp_emp_detail_i
2. usp_emp_address_i
3. usp_emp_contact_i...
Can this be used as a solution
DECLARE @error_sp INT
EXECUTE @error_int = usp_emp_info @emp_number,@error_sp OUTPUT
-- Error Handling Section
IF @error_int <> 0
BEGIN
SET @error_sp = 1
RETURN @error_int
AND then use something like this in the module SP
IF (@Error_int <> 0 )
BEGIN
IF...
have 3 stored procedure
1. Main Sp
2. Module Sp
3. Detail level SP
Eg:
usp_populate_ivoc is the main SP
I have module sp like usp_emp_info which is called inside the main Sp
I have different Sps called inside the Sp usp_emp_info
1. usp_emp_i
2. usp_emp_address_i
3. usp_emp_contact_i
4...
I finshed a project where from flat file all the information is processed in a staging database and then from the staging it inserts/updates information into the production tables using stored procedures.
There was 2 options here since the file was small in size.
1. Mass update and insert in a...
Iam using a stored procedure where the @emp_number is the input parameter and I want to know how internally this both queries work and which gives more performance....
SELECT
emp_name,emp_number,emp_state,emp_address,emp_status
FROM
tbl_emp_info
WHERE
emp_id = (
select max(emp_id) from...
I took this specific paragraph from http://www.sql-server-performance.com/blocking.asp
Avoid INSERTing, UPDATEing, or DELETEing large numbers of records in a single transaction. If you do, all the records affected by your action will be locked until the transaction is done. If you find that you...
I have to compare dataset in two database in 2 different servers.Could some help starting the code.some program like SQL Compare which gives compares the data in 2 database tables and reports if there is a difference.
Here I tried adding this code to the modules and then called from one for like dbrecorset.fnSQL_RS(strSQL) where
dbrecorset is the module name and strSQL is sql statement it was giving an error at rs.open and was going to Err_Function:
Is there anything regarding the CursorLocation,CursorType...
But can I put this code under the class module or module so that it gives me the corressponding record and it can be called from any form in the project
Here When I write this function in a form and try to run the program by passing the sql statement and it gives me back the correct record set and works fine...Now I want to use this function as a generic one..So I tried putting this one in class module and module then it gave me an error at the...
Thanks for all the assistance u all are giving.......
Its giving the message
MsgBox "No records returned"
and when I execute the stored procedure on the same database with the paramter its gives a record....I went into the database table and checked for the data and its available there....Now...
The stored procedure is as shown below
CREATE PROCEDURE dbo.usp_resale_s
@resale_number varchar(20)
AS
BEGIN
SELECT
rein_id,emp_number,rein_amount,late_charges,
CONVERT(varchar(8), good_through_date, 1)
AS good_through_date
FROM...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.