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

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

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

I was trying to execute a a stored procedure from VB application and its giving me some error."Item canot be found in the collection corressponding to the requested name or ordinal". Is there anything Iam missing.....Please help me with that..... Dim cmd As ADODB.Command Dim prm As...

How can use join in VB where I have list of emp_id's in a listbox.... Dim x As String x = Join(list1, ", ") ..This gives an error...Here list 1 has around 25 emp_id's and I want it to join to make a string out of it..PLease help me with that

This code is to display record set in a data grid Dim sql_status As String sql_status = "Select active_id,refer_id,process_name,process_type,process_start_date, process_end_date from tbl_active_log where refer_id = '" & txt_refer.Text & "' order by active_id" Here I pass the string to the...

Here iam stuck to get a combination of query for reportings..... Create table tbl_emp_status ( emp_id varchar(20), std_id int, status char(1) ) insert into tbl_emp_status (emp_id,std_id,status) values (1005370,2323,'N') insert into tbl_emp_status (emp_id,std_id,status) values...

Here I have a table called tbl_items item_id emp_id date amount 1 2345 12/12/2004 100 4 2345 01/01/2005 200 5 4567 03/03/2005 500 7 4567 05/05/2005 NULL Please somebody help me with this query.I need to get the amount for the max date of the same emp_ids say result shoould be...

Here I have a column called on_description and I want to update this column to like where there is OMP_ to KLM_ and even if there is multiple instances the result should be KLM_ on_description --------------- OMP_Seras OMP_OMP_OMP_OMP_uong OMP_OMP_Mike OMP_OMP_OMP_OMP_Angel result should be...

item_id emp_id entry_date description initial_amount other 1 1090554 09/27/04 MA STARTED 2 1090554 09/29/04 MA COMPLETED 5000.00 55000 34 2388601 04/15/02 MA STARTED 35 2388601 04/24/02 MA COMPLETED 22000.00 122000 36 2388601 10/09/02 MA STARTED 37 2388601 10/16/02 MA...

Here basically iam stuck with issue of converting row data to column . tbl_emp_codes tek_id emp_id emp_name emp_code AK-0000002 39569 Rek Broc 99504 AK-0000002 39566 Rek Broc 99501 AK-0000002 39568 Rek Broc 99503 AK-0000002 39570 Rek Broc 99505 AK-0000002 39571 Rek Broc 99506 AK-0000002...

I want to select a max(prop) id from table1 and update it in table2 something like this update tbl_prop_log set a.ref_id=max(b.ref_id) from tbl_prop_loga ,tbl_sale_detail b where a.prop_id in(select prop_id from tbl_sale_detail)and a.ref_id IS NULL This gives an error..please help me with this...

table Count quote_count TBS_count Offer_count Repay 65 14 3 50 payment 336 4 10 70 Here the the first countis the count of the table tbl_repay, The second quote_count is the count of the payid present in tbl_repay and tbl_quote 3rd TBS_count is...

I have an DTS to which dumps data from server1 database1 table1 to server2 datbase 2 table 2.the only problem here is when I insert records I don't want to insert the records which already is present in the destination.IS there any way to do this

Here I am facing a performance issue...I have around 15000 emp_numbers sitting in one table called tbl_emp_numbers and I need to use a query for summary report.basically its for knowing how much entry has been done in each table.The case I have written here is 3 but there are 10 more with...