• MS Access Date Conversion in a Query

    I have a start date field in a table, I need to calculate a completion date that is 6 months later but it must also be a Friday. I know how to calculate the 6 months part but I don't know how to advance the date to a Friday. For instance if the start date is 4/15/13 then the completion date must be...

    mac3225 pointsBadges:
  • AS/400 VB script to actual date

    Hi, I need to make a marco by VB code to put actual date in AS/400

    korupa20 pointsBadges:
  • What is the best way to execute SQL statements in a CL program.

    What is the best way to execute SQL statements in a CL program? We can run SQL statements in a RPG program. I want to delete some records from a file using the SQL delete statement then organize it.

    SHhand25 pointsBadges:
  • What are the technical capabilities for Parrot versus other VMs?

    This is more of a general question: I know Parrot is the virtual machine that was originally designed for Perl 6.I'm actually trying to figure out what the technical capabilities Parrot"s VM offers against other competing VMs (Java Virtual Machine/Common Language Runtime)? Thanks!

    ITKE347,940 pointsBadges:
  • Row by Row Stored Procedure in SQL Server 2008 R2

    Hi all, Hopefully someone will be able to help me here - I'm nearly there but can't get it right, I'm trying to create a stored procedure that when it runs, it will do a query and then send send an email out for each of the rows that it returns. e.g. If I have a DB with 4 columns (ID, Days,...

    Turdywills65 pointsBadges:
  • How to find a specific word in a SQL table

    How do you write a SQL query to find a specific word in a SQL column. Example: I want to show all records that have the word Bob in it but do not want to include records that are Bobby or Bobble etc., only the exact word Bob. Hope that makes sense.

    Boomer15 pointsBadges:
  • Using AS/400 SQL to replace a variable string

    I need to do a scan and replace in a flat file. File has one field 80 characters long. Possibly one or more of the records in the file contain a specific value, such as '%ABC%' and I want to update the record replace ABC with XYZ. This value could be anywhere within the record. I do not want to...

    CharlieBrowne41,380 pointsBadges:
  • How to Test for Numerics in AS/400

    I need to test for Numeric. I have to check, If a variable contains Numeric values. I wanted to use TESTN opcode, but people are saying not to use it; as it does not work properly some times. Is there any other alternative to this? Has anybody done this before? Any help would be of great help....

    svankipu620 pointsBadges:
  • What’s the better choice: VMware or Virtual PC?

    I've been experimenting lately with some build script (and since I already have ASP.net web part under source control) the script should do that at the end. Grab the "naked" Windows 2003 IIS VMware or Virtual PC image from the networkBoot it upCopy the files from the Build Folder to the...

    ITKE347,940 pointsBadges:
  • Testing VMware Perl SDK with ESXi 5.1

    I’m running a VMware ESXi 5.1 server and I need some help with Perl Scripts. I have downloaded and installed these packages on a Ubuntu 12.04 LTS machine: VMware-vSphere-CLI-5.1.0-780721.x86_64.gz VMware-vSphere-Perl-SDK-5.1.0-780721.x86_64.gz VMware-vSphere-SDK-5.1.0-774886.zip When packages...

    ITKE347,940 pointsBadges:
  • How to run a stored procedure directly from a begin- end; statement?

    I have a stored procedure with some dbms_output statements in it , i want to run this stored produre directly from begin end; statement in order to check how it woks...

    hussain22juzer500 pointsBadges:
  • API to determine if software is running on Citrix or Terminal Services

    I'm trying to figure out an API/function that I can call to find out what software is running on Citrix, Terminal Services or a stand-alone PC. Here's an example of what I'm looking for: Select Case APIWhatSystem.Type.ToString Case "Citrix" bCitrix = True Case "TS" bTerminalServices = True Case...

    ITKE347,940 pointsBadges:
  • How to tell which virtual machine is running?

    How does one find out if an application is running in VMware or Virtual PC? I’ve seen a few hacks that do this, but often they create performance issues that I’d like to avoid. Is there a way to do this using Delphi code?

    ITKE347,940 pointsBadges:
  • How to fix run-time error 3709 with my computer

    When I try to run my program it says run-time error 3709 the connection cannot be used to perform this action, it is either closed or invalid in this context. mean while I used a module in which i put the following codes : Public cn As ADODB.Connection Public Sub Main() Dim cn As ADODB.Connection...

    beginner15 pointsBadges:
  • SQL Server 2000 Database Table Limit?

    Is there a limit to how many tables a single database can hold in SQL 2000?

    Xarly25 pointsBadges:
  • How to make installer of VB.NET including SQL Server 2000?

    I had done my project in vb.net with sql server 2000 but it's installer doesn't work properly as it displays the message unexcepted error while connecting to the database.I know setup and deployment in vb.net but doesn't working please help me.I am stuck in here.thanks in advance.

    Rebi97745 pointsBadges:
  • SQL Server 2008 SSIS Update Command Performance Issue

    Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB with 500,000 rows using a...

    Sflatbush60 pointsBadges:
  • Export XML from SQL Server 2000

    We currently use a DTS package to extract data from the db and export it in an XLS file, or in some cases a TXT file. We now need to be able to export as an XML file. Since SQL Server 2000 DTS functions do not appear to support this directly, can anyone give us guidance on how to proceed?

    JHM5 pointsBadges:
  • Ping SQL server in VB6.

    I need to use VB6 to detect if an SQL server is running. Looking for the easiest way whether it is pinging or something else or even detecting the database itself. Preferably by network device name.

    Jstropp5 pointsBadges:
  • store image to sql server

    would you please give me a code to store and retrieve an image in SQL Server 2000, using Visual Basic 6.0 on the front end

    Azad10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following