Search Results

Search found 24705 results on 989 pages for 'tally table'.

Page 677/989 | < Previous Page | 673 674 675 676 677 678 679 680 681 682 683 684  | Next Page >

• How to query by recent date and value in SQL?

  - by wsb3383

  I have a table with three columns: patient_id, obs_date, and weight_val. patient_id stores patient identification #, weight_val stores a weight value, and obs_date stores the date when the weight reading was taken. So, a patient can have many different weight readings at different dates. How do you write a query for: select all patients whose last weight reading is 120?

  Read the article

• Query interface for iPhone CoreData store

  - by JT

  Hi, another iPhone newbie question... I have the following: NSPersistentStoreCoordinator NSManagedObjectContext NSManagedObjectModel Is it possible to run queries directly on the store (since its a sqlite DB)? I'm trying to delete all the records from a tableview, and figured a "DELETE FROM table" would be nice and quick as opposed to looping through the records and removing them manually (which i'm also struggling with). Thanks for your time, James

  Read the article

• Recommendations for places where I can get good css designs/ web 2.0ish buttons, tables, etc...

  - by chris

  Im designing a website, and often I need to present information in a nice table, or need a nice button, etc... I need recommendations for any websites which have a large collection of these elements which I could just use, instead of designing my own. Thanks!!

  Read the article

• Date & time query question (sql-server 2008)

  - by Gold

  hi i have table that contain date and time field. id|date|time ========= 1|01/01/2001|10:45 2|01/02/2002|11:45 3|01/03/2003|12:45 4|01/04/2004|12:55 i need to know the difference between the MAX(date) and the MIN(date) and the MAX(time) and the MIN(time) something like.... MAX(date)-MIN(date) ???..... thank's in advance

  Read the article

• Coding alternative shaded rows?

  - by ming yeow

  I want alternative rows in my table to be shaded. what is the best way to do this, javascript, rails? Today, i do a simple <% num % 2%, but this is such a common operation that i think there should be a smarter way to do it

  Read the article

• Java-Hibernate-Newbie: How do I acces the values from this list?

  - by Mes

  I have this class mapped @Entity @Table(name = "USERS") public class User { private long id; private String userName; } and I make a query: Query query = session.createQuery("select id, userName, count(userName) from User order by count(userName) desc"); return query.list(); How can I acces the value returned by the query?

  Read the article

• how to pass parameters to partial view to show db content?

  - by user278741

  I am getting my content from a database. How can i use partial views to show content on page using that database? database table: Content [Id, Content] these are 2 fields i want to get the content from db using partial views. How i will pass an id to a partial view and show the content in view page?

  Read the article

• how to select the records whose several fields' combination will equal to a specific value

  - by poiu2000

  Hi all, Assume I have the following style table, col1 col2 and col3 have same value scopes, I want to select the records when two of the 3 columns have a value combination such as ('ab' and 'bc'), in the following example, the first 3 records should be selected. Any good way to do this? I am using Sybase. | id | col1 | col2 | col3 | 1 ab bc null 2 null ab bc 3 ab ab bc 4 de ab xy Thanks.

  Read the article

• how to get latest entry of a item when item have multiple rows?

  - by I Like PHP

  i have an table tbl_exp id| exp_id|qnty| last_update 1 | 12 | 10|2010-05-18 19:34:29 2 | 13 | 50|2010-05-19 19:34:29 3 | 12 | 50|2010-05-19 19:34:29 4 | 15 | 50|2010-05-18 19:34:29 5 | 18 | 50|2010-05-20 19:34:29 6 | 13 | 70|2010-05-20 19:34:29 now i need only latest entry of each exp_id id| exp_id|qnty| last_update 3 | 12 | 50|2010-05-19 19:34:29 6 | 13 | 70|2010-05-20 19:34:29 4 | 15 | 50|2010-05-18 19:34:29 5 | 18 | 50|2010-05-20 19:34:29 please suggest me the mysql query to retrive above result?? thanks!

  Read the article

• Exception Handling in SSIS Script Task

  - by Sreejesh Kumar

  Is it possible to redirect the Exceptions occurred to another table/log, in Script Task ? If so, How is it to be done ?

  Read the article

• Mysql dynamic query

  - by pradeep

  I have two table in mysql one tbl_a which has one int column id, second tbl_b which has one column song_ids in which data stored seapated by comma like 1,2,3,4 i want to select all id like this select * from tbl_a where id in (select song_id from tbl_b) but its giving me no record as its varchar HOW to do it in mysql

  Read the article

• what is a candidate row in SQL?

  - by JuiceBerry123

  What is a candidate row when talking about Oracle and SQL? Using it in a sentence would be as such: "The candidate row is fetched from the table specified in the outer query."

  Read the article

• Prevent header from being updated after calling reloadData?

  - by john

  I have a UITableView with a custom header that maintains some state. When I call reloadData to change/update the data in the UITableView, the header gets reloaded too. Is there any way to prevent this behavior in order to maintain state in the table's header?

  Read the article

• sql delete from rows value

  - by gloris

  The database includes a table with a rows: html/css/java/php How with sql query delete "java"? The result would be: html/css/php

  Read the article

• TableView with section & Index

  - by iavian

  could anyone point me to some examples on how to achieve Tableview with section and Index on Section. Similar to one it's in iPhone = http://www.iphonesdkarticles.com/2009/01/uitableview-indexed-table-view.html

  Read the article

• Exception Handling in Script Task

  - by Sreejesh Kumar

  Is it possible to redirect the Exceptions occurred to another table/log, in Script Task ? If so, How is it to be done ?

  Read the article

• How to display mysql rows that contain certain data?

  - by user272899

  I have a table in mysql with a row called 'newrelease'. If the item is a new release my form posts it as 'yes' if no 'no'. How would i display all items that contain the data 'yes'? $query = "SELECT * FROM movielist ORDER BY newrelease DESC LIMIT 4";

  Read the article

• IPhone- Rss sample code, modify to display images... PLease help!!!

  - by avanadra

  Hi! I am trying to make app that displays an RSS feed, with text and images into a table, but I am really struggeling with it! I found a really good [sample code-project][1] that i can really recommend-- but im struggeling getting it to display images in the tablecells instead of only text I would be reeeeally happy with any help!! Thanks

  Read the article

• Marking deleted records in DB tables

  - by Emanuil

  Sometimes you want to mark a DB table record as deleted instead of deleting it permanently, right? How do you do that? So far I've been using a boolean "deleted" field.

  Read the article

• Multithreaded ActiveRecord requests in rspec

  - by jeem

  I'm trying to recreate a race condition in a test, so I can try out some solutions. I find that in the threads I create in my test, ActiveRecord always returns 0 for counts and nil for finds. For example, with 3 rows in the table "foos": it "whatever" do puts Foo.count 5.times do Thread.new do puts Foo.count end end end will print 3 0 0 0 0 0 test.log shows the expected query, the expected 6 times: SELECT count(*) AS count_all FROM `active_agents` Any idea what's going on here?

  Read the article

• Reseeding the Identity column for new records only (SQL)

  - by Arnej65

  I have data in a table, but am working on data loading. I want to reseed all new inserts for testing. What would be the line to set all new inserts to a certain seed value?

  Read the article

• How to check if a Constraint exists in Sql server?

  - by Lieven Cardoen

  I have this sql: ALTER TABLE dbo.ChannelPlayerSkins DROP CONSTRAINT FK_ChannelPlayerSkins_Channels but apparently, on some other databases we use, the constraint has a different name. How do I check if there's a constraint with the name FK_ChannelPlayerSkins_Channels.

  Read the article

• Need help with sql update query.

  - by via-point

  I have table 'products' and I need to update 'price' field by 20% if product 'type' field is "imported". How do I read and update field at the same time in my UPDATE query?

  Read the article

• Update XML as Upper Case in SQL Server

  - by monO

  I store an XML string in a column in my SQL Server database. I'm trying to run an UPDATE statement that will make a certain field into Upper Case. I can do that easily during a SELECT but can't get it to work with an update. This SELECT statement works select Upper(XmlTest.value('(/CodeFiveReport/Owner/@UnitNumber)[1]', 'varchar(10)')) as UnitNumber from uploadreport But I want to update it the XML as that permanently Update table Set XmlString.Modify('replace value of (/Root/Node/@Field)[1] with ?

  Read the article

• Convert tax like IRS function to SQL

  - by CrashRoX

  Trying to convert this tax-like IRS function http://stackoverflow.com/questions/1817920/calculating-revenue-share-at-different-tiers to SQL. The assumption is the table would be one column (price) and the tiers will be added dynamically. My first attempt has some case statements that didn't work out well. I have since scrapped it :) Thanks for the help!

  Read the article

< Previous Page | 673 674 675 676 677 678 679 680 681 682 683 684  | Next Page >