Search Results

Search found 74473 results on 2979 pages for 'data table'.

Page 294/2979 | < Previous Page | 290 291 292 293 294 295 296 297 298 299 300 301  | Next Page >

• MS-Access: SQL for updating a column in a table

  - by tecnodude

  Hi, I have the following table in an access database id VisitNo Weight 1 1 100 1 2 95 1 3 96 1 4 94 1 5 93 Now row 2 and 4 are deleted. So i have... id VisitNo Weight 1 1 100 1 3 96 1 5 93 However what i need is... id VisitNo Weight 1 1 100 1 2 96 1 3 93 What is the SQL query i need to accomplish the above? thanks

  Read the article

• Query for second maximum salary from employee table

  - by Dinesh

  how to find out second maximum salary from all employee in employee table ? please give me sql query.

  Read the article

• Question on jpa joined table inheritance

  - by soontobeared

  Hi, The 'DiscriminatorColumn' annotation isn't creating any column in my parent entity. Where am I going wrong ? Here's my code @Entity @Inheritance(strategy=InheritanceType.JOINED) @DiscriminatorColumn(name="TYPE", discriminatorType=DiscriminatorType.STRING,length=20) public class WorkUnit extends BaseEntityClass implements Serializable{ @Entity @DiscriminatorValue(value="G") @Table(name="Group_") @PrimaryKeyJoinColumn public class Group extends WorkUnit implements Serializable{

  Read the article

• have mysql select statement return fully qualified column names like table.field

  - by handsomeGun

  is there a way to have a mysql select statement return fully qualified column names like "table.field" without using AS for every single field? like so: SELECT * FROM table1 LEFT JOIN table2 on table1.f_ID = table2.ID and the result would be: "table1.ID", "table1.name", "table2.ID", "table2.name", ...

  Read the article

• Import/Export table definistrions using SQlServer Management Studio

  - by fireBand

  Hi, How to import/export table definitions from my dev database to production database(recreate the whole database). I have Sql server 2005, Sql Management studio with power shell. Thanks in advance.

  Read the article

• mysql :ordering table with day names

  - by Meko

  Hi.I am trying to get day of names with and correct order like Monday ,Tuesday.. But in my table I have records that after Monday comes Friday or I have Thursday between two Tuesday .I want to order them like Monday ,Monday ,Tuesday ,Tuesday, Wednesday so on .But I don`t want to group them. I used this query but it does not make order select Day_Name from mydb.schedule where Room_NO=(510) And Week_NO =(1) it outputs Monday Monday Tuesday Wednesday Wednesday Tuesday Thursday Thursday Thursday how can I correct it?

  Read the article

• Scanning a mysql table from the bottom

  - by ming yeow

  When i run a mysql select statement, it takes very long because i have already previously deleted a very large number of rows. Is there a way for the table to start scanning from the bottom, as opposed to from the top?

  Read the article

• jQuery:Looping all radio buttons inside an HTML table

  - by Shyju

  I have an HTML table having n rows and each rows contain one radiobutton in the Row.Using jQuery , How can i look thru these radio buttons to check which one is checked ?

  Read the article

• Add table to SPDatabase object

  - by Ramnik

  I have created a database using a SPDatabase class. How can i add a table to it? and how to execute SQL queries in this database? Thanx....

  Read the article

• MYSQL: Udate table column from subquery result

  - by Jhourlad Estrella

  On the Members table are columns "MemberID" and "PointsEarned". I want to update the PointsEarned column from the result of this query: SELECT m.MemberID, m.UserName, ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=2)*10 ) + ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=3)*3 ) + ( (SELECT COUNT(*) FROM ChatMessages as c WHERE c.MemberID=m.MemberID)*.1 ) as PointsEarned FROM Members as m Can anybody tell me how I should do it with a single query? Thanks!

  Read the article

• LaTeX: Breaking long (sub)section titles in Table of Contents

  - by V.Shevchishin

  Hi! Is it possible to tune LaTeX to break automatically long (sub)section titles in the Table of Contents?

  Read the article

• How to decrease width of table view cells for iphone

  - by David Hsu

  I'm trying to create a grouped table view with two sections. For the first section I would like the width to be only half the screen. For the second section it would be the standard width. Also, next to the first section I would like to put a button. How is this done? Thanks!

  Read the article

• parse html table using ASP.NET

  - by Milee

  Hi, I need to read a html page and parse the contents of a table in that. I am using ASP.NET.Could anyone tell me how to do this. Thanks.

  Read the article

• jQuery and HTML visual glitches on table cell .toggle

  - by Forkrul Assail

  I have table that gets dynamically created. When using jQuery and toggle, everything works. I however get a small visual glitch - it seems the HTML sometimes get selected. How would I disable this on a faulty drag or mouse operation? Is there a difference in the DOM between text in a cell and 'not text' or buffered space in a td? Thanks in advance.

  Read the article

• Creating aspnet_membership table, need script please...

  - by John

  Does anyone out there have a create script for aspnet_membership table? I found a data structure for it on MS site but cannot find a script to create it anywhere on the web. Many thanks in advance J

  Read the article

• self join table

  - by San82moon

  HI, i have a table, new_id----old_id----created_on 1234------5678------20100912 5678------3456------20100808 etc. i wrote this query, $q = "select event1.new_id, event1.old_id, event1.created_on,event2.new_id, event2.old_id, event2.created_on FROM replaced_isbns event1 JOIN replaced_isbns event2 ON event2.new_id = event1.old_id WHERE event1.new_id='$id'"; but i get result as 5678 - 1234, ie only one row, i want all rows... plz help me. Thanks, SLC

  Read the article

• Need recommendation for a table structure

  - by yapiskan

  I have an entity which has 4 different types of property that could have only one value for each case which are boolean, decimal, string or text. I don't want to define the table with 4 boolean, decimal, nvarchar and ntext columns. What would you recommend to cover this case?

  Read the article

• Windows.Forms control like "properties" table in VS.

  - by Chaotic_one

  I need a table control where one can edit properties by various ways, just like editing properties in Visual Studio (it's for XML editing). Does anybody know about something like that, written by others, or maybe a solution from MS itself?

  Read the article

• Oracle dual table

  - by Avg

  Is there any way to create / recreate dual table in oracle. It was accidentaly dropped from oracle database.

  Read the article

• Table Adapter query Builder ASP.NET

  - by kmsony32

  I want to connect my Table adapter with the Oracle, for that I am preparing a sql query with the query builder. The query which is running fine in Oracle but makes syntax error with query builder.It shows unable to parse the query text. I am using case statement and joins within the query.

  Read the article

• How to insert the last id from a table into another table in MySQL?

  - by James

  I want to take the id of the most recent item in a database, increment it by one and insert that new id in to another table. I tried: $select = mysql_query("SELECT id FROM tableName ORDER BY id DESC"); while ($return = mysql_fetch_assoc($select)) { $id = $return['id']; $newId = $id++; } mysql_query("INSERT INTO anotherTable (someColumn) VALUES ('$newId')"); But it didn't work. How can this be done?

  Read the article

• SQL Query to return both distinct and total logins from a login table in sql2005

  - by Prescott

  Hey all, I have a table Logins { Id, AccessTime }, I'd like to write a query that returns 3 columns, Total Logins during a time period, Unique Logins for a time period, and the Id of the user. I know I could do this with two passes and a join, is there a better way to do it in a single pass? Thanks, ~P

  Read the article

• Selecting from a Large Table SQL 2005

  - by Eugene

  I have a SQL table it has more than 1000000 rows, and I need to select with the query as you can see below: SELECT DISTINCT TOP (200) COUNT(1) AS COUNT, KEYWORD FROM QUERIES WITH(NOLOCK) WHERE KEYWORD LIKE '%Something%' GROUP BY KEYWORD ORDER BY 'COUNT' DESC Could you please tell me how can I optimize it to speed up the execution process? Thank you for useful answers.

  Read the article

• sql: delete a subtree table(id, Parentid) , delete a item with all his children

  - by Omu

  I have a table like this foo(id, parentId) -- there is a FK constraint from parentId to id and I need to delete an item with all his children and children of the children etc. anybody knows how ?

  Read the article

• Sql joining a table

  - by benjamin button

  I have a question regarding the Sql Joins. whenever we join two different tables on some fields. what will happen exactly inside oracle which will result in the query output. will there be a temporary table created just for presenting the query output.

  Read the article

< Previous Page | 290 291 292 293 294 295 296 297 298 299 300 301  | Next Page >