Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- SQL Server error importing 3 GB file
- Here is the message I get using the import wizard.Its a giant file, I can only open it in ultra edit.All the fields have been created using varchar(255)Operation stopped...- Initializing Data Flow Task Success- Initializing Connections Success- Setting SQL Command Success- Setting Source Connection Success- Setting Destination Connection Success- Validating...
- Tags: Performance management, Databases, Enterprise software, michael@..., Microsoft SQL Server, Data Flow task, output column, SQL Server Import, Export Wizard, Data Flow task performance, Flat File Source Output, Skinner-VOTERLIST-12-MAR-07_TXT
- Discussion threads 2007-05-17
Additional Resources
- tranpose of row and column in vb
- how to convert rows into column?inputName cityabc mumbaixyz delhidef mumbaioutput which i requiredcity Namemumbai abc,defdelhi xyzWhat to you mean...
- Tags: Document management, Name
- Q&A 2006-07-20
- Comparing columns of numbers in Excel
- I've never used Excel before yesterday, but I have two sets of data that I transferred into one spreadsheet and I'm trying to compare values in one column with values in another(not row vs. row). For example:Column A Column C1 ...
- Tags: PRODUCTIVITY, jaymcgovern@..., Microsoft Excel
- Discussion threads 2007-09-19
- Iterating through tables and databases in SQL Server
- could not see the output as shown, for the second stored procedureI could not see the output as shown, for the second stored procedure. I mean, I was not able to see the table name just as they are shown in the example. Instead, it showed me "No column name".Need...
- Tags: Databases, panchal_manoj@..., server, database, Microsoft SQL Server
- Discussion threads 2007-06-12
- Excel: Mix Data Sort
- I need to know how to sort large amount of data in columns when data strings start with one or two characters followed by one to four numbers? For example Excel gives me : AB100, AB11, AB111, AB2,… I would like to get: AB2, AB11, AB100, AB111,…and so on.Can...
- Tags: gmihajlo@..., Microsoft Excel, software
- Q&A 2005-06-22
- Excel VBA to hide a column & unhide it
- I have the following code to enable a hidden columnG to be unhidden, should a certain subcategory in a previous columnE be chosen. I took that from an online example. However what I am trying to achieve without success is the following: I would like columnG automatically to be...
- Tags: Column, ElseIf Target.Column, False ElseIf Target.Column, fhu@..., G, Hidden, Microsoft Excel, software, Target.Value
- Q&A 2005-07-01
- Exportizer Pro (zip)
- Exports database files to file or clipboard with command line support. Possible source formats are: DB, DBF, MDB, XLS, GDB, IB, HTML, UDL, DBC, TXT, CSV. Possible output formats are: XLS, RTF, XML, HTML, TXT, CSV, DBF. Works with databases via ADO or BDE. Allows exporting all database files from...
- Tags: HTML, ImageSkill, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Software downloads 2007-11-12
- sort in excel 2003
- i am having 3 columnsColumn A Column B Columm CFormula Name of Person DateFormula in Column A (=A1+1) WHEN I SORT the column A gives me Value instead of Number...
- Tags: Microsoft Office, nishkrish@..., Microsoft Excel 2003, Microsoft Excel
- Discussion threads 2007-10-05
- multiple column in crystal report
- I have set the multiple column as: Section expert -> Detail -> format with multiple column,but only the detail can multiple column, how can i set the page header multiple column also?Why do u need to make the header multiple column ?Please describe your requirement.
- Tags: multiple column
- Q&A 2005-01-30
- PROC TABULATE and ODS RTF: The Perfect Fit for Complex Tables
- With the great advances in output design SAS and ODS offers the SAS programmer, the bar has definitely been raised in terms of producing presentation quality SAS output. Analysts frequently design table formats in packages such as Microsoft Word and Excel, and request that the SAS programmer fit SAS output...
- Tags: SAS Institute
- White papers 2005-03-09
- Excel Formula
- I have a spreadsheet that has a column with specific locations. What I want to do is create a formula that will look at that column and return the cell information only if it matches what I am looking for. In other words, if the column had 1,2,3,4...
- Tags: fields098@..., Microsoft Excel
- Discussion threads 2007-04-13
- STDEV IF???
- hi guys, sorry if this has been postd before but i have tried searching the forumns and couldnt get an answer. what i need to do is using Excel obtain a STDEV from results in a column call it column A but ONLY when there is a particular result in...
- Tags: Microsoft Excel, adam@..., STDEV
- Discussion threads 2007-08-20
- 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
- Excel help, constant running total
- I need help with an inventory workbook our company has. We need it to have a running total of parts instock, and as we use the worksheet to input data, the inventory will change and then we have another sheet for output data that will tell us what parts we...
- Tags: Excel Help, james62, software, Microsoft Excel, cell
- Q&A 2006-05-02
- Tech Tip: Use awk to format output
- Many Linux administrators use tools such as cat and grep to view or watch logs and other changeable files that contain data, but there are more robust commands, such as awk, that can perform more precisely formatted file actions. For instance, assume you run the...
- Tags: Guest Contributor, Linux Tips Newsletter, Grep, Awk, IP, IP Address, Network Technology, Networking
- Technical articles 2003-12-08
- SAS With Style: Creating Your Own ODS Style Template for RTF Output
- Once you've started using the Output Delivery System, you'll quickly discover that your taste in output design probably doesn't coincide with the built in ODS styles shipped with SAS software. While you can edit your RTF output in Word to improve its appearance, a better approach is to create your...
- Tags: SAS Institute
- White papers 2004-04-14
- multiple column, balancing column ...
- I want to balancing left column and right column i use multiple column format - 2 column.ex. i have 80 items of data. if record 40 then record 41 i want to move to right column.please helpthank you and sory for my english.priyanta, java.IndonesiaPlease specify your application: COBOL, Access, VB?If...
- Tags: Programming languages, Microsoft Office, priyanta2000@...
- Q&A 2006-05-11
- excel cell comparison question
- i have 1 column initially and will add more columns weekly,, the new column will be inserted adjacent to the 'key' data column,,the new column may be of different row counts so the rows will not always match up horizontally.. however i need to match up any equal values in...
- Tags: ironfist03
- Discussion threads 2007-02-27
- How do I... Reseed a SQL Server identity column?
- Microsoft SQL Server's identity column generates sequential values for new records using a seed value. You can control the column's first and subsequent values, by specifying those values when you create the column. The good news is that seeding and reseeding an identity column is easy and relatively safe, if...
- Tags: Microsoft SQL Server, Server, Column, Value, Susan Harkins, Identity Column, Databases, Enterprise Software, Software, Data Management
- Download resources 2008-07-15
- Excel macros for finding out recurring values in a column
- This is what I need to do:for worksheet.column= p13 value='Blocked'On activating worksheet1.check the status cloumn in each worksheet in the file.2.if status value is blocked, give count3.check if value is present in defect column where the value of status is blocked.4.then check the count of values in defect cloumn.should be...
- Tags: Microsoft Excel, manju.jacob@..., defect column
- Discussion threads 2007-08-01
- << Previous
- page 1 of 1
- Next >>
