Search results for query: *

The following update query is taking a long time to complete - (the longest it has run is 20 minutes before being stopped.) UPDATE SelectedContactsTbl SET SumDonations2 = (SELECT sum(DonationValue) FROM MailManNonProf.dbo.donations d WHERE SelectedContactsTbl.ContactID =...

How's this for weird. The following query is times out. While it is running an exclusvie Extent lock is created in temp db which doesn't let go. SELECT jobid FROM INVSwitchTransvalidtbl WHERE JobID IN (SELECT JobID FROM INVJobsTbl WHERE periodid = 23) If i use a differnet periodid in...

SQL 2000, I am trying to pass an Output param from a Stored Proc (using Exec SQL Task) to a DTS global variable. This is the SQL task: declare @retval int execute @retval = dbo.usp_test select @retval as rv I am able to map the parameter to a Global variable and the SQL task works OK but...

SQL 2000, VB 6 I have a DTS package that imports a text file and inserts rows into a DB table; two separate tasks on the same database. I can run it fine from Enterprise manager. However when I convert it to VB (and add the DTS reference) I find that the Insert task is successful but the...

The following batch aggregates records in one (INVSwitchTransValidTbl)and inserts the aggregates in table INVJobsTbl. It then gets the GUID created for the Jobs records and updates the records in INVSwitchTransValidTbl which formed the aggregates. The script takes about 30 seconds to process...

Using SQL2000 on a Win 2000 network environment, I am trying to connect to an Access DB located on a different machine by adding it as a linked server. The linked server appears to be created but when I try to access the linked server's tables folder (using Enterprise Manager) I get an...

I am importing a CSV file to a DB table using DTS.(SQL 2000) The destination table has defaults set for all NOT NULL fields. Eg Create Table TableName ( field1 ... , field2 ... , CustomerExists bit NOT NULL DEFAULT 0 ) I find that when a NULL is encountered in the import file, rather than...

I want to create a select query that joins two tables from two differnent Databases residing on the same instance of instance of SQL Server 2000. Is there any way of doing this other than setting up one of the Dbs as a linked server? Yael

Im running SQL 2K. Have created a Linked Server for an Access database. This seems ok in that i can see the tables listed under the linked server in Enterprise mangager. However when I go to run a select query for the Linked DB I get Server: Msg 7357, Level 16, State 2, Line 1 Could not...

I am trying to determine the cache hit ratio a server running SQL2000 on Windows 2000. When I use DBCC Perfmon command in Query analyser I get a ratio of 99.999. However, when using the Cache-Hit counter through NT's Performance monitor the ratio is around 65.00. Which am I to believe? The...

In this small test app there are two forms. The first from creates an instance of the second form then opens it: Private Sub Command1_Click() Dim f as New Form2 f.show End Sub The second form (Form2) has the following code: Private m_Regionid As Integer ______________________...

I want to display values in combo box but hide key data for each row. (With Listview or treeview you can just use the Key property but Combobox doesn't have this.) When the user hits a command button on the same form I want the Key value corresponding to the selected value in the combo to be...

I am calling the following sp using ADO from VB: [code]BEGIN INSERT INTO IMPListAssocRecipientTbl values(@ListID,@ReceipientID,@ReceipientLastName,@ListName) IF (@@error <> 0) OR (@@rowcount <> 1) BEGIN RETURN 999 END END [\code] If the error/rowcount condition is not met I get a...

How can I to determined the nesting level of the selecteditem of a Treeview. The node object has no such property. If there were an IsChild property it would be possible to increment a value in a loop until Ischild = False. But there are such properties. Any ideas anyone?

I am trying to find out how a client is inserting a row into a particular table in a SQLSvr2000 database. I have run a trace on SQL profiler while performing the insert operation from the Client interface (via a browser).I have set the trace to look for RPCCompleted and SQLBatchcompleted...

I have a class that executes a SQL stored procedure, supplying it with parameters. The sp is used for updating individual DB records and is executed every time a user clicks an update button; quite often. My question is, where should I open the DB connection? I'm relucted to use an existing...

Dear clever commrades, I am trying to excute an sp on SQLSvr200 from VB using ADO. The sp has two input parameters and one OUTPUT param. I am passing the two input parameters but SQL Server seems to be expecting the OUTPUT param as well. The SP: ALTER PROC uspTest (@OP int OUTPUT, @Listid...