• Alternative for LEFT OUTER JOIN

    HI all, select code.batchno, detailA.batchfee , detailB.batchfee from Code code left outer join Detail detailA on (detailA.id= code.id) left outer join Detail detailB (detailB.id= code.id) where code.category = categoryA order by code.id I want an alternative for left outer join.. I cannot use left...

    4knowledgexchng20 pointsBadges:
  • Help with code in Visual Studio 2008

    strComputer = "." Set objWMIServices = GetObject("winmgmts:root/default") Set wmiSink = WScript.CreateObject("WbemScripting.SWbemSink", "SINK_") Set ObjRegistry = GetObject("winmgmts:{impersonationLevel = impersonate}!\\" _     & strComputer & "rootdefault:StdRegProv")...

    GreatGordon201010 pointsBadges:
  • SQL SERVER 2005 Security use Kerberos instead of NTLM

    How can I setup sql server 2005 to use kerberos authentication instead of NTLM?

    Rick Martinez585 pointsBadges:
  • SQL-Using count and inner join in a single query

    Hi Trying to retrive a report from the DataBase using left join on two tables. To get the count of resultant table, I'm using count. But the output shows error. If I comment count statement then the query executes successfully. I feel there is some error in the syntax of the count that I'm using....

    SQLmurali5 pointsBadges:
  • Remove link from treeview parent node

    Hi, Is there a way I can keep the text of a Parent node but remove the link? The treeview parent node is used just as a header, no navigation.I am implementing this tree view using Asp.net with C#.Any help would be great.Thanks.

    Kvlkarthik5 pointsBadges:
  • Help with perl script to add information to AD user profile

    I need to use Perl script to create a script that will add some information to an active directory users profile. The client is on Windows 7 and the AD server is 2003. Where can I find script examples? Can someone help?

    ITKE345,295 pointsBadges:
  • JavaScript IF ELSE

    I have managed to get the prompt to work, but when i type a number into prompt it displays all outputs on webpage, like nodiscount5%discount etc, could someone please sort my program so it just shows one output, then i can study my errors and learn from it. thankyou. <HTML> <HEAD>...

    Gunter970 pointsBadges:
  • hi can anybody tell me how to combine these two queries

    1. SELECT count(*) AS Cnt1 FROM tsau_pre_msges WHERE ( (EXTRACT (DAY FROM Jms_timestamp)-EXTRACT (DAY FROM ins_time))*24*60 + (EXTRACT (HOUR FROM Jms_timestamp)-EXTRACT (HOUR FROM ins_time))*60 + EXTRACT (MINUTE FROM Jms_timestamp)-EXTRACT (MINUTE FROM ins_time) ) BETWEEN 1 AND 5 It will count...

    RizwanSharief30 pointsBadges:
  • Scripting help: folders and permissions

    I have about 7000 folders and I need to create a special folder inside of them. I need to also give certain groups permissions to these same folders. Does anyone have a script that would assist me in creating these folders?

    WindowsServerATE335 pointsBadges:
  • Convert/Migrate Lotus Notes Client Applications to Web

    I want to know if there is a tool that help in converting a Lotus Notes Client application into a Domino Web application. Thanks.

    MHG5 pointsBadges:
  • How to convert the currency in Indian Value in Excel 2003

    Dear Sir, I am not able to convert the value like this even by using the custom format in Excel 2003 - 100,75,75,750.50 or (100,75,75,750.50) Can you suggest a good way to do this which also takes care of low values like - 75,750.50  

    Ravichan425 pointsBadges:
  • unable to telnet to 2950 remotely

    I am able to telnet to my 2950 locally but not remotely. I have a defult gateway. I am able to ping and SNMP to it remotely but not telnet. I don't have any ACL's on the vty.

    Efarey15 pointsBadges:
  • URL address greater than 255 characters. How to overcome that limit in ABAP

    I have a button on my opening screen that calls a function that brings up a URL containing documentation. It worked great in testing until I tried to use a URL address that is longer than 255 characters. Is there a BAPI or method or something that will work with more than a 255 character string?...

    SuperSapper380 pointsBadges:
  • Access VBA Code stops at Midnight

    Why do all my Access VBA scipts stop at Midnight?

    Robert19735 pointsBadges:
  • File Type Associations in Windows 7

    On Windows 7 if you do the following: 1. Go to the Orb and in the search box type “associated” 2. The first item that pops up under Control Panel (1) is “Change file type associated with a file extension” 3. If you click on that link it takes you to: Control PanelProgramsDefault ProgramsSet...

    ConFlicker210 pointsBadges:
  • How do I load and access the new shared library (.so) in linux via php

    how to load and access the new shared library (.so) in linux via php

    Mailcheck10 pointsBadges:
  • Which methodology (SDLC, Software Development Method) is best to use for a Census Management System I’m creating?

    I am doing my IT project for my final year (Bsc, Computer Science), Which methodology (SDLC, Software Development Method) is best to use for a Census Management  System I'm creating?

    Mahjong30 pointsBadges:
  • Changing query for report

    How can I cnage the query that I'm drawig data from so I don't have to re-build my report

    Starwars5 pointsBadges:
  • .Net Application Routing Emails from SMTP to Exchange Server Error

    Our .Net app works fine using current We.config settigs if we send emails to an external SMTP host. When we point it to our Exchange server it won't work! Any ideas please help. Are there specific SMTP Server settings we need for this to work with Exchange, or any Exchange Server settings that...

    JimDoyle5 pointsBadges:
  • save picture in Word document

    How can i save a picture in Word document to a separate jgp file. there used to be a right-click option, "save to file" but no longer there.

    JWStoller5 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