• Eenabling full outer join option in crystal report

    When i use Crystal Report 10, i alwaya found FULL OUTER JOIN option as disable. How to enable this option ?

    TariqMalhi15 pointsBadges:
  • Delete query

    Can you help me solve the following problem. Whenever i have an order where the field Audit = True, i will have to delete all the previous orders having the Audit = True. And only when customerid = 121. With other words i have to delete the previous orders having Audit = true but not the last one....

    Samotek15 pointsBadges:
  • Windows networking: how to display access points and other computers on the network

    I have a wireless LAN at home but am confused about how to display access points and other computers on the network. I use an iMAC, a PC with XP, and a Netgear wireless router. I don't use any wired connections. What/how should I be able to see of this network from the XP machine? Why does Windows...

    NetworkingATE1,545 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:
  • Problem occuring while performing Mirroring

    Hi, I underwent the following Steps for creating a mirror in sql server 2005. 1. Downloaded and isntalled sp2 in principal,mirror as well as witness servers 2. Created a new database named it as FinalMirror 3. Right clicked on the database Tasks-backup-BackupType--Full--Ok created FinalMirror.bak...

    Cmrhema5 pointsBadges:
  • Exchange 2007 delegate access for a generic mailbox to allow more maximum recipients

    Hi We are using exchange 2007. We have a maximum recipients policy in place of 100 per email. We do not want to change this, but we have a few users who need to send to more than 100. We have the ability to allow more recipients, but do not want to do this per mail box, or allow everyone, so this...

    Dougiethebold15 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:
  • 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:
  • microsoft access 2007 & Outlook 2007

    Hello, I am running office package 2007. I was wondering if anyone has found a way that i could set reminders in access 2007 and i would get a reminder email when the time comes closer. I was also wondering if access could auto pull from a date catagory and set it to have outlook send a message...

    Itguy1509220 pointsBadges:
  • SQL Server 2005 – Are There Any Easy Appl. Builders

    Hi, Is there a easy application builder for a PC to access a SQL Server 2005 Database that will give it the ability to do Inserts, Update, and Deletes? Is there a program that can read in a SQL Server 2005 Schema and generate forms to do updates and reporting? Are there any Open Source Apps or low...

    Tsmith235 pointsBadges:
  • Replication

    Can I have multiple Distributors configured on one SQL Server instance? Also, can I have multiple Distributors configured on one SQL Server instance? Finally, can I have multiple Subscribers configured on one SQL Server instance?

    Consultant16535 pointsBadges:
  • Calling QMF interactive from COBOL programs in CICS regions

    We have a call to QMF from all the screen in the application. We also has QMF report generation from onlines where users enter the details in onlines which is passed to QMF proc and report is shown to them on QMF screen. Once user is done with QMF queries/reports and presses PF3 he/she returns back...

    Nishantrk5 pointsBadges:
  • Add to Excel spreadsheet from System i

    I want to add data from a DB2 file to an Excel template that has a header row and totals certain columns without overwriting the header row or the totals.

    ljjk1225 pointsBadges:
  • symantec Q&A for windows 01-50-00537

    can any one help with a lost past word for data file.

    Inforwiss5 pointsBadges:
  • Access Report Page Setup Won’t Save

    I am running Access 2003 on Windows XP. In the page setup of a report, you can set custom page size and specific printer, etc. I have a PC that the page size will not save with the report. I have two other PC's that it works on. Has anyone had this problem and found a resolution? I should add that...

    Randym1,740 pointsBadges:
  • Microsoft Access Printing graphic hell

    Hi This is a weird one. I have a report that prints embedded Access graphics - from a table. When I originally designed it, each time I went to print - no graphics appeared - then almost overnight - they started to print and I've had no trouble since - until today... when I started adding more...

    Elgoober5 pointsBadges:
  • Oracle Application Express Item

    I have two tables with parent-child relationship. Is there a way to automatically populate the foreign key field of the child table with the exact data from the primary key of the parent table?

    Rwy265 pointsBadges:
  • How to create an SSIS package for importing an Access table to SQL Server, running SPs and exporting data to Excel

    I need to create a SQL Server Integration Services (SSIS) package for importing an MS Access table into SQL Server, then running some stored procedures on this database and finally exporting the result to Excel. I am comfortable in writing queries and working in Management Studio but I don’t know...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Fetchind duplicate rows from a table

    A table has appox 60 fields. i would like to fetch all the rows having all values of the field equal excpet 3 fields.

    Sri245 pointsBadges:
  • How can I collect database/server information across multiple MSSQL versions.

    I would like to collect database info(backups, databases, logins, etc) as well as server information ( MSSQL version, patch level, etc). I would like to use one server to collect information from all of my servers. I have MSSQL 7, 2000, & 2005 on Windows servers 2000 & 2003. I am also new to MSSQL...

    AngieJo20 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