• Formula workshop – using AND/OR

    Using the formula workshop, I am trying to display all records from 10am to 11am that have EITHER data in "field A" OR data in "field B". What is returned are records in the correct time frame (10am-11am), that have data in the "field A", however the records that have no data in "field A" but do in...

    LouJ5 pointsBadges:
  • what is error message write of address 00000034 in delphi5 mean?

    what is error message write of address 00000034 in delphi5 mean?

    Oracleunix5 pointsBadges:
  • SQL 2005 Active/Active/Passive

    We have a SQL cluster server running with SQL 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So after I have done it, the cluster will be a Active/Active/Passive cluster. Because...

    Kjrichmond15 pointsBadges:
  • Installation and updates

    Howdy folks, Tryin to keep things going around here....need some advice. I have Win2003 servers and Active Directory.....single domain....approx. 100 client computers.....one location. Am upgrading all computers from Office XP to Office 2003. My project: Install Office 2003 and all updates remotely...

    TheVyrys0 pointsBadges:
  • How to save a document as current date ?

    I'm using VBA in excel 2000 to create a macro that saves out a spreadsheet with today's current date. I cannot figure out the code that will achieve this function. Help Please

    Data Mgt5 pointsBadges:
  • Need vbscript that can pop up alert when services go down on a remote computer

    Hi, I have tried many scripts at my local machine. It gave pop up when service for one particular application went down. But the same thing is not happening for the remote computer. Please look at the script below: strComputer = "." Set objFirewall = CreateObject("HNetCfg.FwMgr") Set objPolicy =...

    Naaz30 pointsBadges:
  • Convert time to GMT time

    In t-sql, I want to store the date from the getDate() function in GMT time instead of local time.

    Apinto5 pointsBadges:
  • What are Web services, and how can they benefit my clients?

    Our expert on SearchSystemsChannel.com says the advantages of Web services are that they're "platform independent (your customers can essentially run any OS), secure and scalable. They're also Web-based, so they run over Port 80, which many firewalls do not block." Are you a fan of Web services?...

    Donnellymp430 pointsBadges:
  • SQL COMMAND to see table relation

    Which command I can use to get the relation between all tables in a system application?

    Arielmx5 pointsBadges:
  • Is it possible to find out the name of an excel worksheet

    I need to import details from Excel but the worksheet names are not always what is expected. Is there a way to determine the worksheet name using sql? Query used to import where sheet name = data SELECT * INTO tmp_test2 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel...

    Smf170 pointsBadges:
  • What is the difference between using a rpc over http and OWA?

    What is the difference between using a rpc over http and OWA? Which one do you feel is more secure? Do OWA have some limitations to the outlook clients than rpc over http?

    ITKE344,855 pointsBadges:
  • SQL Query for time data only

    I need to query a large remote weather database for events reported within time frames without regard for the day. For instance, I need all data that was reported for the fifteen minute window closest to noon each day for the last twelve years. I don't care about specific dates, just the daily time...

    C Pete15 pointsBadges:
  • Looking for a stored procedure to monitor size of Transaction Log file

    Is there any way I can create a stored procedure which will check for the Transaction Log file size - where we have a specified limit to grow - and if the Log file reached 80 percent of total size, email alerts can be sent to DBAs?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Count several columns Group by accounts Greater than value Beginner

    I need to be able to count how many values are greater than 1 for each StuNum. I have only been able to count how many values are greater than 1 for each StuNum for d1 or for d2 or for d3, but not for d1, d2 and d3. How can I have it count multiple columns. Table StuNum – SchNum – Tchnum – d1...

    Ben Pinto5 pointsBadges:
  • in what direction should i work

    i did degree in electronics and communication after that i did job in sofware company for 8 months as assistant system engineer with cobol, sql technology. i have basic knowledge of c, cobol, sql and html. what kind of job should i search, i need one more suggestion that in which field i should go...

    Canny5 pointsBadges:
  • MS Project 07 Automated Communication

    I am a project coordinator attempting to improve communications among resources assigned tasks in Project Server 2007. I would like to automate some of the issues and escalation of same - workflow type. What are the best tools for collaboration with this product? I'm semi new to MS Project and, of...

    Sissy10 pointsBadges:
  • Subquery?

    I used to think I was good with sql as I have used it for quite a few years with informix, but now I am trying to create an sqlplus with oracle and some things are not working the same. I have 3 tables. customer general customer detail location I have used a join to list all the required customer...

    MizzGail85 pointsBadges:
  • Alternatives to ODBC

    Our db group wants to remove ODBC access. My application relies on ODBC to get data. What are the alternatives?

    Chany25 pointsBadges:
  • Combo box and VBA

    The two possible selections in an Excel combobox: Debt & Common Stock. Let's say that the combobox resides in cell B3. If Debt is selected from the box- I want the following fields to show up two rows below the combobox, all in the same column: Issue Date, Maturity Date, Interest, Seniority, Use of...

    Nkd5 pointsBadges:
  • rpg sql concat

    Our database was designed with separate fields for cc, yy, mm and dd. I'd like to know if and how these fields can be combined into one field then order by on that field. Is this possible? I would need to know the syntax also. If this is not possible, then is there a another way to order by...

    mcg15 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