Search Results

Search found 6532 results on 262 pages for 'computed columns'.

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

• 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

• 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

• 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

• 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 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

• 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

• 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

• Select statement always execute/select columns in order?

  - by Aseem Gautam

  Does all the columns in select statement gets selected one after another as listed? Declare @X, @Y SELECT @X = ColumnA*.25 + ColumnB*2.5, @Y = ColumnA*.5 + ColumnC*1.33, TOTAL = @X + @Y FROM SomeTable Is the above query safe to use? Will total always be selected after @X and @Y are calculated?

  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

• SQL - How to join on similar (not exact) columns

  - by BlueRaja

  I have two tables which get updated at almost the exact same time - I need to join on the datetime column. I've tried this: SELECT * FROM A, B WHERE ABS(DATEDIFF(second, A.Date_Time, B.Date_Time) = ( SELECT MIN(ABS(DATEDIFF(second, A.Date_Time, B2.Date_Time))) FROM B AS B2 ) But it tells me: Multiple columns are specified in an aggregated expression containing an outer reference. If an expression being aggregated contains an outer reference, then that outer reference must be the only column referenced in the expression. How can I join these tables?

  Read the article

• NHibernate: Select entire entity plus aggregate columns

  - by cbp

  I want to return an entire entity, along with some aggregate columns. In SQL I would use an inner select, something like this: SELECT TOP 10 f.*, inner_query.[average xxx] FROM ( SELECT f.Id, AVG(fb.xxx) AS [average xxx] FROM foobar fb INNER JOIN foo f ON f.FoobarId = fb.Id ) AS inner_query INNER JOIN foo f ON f.Id = inner_query.Id Is this possible with CreateCriteria?

  Read the article

• Need to transform the rows into columns for the similar ID's in oracle

  - by Siva

  Hi, I need to transform the rows into columns for the similar ID's in oracle e.g. The following is the result I will get if i query my database Col1 Col2 Col3 1 ABC Yes 1 XYZ NO 2 ABC NO I need to transform this into Col1 Col2 Col3 Col4 Col5 1 ABC Yes XYZ No 2 ABC NO NULL NULL Someone please help me in solving this issue Thanks, Siv

  Read the article

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