Find missing numbers with SQL
In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

Answer Question   |  December 14, 2010  2:35 PM
AS/400 SQL, SQL, SQL Server, V6R1

Crystal Reports 8.5 compatibility with SQL 2005
Is crystal 8.5 compatible with SQL Server 2005?

Answer Question   |  December 10, 2010  4:45 PM
Crystal Reports 8.5, SQL, SQL Server, SQL Server 2005

Redirecting to web server via DNS
We have an intranet site on our windows 2003 network. How can we setup DNS so that when typing intranet it redirects to our webserver?

Answer Question   |  December 9, 2010  2:39 PM
DNS, DNS management, Intranet, Web servers, Windows Network Administration, Windows networking, Windows Server 2003

CSMA/CD Simulation in C#?
how to simulate CSMA/CD protocol with C# or any language?

Answer Question   |  January 12, 2011  12:48 AM
C#, CSMA/CD, Programming Languages

Cell Automated Population using Excel macro
Hi, is there a way in macro wherein if a certain cell has value, the other cells will be automatically populated? Example: In cell E6 I put the date, cell A6, B6,C6 and D6 will automatically copy the values in A4, B4, C4 and D4. Same goes when I enter the date on cell E7. Thank you [...]

Answer Question   |  December 8, 2010  8:33 AM
Excel 2003, Excel macros, Excel VBA, Visual Basic

Workitems created on another system (ecc) appear in the CRM agent’s inbox, but Workitems created in CRM do not show
Sap CRM 7.0 and Sap Ecc6.0. In the Sap Gui on CRM all workitems that are created on either system appear, but in the CRM’s AGENT’s inbox we only get workitems from one of the systems. We either get all CRM created workitems or all ECC created workitems. Any help will be greatly appreciated.

Answer Question   |  December 6, 2010  10:36 PM
SAP CRM, SAP CRM 7.0, SAP ECC 6.0, Workflow

Unable to Install this updatee listed?
ASP.NET Security Update for Microsoft .NET Framework 1.1 on Windows XP, Server 2008 x86 (KB2416447)? I am not able to install the update into computer. Does anyone knows what this is?

Answer Question   |  December 3, 2010  5:31 PM
.NET, Microsoft security updates

Print Preview and Printing Drops Pages from Reports
WE have been using the same ACCESS Database for 7 years.  Suddenly, worksheets and reports that have always printed out perfectly are not dropping entire pages; for example, if there are five pages of information, it will drop page 2-3-4 but print page 1 and 5.  What would cause that?

Answer Question   |  December 2, 2010  6:37 PM
Access, Access Database, Access Database Design, Access Functions

Create trigger using iSeries Navigator
I am trying to ceate a simple trigger to a table to update a history file with the old rate when the rate changes in the master table. I have gone as far as creating the sql statement, but I am not able to make it to work (my sql is very limitted). Would it [...]

Answer Question   |  December 2, 2010  2:28 AM
AS/400 triggers, iSeries Navigator, SQL, Triggers

Reading pdf docs in Windows 7
I cannot open pdf files and use windows 7 oe, since downloading the latest adobe reader X can any give me basic way I can overcpme this. Please could you give me full instructions as I am a tad plebish! regards Denis

Answer Question   |  December 3, 2010  7:52 PM
Adobe, Adobe Reader 9.1, PDF, Windows 7, Windows 7 error messages, Windows 7 support

Application for quality assurance testing on multiple browsers including IE
I am not a developer – I am a tester (QA) so I hope I ask this question correctly.  I need to test applications on multiple versions of IE, Firefox, Chrome, etc…..  I was using Spoon but apparently Microsoft made them close down.  I found a program called Adobe browserlab, which would have been perfect [...]

Answer Question   |  December 3, 2010  6:53 PM
Desktop virtualization, QA testing, Quality assurance testers, Windows Virtualization, Windows XP

Excel and Access integration and auto-population
Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table.  Each site (7 in total) documents their internal defect data and sends it to me weekly.  I then merge all of this data (have been doing so manually) into one spreadsheet to perform my analysis [...]

Answer Question   |  December 7, 2010  2:52 PM
Acces, Access 2000, Access Database, excel, Excel 2010, Excel macros, Macros

Complex SQL query in SQL Server 2008 tables
Sir, i have 2 tables , first table column one is 1,2,3,4, and column two is x,y,w,z and second table  first column of 1,2,3 second column is (1;2),(1;2;3;4),(2,4), i wand to display the result as in first colum 1,2,3 and second column as (x,y),(x,y,w,z),(w,z) please help me in this regard

Answer Question   |  February 9, 2011  12:42 PM
SQL, SQL Query, SQL Server, SQL Server 2008, SQL Server tables

How to transfer database from SQL Server 2008 to SQL Server 2005
how to attach database of  sql 2008 into sql 2005

Answer Question   |  December 1, 2010  6:13 AM
SQL, SQL Database, SQL Server 2005, SQL Server 2008, SQL Server migration

Web Services and SSL Certifications
Hello All, I am working with vendor who offers SOAP based web services that I’m trying to use for my company.  The web services app/client that I’m builiding will reside on an IIS box, on our company network.  The web services require a cert for mutual SSL and another for TLS.  The vendor is requesting [...]

Answer Question   |  January 6, 2011  6:25 PM
ASP.NET, Certifications, HTTP, License management, SSL, SSL & TLS, Web services

VBA to separate overlapping times
I am stuck trying to seperate overlapping times. The situation is that I have 5 devices requiring x amount of material at the differing durations. What I need to do is seperate the durations and add the demands together for the new duration, but there can be as many as 5 overlapping demands; here is [...]

Answer Question   |  December 1, 2010  5:46 PM
Excel 2007, Timestamp, VB codes, VBA

Date Range in Excel Macro
Hi, I just want to know if its possible to do a macro wherein I can select the dates to be read in my report. For instance, I have a Table (below) where column A is the Date, column B is the name of Agents, Column C is the Section and the Column D is [...]

Answer Question   |  December 2, 2010  4:18 PM
Agents, excel, Excel macros, Macros

Free IT Book: Enterprise Web 2.0 Fundamentals
For an introduction to next-generation web technologies, Enterprise Web 2.0 Fundamentals is a great place to start. Learn how to leverage cloud computing and user-generated content along with business and technical best practices. To win this, simply answer one of the questions listed below and provide a link to your answer in the discussion area [...]

Answer Question   |  December 6, 2010  4:13 PM
Giveaways, HTTP, IT answers, IT Books, ITKE Contests, Radius Server, SAN, Sybase, Windows Server 2003, Windows Server 2008, Wireless router

Does Crystal Reports 10 have ActiveX capabilities?
does crystal reports software version 10 have activex capabilities?

Answer Question   |  November 29, 2010  2:11 PM
ActiveX, Crystal Reports, Crystal Reports 10

ERROR by ImageOle Dbl_Click opening a JPG file
I am using VB6, and OLE Object for linking and oppening files, now I am getting error oppening Files in JPG Format. Is there any way I can resolve this issue?

Answer Question   |  November 29, 2010  12:28 PM
OLE objects, VB 6.0, Visual Basic, Visual Basic 6.0, Windows Server 2008 R2