Search Results

Search found 7127 results on 286 pages for 'calculated columns'.

Page 20/286 | < Previous Page | 16 17 18 19 20 21 22 23 24 25 26 27  | Next Page >

• Compare 2 sets of data in Excel and returning a value when multiple columns match

  - by Susan C

  I have a data set for employees that contains name and 3 attributes (job function, job grade and location). I then have a data set for open positions that contains the requisition number and 3 attributes (job function, job grade and job location). For every employee, i would like the three attributes associated with them compared to the same three attributes of the open positions and have the cooresponding requisition numbers displayed for each employee where there is a match.

  Read the article

• Random password generator: many, in columns, on command line, in Linux

  - by Adam Backstrom

  A while back, I came across a random password generator for the command line that displayed a grid of "memorable" passwords. Output was something like this: adam@host:~$ CantRememberThisCommand lkajsdf aksjdfl kqwrupo qwerpoi qwerklw zxlkelq The idea was that you could run this utility while someone was looking over your shoulder, and still pick a password with some level of secrecy due to the large number of choices. I cannot remember what this utility was called. Oh interwebs, can you help?

  Read the article

• View numeric columns in hex - SQL Server Management Studio

  - by Jonathan

  In SQL Server Management Studio, when I run a query which outputs a numeric column (int or similar types), they are displayed in decimal (example: 193). I want them to display in hex (example: 0xC1). How do I do that? I found many answers on how to write converter functions, but I don't want that - only change the display in SSMS. I only found this unanswered question. I use SQL2010, though may move to SQL2012 soon.

  Read the article

• Traspose matrix-style table to 3 columns in Excel

  - by polarbear2k

  I have a matrix-style table in excel where B1:Z1 are column headings and A2:A99 are row headings. I would like to convert this table to a 3 column table (column heading, row heading, cell value). It does not matter in what order the new table is. A B C D A B C A B C 1 H1 H2 H3 1 H1 R1 V1 1 H1 R1 V1 2 R1 V1 V2 V3 => 2 H1 R2 V4 or 2 H2 R1 V2 3 R2 V4 V5 V6 3 H1 R3 V7 3 H3 R1 V3 4 R3 V7 V8 V9 4 H2 R1 V2 4 H1 R2 V4 5 H2 R2 V5 5 H2 R2 V5 6 H2 R3 V8 6 H3 R2 V6 7 H3 R1 V3 7 H1 R3 V7 8 H3 R2 V6 8 H2 R3 V8 9 H3 R3 V9 9 H3 R3 V8 I've been playing around with the OFFSET function to create the whole table but I feel like a combination of TRANSPOSE and V/HLOOKUP is required. Thanks

  Read the article

• SUM condition on one set of columns where another includes certain values

  - by pjp

  I have the following data in Excel where I want a formula that will give me the sum of all of the total rows: A B australia 10 australia total 10 china 1 china 5 china 7 china total 13 I have tried formulae along the lines of =sumif(A:A,"search("total",A:A)>0",B:B) but I cannot get the condition to work. What is the correct way to write this contains condition? Is there also specific a grammar for the condition language? I've been unable to find anything.

  Read the article

• Is there a better way to have a two column website with header and footer, equal height columns and stretchy column widths? [closed]

  - by Seamus

  I wrote a website a while ago that is a little messy in how it does things. I used this CSS template and this equal height columns trick. I have not one but two container divs and I can't remember what they're doing. So I'm thinking of re structuring the thing from scratch, and possibly making use of the more "semantic" html5 tags like <nav> and so on at the same time. The question is: is there a better way to achieve a site structure with these properties: 2 equal height main columns (with widths as percentages of the available real estate, not explicitly stated) both a header and footer element that stretch the whole width of the total of the two main columns That allows the use of semantic html5 tags instead of meaningless divs

  Read the article

• read numbers from files in columns, one column whole numbers, other column numbers with decimals

  - by user320950

  int price=' '; // attempt to grab a decimal number - but not the correct way int itemnum=' '; // attempt to grab a whole number - but not the right way while((price== (price*1.00)) && (itemnum == (itemnum*1))) What is a way to get numbers in 2 diff columns where one column is whole numbers and the other are numbers with decimal places?

  Read the article

• Transpose a set of rows as columns in SQL Server 2000

  - by Codeslayer

  Is there any facility of transposing rows to columns in SQL Server (it is possible in MS-Access)? I was befuddled because this facility is available in MS-Access but not in SQL Server. Is it by design that this feature has not been included in SQL Server?

  Read the article

• Freeze columns in JXTable

  - by black-rocky

  I'd like to be able to freeze columns in JXTable just like in Excel spreadsheet and came across this project: xframe-swing's JXTable. Just wondering if there is a tutorial for this project. Note that this is not the same as JXTable in swingx project. Or perhaps there is another way?

  Read the article

• Calling stored procedure from another stored procedure and returning result as new columns

  - by luppi

  How to call stored procedure from another stored procedure and return the result as first one's column? ALTER PROCEDURE [dbo].[GetItems] AS SET NOCOUNT ON SELECT ID, AddedDate, Title,Description, Result of Stored Procedure "CountAll" call with parameter ID as Total FROM dbo.Table1 And also: how to be if CountAll stored procedure returns some columns and not just scalar?

  Read the article

• NSTableView get rid blank space separating columns

  - by Matt S.

  I have an NSTableView with 4 columns. I also have a custom background color for each row. The only problem is I have these ugly white spaces where the gridlines would go in both the horizontal and vertical axis. I have both unchecked in IB, but they still show up. How can I get rid of the vertical ones and change the color and size of the horizontal ones? Here's what I see:

  Read the article

• select multiple columns using linq and sum them up

  - by Yustme

  Hi, How can i select multiple columns and calculate the total amount. For example, in my database i got a few fields which are named: 5hunderedBills, 2hunderedBills, 1hunderedBills, etc. And the value of those fields are for example: 5, 2, 3 And the sum would be: 5hunderedBills * 5 + 2hunderedBills * 2 + 1hunderedBills * 3 How can i do that with LINQ in one select statement?

  Read the article

• Extracting columns from text file using Perl: similar to Unix cut

  - by atricapilla

  Hi, I'm using Windows and I would like to do extract certain columns from text file using Perl, Python, batch etc. one liner. On Unix I could do this: cut -d " " -f 1-3 <my file> How can I do this on Windows?

  Read the article

• Exporting gridview to excel with combo,checkbox type columns + winforms

  - by Royson

  Hi, I want to export grid view data to excel file in windows forms application. I tried one solution but it fails to export combo box type column to excel. Excel file should have combo box, check box columns. Thanks..

  Read the article

• Sqlite table constraint - unique on multiple columns

  - by Rich

  I can find syntax "charts" on this on the sqlite website, but no examples and my code is crashing. I have other tables with unique constraints on a single column, but I want to add a constraint to the table on two columns. This is what I have that is causing a SQLiteException with the message "syntax error". CREATE TABLE name (column defs) UNIQUE (col_name1, col_name2) ON CONFLICT REPLACE I'm doing this based on the following: table-constraint

  Read the article

• finding the keyword in multiple columns and show the text around it

  - by hao

  If I want to do a search on multiple columns for the keyword abc using like %abc%, how would I show some of the text around that keyword. Similar to what Google does with its search results.

  Read the article

• WPF DataGrid Columns not auto sizing when not visible

  - by Dave

  I have a datagrid inside an expander that are initially closed. When the expander is opened, the columns are all at the minimum width. Is there a way to force a recalculation of the widths? Thanks!

  Read the article

• WPF ListView example showing all possible kinds of columns including hypelink and checkbox

  - by MicMit

  Could anyone help with a link to comprehensive example or book with all possible kinds of columns for ListView. ListView is bound to Observable collection but read-only ( except checkboxes which are primarily to drive certain actions for selected rows for the application ).

  Read the article

• MYSQL - Rows to Columns

  - by Bob Rivers

  Hi, I tried to search posts, but I only found solutions for SQL Server/Access. I need a solution to MYSQL (5.X). I have a table with 3 columns: hostid, itemname, itemvalue. If I do a select, it will return 1 A 10 1 B 3 2 A 9 2 C 40 How do I query the database to return something like A B C 1 10 3 2 9 40

  Read the article

• Windows Form - List View - Removing lines between columns

  - by gary

  I need to display a listview in winforms which should not have any lines between columns. I tried GridLines=false and also tried setting HeaderStyle to ColumnHeaderStyle.None. But this is not working. I want to remove the 2 vertical lines coming in the middle.

  Read the article

• When I remove rows in Cassandra I delete only columns not row keys

  - by Matroska

  Hi, If I delete every keys in a ColumnFamily in a Cassandra db using remove(key), then if I use get_range_slices, rows are still there but without columns. How could I remove entire rows? Thanks Tobia Loschiavo

  Read the article

• Windows Form - ListView - Removing lines between columns

  - by gary

  I need to display a ListView in WinForms which should not have any lines between columns. I tried GridLines=false and also tried setting HeaderStyle to ColumnHeaderStyle.None. But this is not working. I want to remove the 2 vertical lines coming in the middle.

  Read the article

• SQL storing data about columns

  - by Chris

  I'm learning SQL Server Compact for a program I'm writing that requries a local database. I have multiple tables, each with different columns and I'd like to mark each column as being a certain type (not a data type, just an integer tag) to let the program know what to do with it. I'm clueless about SQL. How does one do this?

  Read the article

• Change the precision of all decimal columns in every table in the database

  - by Jon

  Hi all, I have a rather large database that has alot of decimal columns in alot of tables, the customer has now changed their mind and wants all the numbers (decimals) to have a precision of 3 d.p. instead of the original two. Is there any quick way of going through all the tables in a database and changing any decimal column in that table to have 3.d.p instead of 2 d.p? The db is on sql 2005. Any help would be great.

  Read the article

• VB.net Reading from ListViews with Multiple Columns

  - by xzerox

  Alright. So I was able to find out how to read from the first column but I need to read from both of them. I am using full row select which I need on there. Here is the code I am using to get it for the first column. Dim I As Integer For I = 0 To ListView1.SelectedItems.Count - 1 MsgBox(ListView1.SelectedItems(I).Text) Next MessageBox.Show(ListView1.Columns(0).Text)

  Read the article

< Previous Page | 16 17 18 19 20 21 22 23 24 25 26 27  | Next Page >