Search Results

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

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

• Transmogrify into date from multiple columns

  - by Dave Jarvis

  What is a better way to program the following SQL: str_to_date( concat(convert(D.DAY, CHAR(2)), '-', convert(M.MONTH, CHAR(2)), '-', convert(M.YEAR, CHAR(4))), '%e-%m-%Y' ) as AMOUNT_DATE I want to convert the columns D.DAY, M.MONTH, and M.YEAR to a date field using MySQL. The above works, but seems much more complicated than it needs to be. (If there's an ANSI SQL way to do it, that would be even better.) Thank you!

  Read the article

• SQL WHERE.. IN clause multiple columns

  - by ala

  i need to implement the following query in SQL Server select * from table1 WHERE (CM_PLAN_ID,Individual_ID) IN ( Select CM_PLAN_ID, Individual_ID From CRM_VCM_CURRENT_LEAD_STATUS Where Lead_Key = :_Lead_Key ) but the WHERE..IN clause allows only 1 column. How to compare 2 or more columns with another inner select?

  Read the article

• How to store data with N columns

  - by iconiK

  I need a way to store an int for N columns. Basically what I have is this: Armies: ArmyID - UINT UnitCount1 - UINT UnitCount2 - UINT UnitCount3 - UINT UnitCount4 - UINT ... I can't possible add a column for each and every unit, so I need a fast way to store the number of each units in an army (you might have guesses it's for a game by now). Using XML is not an option as it will be dead slow.

  Read the article

• setup format for columns of DataTable or GridView

  - by ncdy

  How can I setup some format for cells in some column in my DataTable or GridView ? I need to make some double columns rounded , for example : 3.564643 - 3.56 3.546723 - 3.55 6.654644 - 6.65 thank you.

  Read the article

• One value display two columns in data grid

  - by Nair

  I have a XML with 3 values, they are 'name', 'department', 'value'. I want to display a data grid with four columns like Name, department, credit and debit. When I have a value positive in 'value' column I want to enter the value in debit column and 0 in credit column and vice versa.

  Read the article

• Selecting specific range of columns with jquery

  - by AdamB

  I'm looking to select columns 2-4 on the 2nd row in a table. Does jquery have any sort of "and" function in their selectors? Or would I have to do something like this? $('#id tr:eq(1)').find('td:lt(5)').find('td:gt(1)')

  Read the article

• Drupal Views Question: Displaying results in two columns?

  - by Jonathan

  I'm new to drupal and I have a question about views: I'm building an employee directory and need to display the results in two columns, such as: Record 1 Record 2 Record 3 Record 4 Record 5 Record 6 . . . How can I accomplish this? To take it one step further, I want each record formatted as: IMAGE NAME TITLE I have no idea where to start. Any assistance is appreciated!

  Read the article

• Python: Comparing specific columns in two csv files

  - by coder999

  Say that I have two CSV files (file1 and file2) with contents as shown below: file1: fred,43,Male,"23,45",blue,"1, bedrock avenue" file2: fred,39,Male,"23,45",blue,"1, bedrock avenue" I would like to compare these two CSV records to see if columns 0,2,3,4, and 5 are the same. I don't care about column 1. What's the most pythonic way of doing this? EDIT: Some example code would be appreciated.

  Read the article

• MySQL> Selecting from more tables (with same columns) without UNION

  - by Petr

  Hi, It is probably pretty simple but I cannot figure it out: Say I have tables A and B both with the same columns. I need to do SELECT * FROM A,B without having results merged into one row. I.e. when each table has 2 rows, I need the result to have 4 rows. EDIT: I know about JOIN but dont know how to join the tables without predicate. I need merge them. Thanks

  Read the article

• Nhibernate Common columns in base class

  - by sukh

  I want to design following scenario Base class (Id, Name, order, Value) 3 Derived classes derive1, derive2, derive3 inheriting properties from base There is no table for base class. And 1 table for each derived class. 3 tables have same columns. How can I create mapping file ignoring base class? Do I need to create 1 mapping file for each derived class? can I achieve this using only 1 mapping file?

  Read the article

• Sorting headers for Data Columns

  - by nani

  For the data obtained from data set, how to design Sorting headers for Data Columns in grid view in asp.net? Thank You.

  Read the article

• SQL Server- PIVOT table. transform row into columns

  - by Matt

  I am trying to convert rows into columns. here is my query SELECT M.urn, M.eventdate, M.eventlocation, M.eventroom, M.eventbed, N.time FROM admpatevents M INNER JOIN admpattransferindex N ON M.urn = N.urn AND M.eventseqno = N.eventseqno AND M.eventdate = N.eventdate WHERE M.urn = 'F1002754364' AND M.eventcode = 'TFRADMIN' Current result URN Date Location Room Bed Time F1002754364 20121101 EDEXPRESS 4-152 02 0724 F1002754364 20121101 CARDSURG 3-110 02 1455 F1002754364 20121102 CHEST UNIT 6-129-GL04 1757 required result F1002754364 20121101 EDEXPRESS 4-152 02 0724 20121101 CARDSURG 3-110 02 1455 20121102 CHEST UNIT 6-129-GL 04 1757 Thanks for your help.

  Read the article

• how to disable or enable the columns in the jquery gird

  - by kumar

  I have 6 columns in jquery grid.. Initially I need to hide the 6th column for user.. I did that made Visible= false for that perticular column now I need to make disabled that column perminently that is i should not give access for the user to sort or do something else on the column only readable? thanks

  Read the article

• How to save datagridview columns with datas in sql server database

  - by Shiny

  Scenario is.... I have to select a row in datagridview and save those datas to database.It can any number of columns present. how to achieve this..

  Read the article

• how to disable or enable the columns in the jquery gird

  - by kumar

  how to disable or enable the perticular column in the jquery? that is I have three columns in the jquery.. all three all dropdown list boxes. Initially all three dropdownlist boxes are disabled on selection firstdropdown I need to eable the second dropdow list box and second I need to enable the third dorpdonwl list box.. please can anybody help me out on this.. thanks

  Read the article

• The right way to write "ID" in columns in SQL

  - by radbyx

  My first question in here. I like the site so much :) I've a SQL table called Product. In that table I want to make a column for the ID of the product, and I really like to now the right way of write ID because I make alot of ID columns in the long run. So is it: "ID" or "Id" ? And also a foreign key in another table, is that called ProductID or ProductId? Thx guys.

  Read the article

• Oracle : select maximum value from different columns of the same row

  - by gregseth

  The whole question is pretty much in the title. For each row of the table I'd like to select the maximum of a subset of columns. For example, from this table name m1 m2 m3 m4 A 1 2 3 4 B 6 3 4 5 C 1 5 2 1 the result would be name max A 4 B 6 C 5 The query must be compatible oracle 8i. Thanks.

  Read the article

• Related boolean columns -- seperate columns or bitpacked into an integer column?

  - by Earlz

  Hello I have a database for a certain record where it needs to store a 1 or a 0 for each day of the week. So which one would be better? Bitshifting each bit into an integer and just having an integer in the database named days or should we make all of them separate boolean values so to have sunday, monday, tuesday... columns?

  Read the article

• How to rearrange Mysql columns?

  - by Lost_in_code

  I need to move the position of existing columns (for better visibility). How can this be done without affecting the data?

  Read the article

• Re-ordering columns in a GridView after bind

  - by samcooper11

  Hi everyone, I want to be able to re-order the columns I have in a GridView. The GridView is populated from a DataTable which is dynamically generated in a seperate class and returned to the aspx code behind page. Is this possible? Thanks in advance

  Read the article

• How to make addition of two columns data for another column where those two columns are type of stri

  - by Harikrishna

  I have datatable and there two column which is type of string and I want to make addition of that two columns data for another column how can I do that ?

  Read the article

• SQL query construction - separate data in a column into two columns

  - by Tommy

  I have a column that contains links. The problem is that the titles of the links are in the same column, so it looks like this: linktitle|-|linkurl I want link title and linkurl in separate columns. I've created a new column for the urls, so I'm looking for a way to extract them and update the linkurl column with them. Is there any clever way to construct a query that does this?

  Read the article

• How can I use linq to select the columns of a jagged array

  - by CoGo

  How can I use linq in C# to select the columns of a jagged array of ints, I select the rows as follows. int[][] values; .... var rows = from row in values select row; Thank you for the help.

  Read the article

• Adding Names to columns in a matrix

  - by Jeff

  I have my matrix I have created, a pic found here. http://s816.photobucket.com/albums/zz83/gavakie/?action=view&current=matrix.jpg The first three column what whats being grouped by but I can had the names of those columns, how can I do that in Reporting Services?

  Read the article

• Invert WPF GridView to bind items to columns instead of rows

  - by emddudley

  Is there a simple way to invert a WPF GridView so that items are bound to columns instead of rows? Or would it be necessary to write a custom view mode?

  Read the article

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