Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- database design for changing reports?
- Hi,We have a table with the following structure...|autogen_key|report_id|report_period|numeric_val|l ine_number|autogen_key == an autogenerated key -- also used to indicate the order that the numbers were inserted in. same as the order receivedreport_id == the unique identifier of the number set one set of values per reportreport_period == the month that the...
- Tags: CompSci, database, design, result set, software
- Discussion threads 2005-07-05
- The many uses of ColdFusion simulated queries
- Like any modern Web application server, ColdFusion allows you to query databases and retrieve data. Unlike many Web application servers, CF makes it extremely easy to query databases and retrieve data. You only need to write some SQL and place that code into the <cfquery> tag, which takes your SQL,...
- Tags: Development tools, Databases, Application servers, Brian Kotek, result set, database, Allaire ColdFusion
- Technical articles 2003-04-17
- Use SQL subselects to consolidate queries
- Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro!Do you ever find yourself juggling queries to get the information you need? Subselects, also called subqueries, may be just what you’ve been looking for. This SQL feature allows you to...
- Tags: Databases, Shelley Doll, Metallica, SQL, result set
- Technical articles 2002-07-15
Additional Resources
- Crystal Reports Dataset
- I'm attempting to connect a Crystal Report to a Stored Procedure that returns 4 result sets. The report needs to hook to only the 4th result set, though when I set the Datasource Location it seems to only consider the 1st result set.I can properly pass the data from...
- Tags: mdecap@..., Crystal Reports
- Discussion threads 2007-09-13
- to take print of result set
- I am a webdeveloper . I want to know about How to take print of result set .... AND how to take print of output reports window........
- Tags: Construction, sattu.4uonly@...
- Discussion threads 2007-07-15
- DATEDIFF FUNCTION
- Hi,Im a developer. I have a question on the DATEDIFF function, hope you can help me out. Im using DATEDIFF function, I know that it will result in integer value. But, I need the result in decimals. For example :STARTDATE ENDATE RESULT8/27/2003 ...
- Tags: Instant messaging, tytyu67567, DATEDIFF FUNCTION
- Discussion threads 2007-04-06
- SQL RESULT PANE - SEND TO PRINT RESULT
- I need to send the result of a SQL statement to the printer, directly from the result pane. I don't want to use any report writer. Please help!Try using F13 to change the output options, inside interactive SQL. Normally you would output to a file
- Tags: career, F13, keyboard, mtorres7, SQL
- Discussion threads 2005-03-03
- Visual Basic Common Dialog Cancel
- I am working on a school project using Visual Basic 6 to make a copy of Windows XP Notepad. I'm working on the functionality of the Save/Save As menu items and am using the Visual Basic Common Dialog to set Save parameters. I use the CommonDialog.ShowSave to bring up the...
- Tags: Microsoft development tools, Programming languages
- Q&A 2006-01-18
- How do I... Fill Word form fields with Access data?
- How do I... Populate Access data with Word fields?Is it possible to create an Access database from data entered into word form fields?Just what I've been trying to do... Now if only I could get it to workI've been using the script below with Office 2003 Professional to send...
- Tags: Word processors, Microsoft Office, Databases, charles.levea@..., Doc, Word.Application, Microsoft Access, Microsoft Word
- Discussion threads 2007-07-11
- Avoid output message when using Trigger
- I created a trigger for delete on my table. When a user try to delete an item, several processes are lunched, and I don't want this processes to output. When the user try to delete a row, he got a result like (1 rows affected)(2 rows affected)(0 rows affected)Is it...
- Tags: Avoid DBCC, trigger avoid output, werewolf_@..., software, identity
- Discussion threads 2006-08-31
- Perestroika: Restructuring Data for Flexibility
- PROC TABULATE is a wonderful tool. It allows developers to display data by cross tabulating one or more category values against other category variables. However, because of its efficiency, the result is lacking for those that need to import the result into a spreadsheet or database. By manipulating the data,...
- Tags: Developer, Result, SAS Institute, PROC TABULATE, Productivity
- White papers 2006-02-28
- Grouping dates into days
- I am trying to group a date Range result set of say one month into days between 22:00:00 and 21:59:59. I's this possible with SQL or do I have to do it in my .NET application?try this:SELECT * FROM yourTbl WHERE [date] BETWEEN 'startdate' AND 'enddate'That will return a result...
- Tags: Databases, endDate, SELECT
- Q&A 2005-09-20
- Optimize Result Set Retrieval Using ODP.NET and Ref Cursors
- There are several ways to return query results from an Oracle database to a client application, using Oracle Data Provider for .NET; one of the most powerful, flexible, and scalable methods is to use ref cursor. This paper introduces ref cursors and why they are useful, including an example of...
- Tags: Oracle Corp., Sample Code, Cursor, .Net, Application Servers, Middleware, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- White papers
- My Web Gallery (exe)
- Create Web photo gallery. Program options: - image types: bmp, jpeg; - bmp to jpeg conversion to make images smaller - selection of source and result directories; - add add all / remove remove all image; - preview selected image; - set columns and rows; - set thumbnails size; -...
- Tags: Web, JPEG, AltarSoft
- Software downloads 2006-10-10
- Different db query/dropdown result
- I amusing frontpage 2002 and have a simple page with one dropdown box containing three entries. These entries filter a sqlserver table by returning either all records,or a subset. How do I get each dropdown result to send the query to the db to return the results?create a database connection...
- Tags: carlhe@...
- Q&A 2005-05-18
- Using the "80-20 rule" to help set priorities
- I use the 80-20 rule all the timeI use the 80-20 rule extensively, and have done for years. The version of the rule that applies to us is that 80% of the result takes 20% of the effort. The final 20% of the result will require 80% of the effort.Following...
- Tags: PRODUCTIVITY, williaa6@...
- Discussion threads 2007-09-25
- Make your Excel charts easier to read with custom data labels
- Show it - make it easier to evaluate the resultShowing an example of the final result would be appreciated. Showing the final result (and for more complex tasks include showing the process/steps)could be on a separate page so that others could just read the text if they so desired.This...
- Tags: charts, easier learning, excel, feedback, iversonb@..., Microsoft Excel, Showing
- Discussion threads 2007-01-18
- Use Excel's Autofill to generate a series of dates
- excel sheet sharehow to a excel sheet make share with any ther sheetThe result of cell B4 is #VALUE! So I try to type the date 10/7/2005 without (e.g.,) to get the correct result. I learned something new, that the number 7 or any desired number we type, is...
- Tags: vandan_vco@...
- Discussion threads 2006-02-09
- For the future of mankind
- blog rootFar PointAt far point, we set our target and the end result.
- Tags: Blogging, fauzisd, mankind
- Discussion threads 2005-05-23
- Greasemonkey Hacks: Add Keyboard Shortcuts to Google Search Results
- The user script given in this paper runs on all Google pages. It uses an XPath query to find all the search results (they're each wrapped in a element), and then inserts red numbers beside each search result, from 1 to 9, then 0 for the 10th result. The...
- Tags: Google Inc., Keyboard, O'Reilly Media Inc., Google Search, Search Result, Keyboard Shortcut, Search
- Book chapters 2005-11-10
- << Previous
- page 1 of 1
- Next >>
