Search Results

Search found 10060 results on 403 pages for 'column'.

Page 242/403 | < Previous Page | 238 239 240 241 242 243 244 245 246 247 248 249  | Next Page >

• Bulk Compare, Report, Update

  - by Tim Donaldon

  I need to import either csv or excel file into a dbase. The column headers will match but I will want to compare the file against the dbase using an ItemID field, list the rows to be affected and the differences, then allow an update to all the rows with the matching ID.

  Read the article

• How many indexes will actually get used?

  - by Ender

  I'm writing a page that does very simple search queries, resulting in something like: SELECT * FROM my_table WHERE A in (a1, a2, a3) AND B in (b1, b2) AND C in (c1, c2, c3, c4) AND And so on for a variable number of columns, usually ~5. If I create a separate index for each column (one for A, one for B, one for C, not (A,B,C)), will all of them be used in the above query?

  Read the article

• How to Add a default value in SQL server compact?

  - by Suryakavitha

  Hi , I need to add default value column in SqlServer Compact....i am new to this SQL server compact so Plz anyone tell me the Solution of this.... Thanks In Advance

  Read the article

• Datagrid in JSP

  - by Geethapriya.VC

  Hi, I need to create a Datagrid with a radiobutton column in JSP. The grid is to be binded dynamically to a result set and be populated accordingly. This result set is obtained as a result of search in the database. Please do help with a sample source code, or a useful link for the same. Thanks in advance, Geetha

  Read the article

• MATLAB: How does the syntax (:) work?

  - by user198729

  Given the following example: >> I=[2 1 3;3 2 4] I = 2 1 3 3 2 4 >> I(:) ans = 2 3 1 2 3 4 >> I(1:2) ans = 2 3 Why does I(:) return a column vector while I(1:2) returns a shorter row vector?

  Read the article

• jquery tablesorter sorting numbers incorrectly

  - by Hintswen

  My table has a column of numbers which are sorted incorrectly. Example numbers: 5.8 2.4 10.7 0.1 1.9 and basically my problem is 10.7 should be at the very end/very start depending on which way it was sorted. but it is showing up in the middle.

  Read the article

• Using hyperlink control with imagefield control in gridview

  - by niks

  I have a gridview and a column of that gridview is displaying images whose path is stored in a database & image is stored in locale folder inside my website. My problem is that I want to use the hyperlink control with the image, so that when the image is clicked it should jump to another page. How can I do that?

  Read the article

• MySQL: difference of two result sets

  - by Zombies

  How can I get the set difference of two result sets? Say I have a result set (just one column in each): result1: 'a' 'b' 'c' result2: 'b' 'c' I want to minus what is in result1 by result2: result1 - result2 such that it equals: difference of result1 - result2: 'a'

  Read the article

• Oracle - Return shortest string value in a set of rows

  - by Sridhar

  Hi, I'm trying to write a query that returns the shortest string value in the column. For ex: if ColumnA has values ABCDE, ZXDR, ERC, the query should return "ERC". I've written the following query, but I'm wondering if there is any better way to do this? BTW, the query should return a single value. select distinct ColumnA from ( select ColumnA, rank() over (order by length(ColumnA), ColumnA) len_rank from TableA where ColumnB = 'XXX' ) where len_rank <= 1 Thank you.

  Read the article

• Move row from one table to another?

  - by lance

  I have two tables with the same column definitions. I need to move (not copy) a row from one table to another. Before I go off and use INSERT INTO/DELETE (in a transaction), is there a smarter way? SQL Server 2005

  Read the article

• Whiel Update ,datetime value is rounded to seconds.! i want milliseconds too

  - by sajad

  Hi friends, While updating a datatime column in a table from another table, i noticed that mnilliseconds value are not shown.. instead it is rounded and the value is updated to nearest seconds. Example : Original Value: 2008-06-26 14:06:36.643 Updated Value : 2008-06-26 14:07:00 Please help me getting the actual value including milliseconds

  Read the article

• Remove trailing zeros from decimal in SQL Server

  - by abatishchev

  I have a column DECIMAL(9,6) i.e. it supports values like 999,123456. But when I insert data like 123,4567 it becomes 123,456700 How to remove those zeros?

  Read the article

• After running merge in mercurial how do I list files that required a merge?

  - by Brandon Leiran

  TortoiseHg adds a "ms" (merge status?) column after doing a merge which indicates 'R' or 'U'. What is the equivalent command line command?

  Read the article

• connecting power point and excel

  - by silverkid

  how to connect power point and excel such that each slide in the powerpoint slideshow shows next excel cell in the cell in column A of excel.

  Read the article

• mysql storing problem

  - by pradeep

  hi, i have a column like decimal(2,1) , its working well, but when i try to store a value like 10 it stores as 9.9 ..any specific reason?

  Read the article

• Cannot resolve collation conflict in Union select

  - by phenevo

  Hi, I've got tqo queries: First doesn't work: select hotels.TargetCode as TargetCode from hotels union all select DuplicatedObjects.duplicatetargetCode as TargetCode from DuplicatedObjects where DuplicatedObjects.objectType=4 because I get error: Cannot resolve collation conflict for column 1 in SELECT statement. Second works: select hotels.Code from hotels where hotels.targetcode is not null union all select DuplicatedObjects.duplicatetargetCode as Code from DuplicatedObjects where DuplicatedObjects.objectType=4 Structure: Hotels.Code -PK nvarchar(40) Hotels.TargetCode - nvarchar(100) DuplicatedObjects.duplicatetargetCode PK nvarchar(100)

  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

• inner join in sql

  - by vini

  SELECT TotalItems.Total_Items ,TotalItems.No_Items_Present ,ItemsTable.No_Of_Items_Ret FROM TotalItems INNER JOIN ItemsTable ON ItemsTable.Item_Name= '" + DropItemName.SelectedValue + "'" this is my SQL query what I want is to retrieve two column values corresponding to the item I enter in my dropdown list from one table and the no_of_items_ret from another table satisfying the condition of the dropdownlist I'm getting all the values corresponding to any item I enter what should i do?

  Read the article

• RSS feed publish date-time (GMT) to Unix timestamp format using PHP

  - by PHP-Prabhu

  How do convert RSS feed publish date-time (GMT) to Unix timestamp using PHP? I need to store the date into my table in a TIMESTAMP data type column.

  Read the article

• Is there a web-like DB tool for navigating relational databases?

  - by Caffeine Coma

  Is there a tool that implements hyperlink-style navigation between tables via foreign keys? Web-based or native app. For example, if I have table Users, with a column containing a foreign key reference to table Preferences, such a tool would implement simple 1-click access between the rows of the two tables, automatically creating links based on foreign keys.

  Read the article

• silverlight button onClick event

  - by Anish Mohan

  Hi, Might be this question a blunder :(... I have a a button in silverlight application... <Button Height="25" Width="100" Grid.Column="0" Grid.Row="0" Click="Button_Click"/> I read that silverlight need WCF to interact with server side... So is it like to access my "Button_Click" event I need WCF ?

  Read the article

• Deny access to run certain installed software for users

  - by clyfe

  I have a list of installed software, obtained from WMI class select * from Win32_Product. I'd like to deny execution rights for some users on certain software like so: find the path to installed software recursively remove execution rights I find the path to installed software from Win32_Product InstallLocation column. But the PROBLEM is that not all rows in Win32_Product have a value for InstallLocation. What can I do to overcome this? Is there somewhere in registry where I can find this path?

  Read the article

• How to use split in sql 2005?

  - by meenakshi

  Table column has values with comma separated for ex: (1,2,3) How to split this like 1 2 3 or 1 2 3 in sql2005.

  Read the article

• JQuery Tablesorter clear table information

  - by conversoid

  I've created a jquery table that from time to time needs to be cleared and the re-populated, my clear method is this: //Clear table content before repopulating values $('#tabela_dash2_maquinas .real-content table tr:gt(0)').remove(); Now i'm trying to use tablesorter to sort a specific column, but my problem is that when I enable the tablesorter: //Initialize tablesorter $("table").tablesorter(); The table clearing method is not working anymore, it just keeps adding the new data with the old data, creating a lot of repeated information. Please help

  Read the article

• Sqlite3 and PDO problem with ORDER BY

  - by Maenny

  Hi, I try to use the SQL statement SELECT * FROM table ORDER BY column via an PDO-Object in PHP. Problem is, that I always get an error (Call to a member function fetchall() on a non-object - that means, the query did not return a PDO-object) when using the names of all columnname EXCEPT for ID. When I query SELECT * FROM table ORDER BY ID it works. ID is the PRIMARY INTEGER KEY, all other columns are TEXT or NUMERIC, neither of them would works with the ORDER BY clause. Any ideas?

  Read the article

< Previous Page | 238 239 240 241 242 243 244 245 246 247 248 249  | Next Page >