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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sh211618

  1. sh211618

    Publish - Specify location on client pc?

    Hi, I'm using the Publish functionality from Visual Studio 2005 to create an installation package for an application. I publish to a UNC path and everything works fine. I am just wondering if it is possible to define the directory the application has to be installed to on the client PC...
  2. sh211618

    Stored procedure from VB.Net takes ages

    Christiaan, Probably my last post crossed yours :-) I started trying to find the slowest part and thought it was in the split function, but after the recreation everything look ok.... Yes, I'm indeed running SSMS locally. The cmpcode (which means company code) is varchar(2000) as we can have...
  3. sh211618

    Stored procedure from VB.Net takes ages

    I am totally puzzled. I changed the stored procedure a bit (replaced the line "and h.cmpcode in ( select value from dbo.ulv_general_Split(@cmpcode,',') )" with "h.cmpcode in ('RUNV','LUCR')" and everything worked fine and quick. I changed it back to the original line and recreated the...
  4. sh211618

    Stored procedure from VB.Net takes ages

    I used the following code to fill a normal datatable: [code]Imports System.Data.SqlClient Module MainModule Sub Main() Dim connectionString As String = _ "Data Source=cgtsapp20320\cgtssql20008;Initial Catalog=CSDD001e;Integrated Security=True" Dim connection As...
  5. sh211618

    Stored procedure from VB.Net takes ages

    Hi Christiaan, The resulting dataset is not very large. The coding for the stored procedure is; CREATE PROCEDURE [dbo].[ulv_bcs_phtrc_GetEl4Documents] ( @cmpcode varchar(2000), @el1from varchar(72), @el1to varchar(72), @year smallint, @periodto smallint, @debitcreditind smallint ) AS...
  6. sh211618

    Stored procedure from VB.Net takes ages

    Hello, I have a stored procedure with a number of input parameters on SQL Server 2000. This stored procedure is accessing quite large tables and returning a dataset. When I run this procedure on via SQL server Management Studio, the procedure is finished within a second, either with or...
See more

Part and Inventory Search

Back
Top