Search results for query: *

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...

CREATE PROCEDURE [dbo].[usp_emp_detail_i] @emp_number VARCHAR(20), @ref_table Varchar(100)=NULL OUTPUT AS DECLARE @error_int INT INSERT INTO ref_table ( emp_number, name, age ) SELECT emp_id, emp_name, emp_age FROM tbl_primary_info WHERE...

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...

How about using ROWCOUNT 10000 and having a controlled insert and update.Will that help

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...

SQL Server database

Connection to both servers and databases I have done but comparing part is still an issue.becasue its one to one field and data comparison.

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

Is there any other way where I can make this as a coomon function so that can be called from any forms...

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...

The stored procedure used to query and get the records is usp_resale_s @resale_number .... please help me with this...

Here is the table definition..... CREATE TABLE [dbo].[tbl_reinstate] ( [rein_id] [int] IDENTITY (1, 1) NOT NULL , [resale_number] [varchar] (20) NOT NULL , [emp_number] [varchar] (13) NOT NULL , [rein_amount] [money] NULL , [late_charges] [money] NULL , [good_through_date] [datetime] NULL...

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...