Search results for query: *

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

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

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

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

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

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