• Return zero when there’s no data

    I am trying to write a query that I can use to generate an Excel chart to show activity in our database. I have it returning rows for each minute over the previous two hours (no problem). The problem comes when I plot a line chart. If there's no activity in a given minute, there's no row returned,...

    DanM5 pointsBadges:
  • Random number generation

    Hi, I have a 6 digit number. I need to make this as a 10 characters with those 6 digits within it. For eg, if my input number is 123456, the result should be a4y2d365p1. some combination of characters with the original 6 digit numbers. Please do let me know if this could be done by any ways..

    Coolgirl045 pointsBadges:
  • How can I display an attachment as an object in a Lotus Notes field?

    How can I display an attachment as an object in a Lotus Notes field on the web side? In the field, I should be able to display the file name and the image of the attached file.

    Domino Ask The Experts435 pointsBadges:
  • how to open media fils?

    how to open media files using vb6 using dialogbox control please get me the codings to open and to read

    Shwetha20 pointsBadges:
  • DataGrid

    I have a datagrid in my form that contains coloumn of attendence of a perticular ID .what i want to do is to calculate total number of 'P' and 'A' in a textbox

    Harsh221510 pointsBadges:
  • Validation in Excel

    Can a cell have a validation rule from a list and also have the ability to free type in that cell? This is in Excel 2003.

    Mart8025 pointsBadges:
  • Keep formatting when pasting source code

    When writing a report in Writer, I want to paste all my source code (Matlab as language in this case) as different appendixes in the end. How can I do so, and keep the formatting as shown in Matlab? Courier as format type and comments to be green for example.... Linux users seem to have it...

    HenrikP5 pointsBadges:
  • VB.NET ans ORACLE database

    Hi all. I know, that there is a big risk of asking a silly question, but I try to connect to a ORACLE 10g database witch MS Visual Basic 2005 Express Edition and all programming examples I found do not work. Is this a configuration that does not work? Or what software do I need exactly? What should...

    Flyer15 pointsBadges:
  • Using xp_cmdshell

    Hi, I am using xp_cmdshell in one of my stored procedures(database SQL server) to delete older files from a folder in another server. That server is mapped as a network drive on the sql server computer. But when I used this drive inside xp_cmdshell command and do a dir , the output I get is 'Access...

    Gullu15 pointsBadges:
  • sql server reporting server

    I have seperate application server for ASP.NET(2.0) and Database server for Sql RS 2000, when i try calling reporting service webservice to generate excel and allow to download to the web user, it gives an error as "401 as unauthorised", can anybody has a solution for this Regards, Prathesh

    Prathesh5 pointsBadges:
  • Select last 3 transactions

    Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= '12345' order by TransDate desc. I believe there must be a more...

    SuhelAC0 pointsBadges:
  • Convert time as text to datetime

    I've got a stupid table that I have to work with (and no, I can't change it) that stores times of certain events as text (example: '10:25 pm' or '3:02 am'). This table has an actual date to work with, which is essentially just the date with no time component. Know what I'm going to ask yet? You...

    VentureFree45 pointsBadges:
  • Damaged software

    If a company's software product credibility has been damaged, do you think they can salvage it?

    Tsmith740 pointsBadges:
  • Create a menu-driven program that allows users to select one of five international currency types, input the amount of a foreign currency, and then co

    Consolidate all the sections of the Currency Conversion development documentation: requirements, design, and testing.

    Tsmith740 pointsBadges:
  • Community Update: New Site updates and Contest Announcement. Win a Nintendo Wii!!!

    Hello Community If you haven't noticed we have added a few new features to the site. First we added more questions to the home page to allow you to browse the latest 200 Questions, Answers and a new tab of Unanswered questions. Also on each main topic page we have added a recent answers and...

    ITKE409,350 pointsBadges:
  • i want to change the true bits to false and vice versa

    i have a table where i have true and false bits..i need to replace the true bits to false and vise versa

    Sam535 pointsBadges:
  • SQL and Moss 2007 from Jameel Ur Rahman (Abbottabad)

    hi, I recently done Moss 2007 certification . an di want to know the relation of SQL and Moss 2007 , and also let me know for Moss 2007 implemention how i prepaer my self regarding SQL because SQ L new for me any book or white paper that help me and also SQL 2005 Administration thanks jameel

    Jameelrk5 pointsBadges:
  • run vbscript on remote computer from java

    How do I run vbscript on remote computer from java application?

    Ilana10 pointsBadges:
  • i’m having one web application ,actually now in that when user submits the data it is storing directly in database instead of that now i want to shows

    Now in that when user submits the data it is storing directly in database instead of that now i want to showsuser that he can edit the data in preview page & if now the user is corrected the data then he wants its to store in database. pls help how to do the logic or code. using java servlets,jsp...

    Kishore2k715 pointsBadges:
  • How to install a passive node on an active/active SQL Server cluster

    We have a SQL cluster server running with SQL Server 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 once I’m done, the cluster will be a Active/Active/Passive cluster. Because...

    SQL Server Ask the Experts2,585 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.

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

Following