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
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
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
how to simulate CSMA/CD protocol with C# or any language?
Answer Question | January 12, 2011 12:48 AM
C#, CSMA/CD, Programming Languages
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
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
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
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
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
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
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
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
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 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
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
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
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
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 software version 10 have activex capabilities?
Answer Question | November 29, 2010 2:11 PM
ActiveX, Crystal Reports, Crystal Reports 10
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