Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SqlHunter

    Email Format Issue

    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 & _...
  2. SqlHunter

    Optional OUTPUT parameter in SP

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

    Error Handling in stored procedure

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

    Optional OUTPUT parameter in SP

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

    Error Handling in stored procedure

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

    Efficient Insert/Update Method problem

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

    Efficient Insert/Update Method problem

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

    Internal Working mechanism in SQl Server

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

    Single transaction Issue

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

    Code for database table comparison

    SQL Server database
  11. SqlHunter

    Code for database table comparison

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

    Code for database table 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.
  13. SqlHunter

    Dynamic RecordSet Issue

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

    Dynamic RecordSet Issue

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

    Dynamic RecordSet Issue

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

    Dynamic RecordSet Issue

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

    executing stored procedures

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

    executing stored procedures

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

    executing stored procedures

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

    executing stored procedures

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

Part and Inventory Search

Back
Top