Search results for query: *

I have a stored procedure to parse a name field. Every once in a while the SQL Data Task will fail stating [Execute SQL Task] Error: Executing the query "SSISParseTheName2" failed with the following error: "The statement has been terminated.". Possible failure reasons: Problems with the...

I have this string 2/1/2012 - 321 2/1/2012 - 213 2/1/2012 - 21 2/1/2012 - 321 2/1/2012 - 231 2/1/2012 - 321 2/1/2012 - l;k;l 2/1/2012 - 546 2/1/2012 - 545 2/1/2012 - 45 2/1/2012 - kl; 2/1/2012 - 55464 1/18/2012 - added web2 1/18/2012 - added falcon 1/17/2012 - that I want to parse to this...

How do I format a field on a SQL Server Reporting Service report to show all of the characters in a date. For January 5, 2008 I get 1/5/2008. I want to show 01/05/2008. The data type in the SQL Server 2005 database is SmallDateTime. Thanks for your help. Penny

I have a VB6 program using an ACCESS database. I have created an EXE and a SETUP package that includes all .OCX files, database, images and EXE. I installed the program on the clients machine but only part of it works. I opened the code on my home machine and the .EDIT action is not present...

I am trying to add two amounts of currency together. I have a function that will subtract them but when I change the minus to a plus it doesn't work. Can anybody tell me what I'm doing wrong? The function that works is: Pass in $333.33 and $111.11 Function CalculateMissing(ByVal Total As...

I am using VB.NET version 7.1. This is NOT a Windows app it is a WEB app. I am converting from VB6. My program interfaces with another program which has a button that puts data on the clipboard. I need a button on my app that when clicked, will paste the data from the clipboard to a specified...

How can I open a VB6 app in a vb.net web form? I have a VB6 application that will accept a parameter that I need to open with a VB.NET Web Form. I tried using Shell("\\ServerName\Folder\ApplicationName.exe ParameterValue") with no luck. Can anybody help. Thanks

Can anyone help me determine the date of the Friday prior to any given day. Ex: Today is Thursday, November 4, 2004. I need a query that will tell me that last Friday was October 29, 2004. Thanks

Does anyone have the code to create a new Catagory to use when scheduling a new job. It gets a bit confusing when everything goes under Uncatagorized.

I am using VB.Net, SQL Server 2000, Windows 2000. I have an application where a user needs to enter a number into three separate text boxes. The first one has a max length of 3, the second, 1 and the third 4. I don't want them to have to tab or click into the next box. How can I tell the...

I am using VB.Net, SQL Server 2000, Windows 2000. I have an application where a user needs to enter a number into three separate text boxes. The first one has a max length of 3, the second, 1 and the third 4. I don't want them to have to tab or click into the next box. How can I tell the...

I have an app that works perfectly fine on a Windows NT 4.0 machine, but when it's installed on a Windows 2000 I get an error while trying to do an update. I am able to Insert a new record but it will not let me update. I am using VB6 and SQL 2000. I created the setup package with Visual...

SQL Server 2000 Windows NT 4.0 Table 1 NumberOfItems (int) Table 2 ItemProcessed (char) Date (datetime) I need a stored procedure that will add the count from ItemProcessed for the current date in Table2 to the NumberOfItem in Table1. If there is already a value in...

I have three tables Table 1 Language Pending Age Table 2 Language Pending Table 3 Language Pending Age I want to write everything from Table 1 into Table 3 and where the Language is the same, add the Pending from...

I have three tables Table 1 Language Pending Age Table 2 Language Pending Table 3 Language Pending Age I want to write everything from Table 1 into Table 3 and where the Language is the same, add the Pending from...

I need help with a probably simple issue. I have a 6 character field that should only contain numbers. When the field is filled VIA the keyboard, stroke by stroke there is no problem because I do a check on every KeyUp. However, a value may be pasted from another app and it may contain alpha...

I have a stored procedure that concatenates two fields into one. The problem is that it puts a space between the two values. I need to know how to either take the space out or how to concatenate them without the space going there in the first place. My stored procedure is as follows: ALTER...

I need to select a record, assign it to a user so no one else can grab it. I am having a terrible time with duplicate records showing up on several machines. I am using VB6 and SQL Server 2000 on an NT 4 workstation.

I have created a DTS package using SQL Server 2000 that will copy a table into an Access database. After the first time the package ran, it failed because the "Create" step failed (of cours it did, the table in Access is already there). I want to Drop the Access table before I...

I was trying to change an index and I received an error "The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space." I tryed (novice) to backup the log by using USE tempdb GO BACKUP log tempdb but that resulted in the message...