Search Results

Search found 19256 results on 771 pages for 'css tables'.

Page 512/771 | < Previous Page | 508 509 510 511 512 513 514 515 516 517 518 519  | Next Page >

• Updating a sql server table with data from another table

  - by David G

  I have two basic SQL Server tables: Customer (ID [pk], AddressLine1, AddressLine2, AddressCity, AddressDistrict, AddressPostalCode) CustomerAddress(ID [pk], CustomerID [fk], Line1, Line2, City, District, PostalCode) CustomerAddress contains multiple addresses for the Customer record. For each Customer record I want to merge the most recent CustomerAddress record where most recent is determined by the highest CustomerAddress ID value. I've currently got the following: UPDATE Customer SET AddressLine1 = CustomerAddress.Line1, AddressPostalCode = CustomerAddress.PostalCode FROM Customer, CustomerAddress WHERE Customer.ID = CustomerAddress.CustomerID which works but how can I ensure that the most recent (highest ID) CustomerAddress record is selected to update the Customer table?

  Read the article

• Where can I get SQL for default Oracle's "HR" schema?

  - by Dmitry

  I'm studying Oracle database and have to do some exercises with default "HR" schema. But I think that data in my tables is changed from default values (many students have access to DB and may be someone changed data). Where can I get SQL to construct default "HR" schema?

  Read the article

• regular expressions for class name

  - by user576701

  i need a regular expressions string to get all anchor tags in a page with a specific css class name, in c#/vb.net this is what i got so far "<a.*?href=""(.*?)"".*?>(.*?)</a>" but my attempts to add "class=name" isnt working, also is it possible to find links where the class name appears either before or after the href with one expression ? i am familiar with 3rd party html libraries, but thats an overkill for what i have in mind, so is the webbrowser control.

  Read the article

• Oracle: How to update master with newest row from detail table?

  - by LukLed

  We have two tables: Vehicle: Id, RegistrationNumber, LastAllocationUserName, LastAllocationDate, LastAllocationId Allocations: Id, VehicleId, UserName, Date What is the most efficient (easiest) way to update every row in Vehicle table with newest allocation? In SQL Server I would use UPDATE FROM and join every Vehicle with newest Allocation. Oracle doesn't have UPDATE FROM. How do you do it in Oracle?

  Read the article

• remove the extra column that comes datagrid

  - by prince23

  hi, how to remove the extra column that comes default in datagrid silverlight 4.0 is there any good links to designing(css) data grid in silverlight 4.0 thanks in advance. prince

  Read the article

• What is the difference between JOIN, Inner Join, Left Join and Outer Join.

  - by theband

  What is the difference between JOIN, Inner Join, Left Join and Outer Join. Let me put you on what i know. JOIN Statement is used to join two tables and fetch the result.

  Read the article

• MATLAB: comparing 2 columns content

  - by Patrick

  hi, I need to compare the content of 2 tables, more exactly 2 columns (1 column per table) in Matlab to see, for each element of the firsts column, there is an equal element in the second column. Should I use a for loop or is there any MATLAB function doing this ? thanks

  Read the article

• How does a database handle auto-number field if it's limit is reached?

  - by Nitesh Panchal

  Hello, In my tables, i have selected id column to be of type int (4 bytes). The answer i want to know is how will any database handle it once it's limits are reached? Will the database refuse to insert any more records in table? or what exactly will happen? Also how should i tackle this type of problem (if the database doesn't handle it by itself)?

  Read the article

• Need Help Writing SQL query

  - by user204588

  I have two product tables Product1 and Product2. There is a one 2 one mapping on the field ProductId. What I want is to get all the product ids where the Product2.Exported field is false AND Where the product ids that are in Product1 but not in Product2 table. Right now I have two queries that I'm trying to mash into one. SELECT ProductId FROM Product1 WHERE ProductId NOT IN(Select ProductId From Product2) SELECT ProductId FROM Product2 WHERE Exported = 0

  Read the article

• Does the majority A-grade browsers cache content over https to disk?

  - by nimo9367

  I have read somewhere that javascript and css files that only get cached in memory sooner or later get pushed out by other content. Is this true? Are there any other issues regarding cashing SSL-objects?

  Read the article

• SQL Join Everything From One Table With One Feild From Another Table?

  - by painperdu

  Is there a way to specify a join on all fields from table A with only one field from table B? Is it necessary to specify each individual field from each table instead of using the all symbol (*) for one of the tables?

  Read the article

• exclude the folders - url rewrite in htaccess

  - by aquagirl

  rewriteCond %{REQUEST_URI} ^(ajax|css|functions|image_viewer|images|img|include|fancybox|jquery|jscript|json)$ - [L] RewriteRule ^(.[^/])/(.[^/])/(.+[^/]) ?program=$1&usertype=$2&username=$3 [NC] could you please help me find what is wrong in this.. ? I need to exclude some folders from url rewriting. i tried with the solution given here.. but still i am getting some errors.. http://www.idxsync.com/sbaor/Search/Agent/zz please help me

  Read the article

• Content Graphic Was Pushed Down - Need Help...

  - by Tran

  Hello everyone, I modified html codes generated by Firework, and now graphic was pused down I dont know how to fix it. Sorry Im still using tables, mixing up with css to create the list items....please help....What I did was extend the original graphic to make it taller to fit the list menu http://imageoneads.com/work/inventory.htm Thanks ahead

  Read the article

• mysql join table - selecting the newest row

  - by cmancre

  Hi, I have the following two MySQL tables TABLE NAMES NAME_ID NAME 1 name1 2 name2 3 name3 TABLE STATUS STATUS_ID NAME_ID TIMESTAMP 1 1 2010-12-20 12:00 2 2 2010-12-20 10:00 3 3 2010-12-20 10:30 4 3 2010-12-20 14:00 I would like to select all info from table NAMES and add most recent correspondent TIMESTAMP column from table STATUS RESULT NAME_ID NAME TIMESTAMP 1 name1 2010-12-20 12:00 2 name2 2010-12-20 10:00 3 name3 2010-12-20 14:00 Am stuck on this one. How do I left join only on the newer timestamp?

  Read the article

• How not to display columns which are NULL in a view

  - by Michelle

  I've set up a view which combines all the data across several tables. Is there a way to write this so that only columns which contain non-null data are displayed, and those columns which contain all NULL values are not included?

  Read the article

• 100k+ Records and sp_xml_preparedocument

  - by Jonn

  I've been encountering a seeming deadlock with one of my tables and the only place I can trace it back to is a stored procedure that uses sp_xml_preparedocument on a list of data. The data inserted, btw, consists of a 100k+ records on average. Is it possible that it is causing the deadlock? What other pitfalls does using sp_xml_preparedocument have?

  Read the article

• How to count each record in each table in a SQL Server 2005 Database?

  - by Heather

  I need to know how many records are in each table in a particular database. I don't care what is in the record, they will all need to be counted. I already know how to do this for a single table as SELECT Count(1) FROM [my_table_name], but this gets a little redundant for 200+ tables.

  Read the article

• Good book for sql

  - by Uday

  I always considered database as a storage . but never thought it can be used for querying across tables etc. Which is a good book for sql for a developer. not just the syntax. How to write a query in different ways How internally queries are executed.etc especially related to microsoft sql server

  Read the article

• Question about Benchmark function in Mysql ( Incredible results ).

  - by xRobot

  I have 2 tables: author with 3 millions of rows. book with 20 miles rows. . So I have benchmarked this query with a join: SELECT BENCHMARK(100000000, 'SELECT book.title, author.name FROM `book` , `author` WHERE book.id = author.book_id ') And this is the result: Query took 0.7438 sec ONLY 0.7438 seconds for 100 millions of query with a join ??? Do I make some mistakes or this is the right result ?

  Read the article

• how to join with group by statement

  - by Surya logantahababu

  Im having two tables TableA Custid prodid Amt1 1 10 200 2 20 300 3 10 400 4 30 300 5 20 400 6 30 200 TableB prodid Amt2 10 100 20 200 30 300 and i want sum of all amount group by prodid. can any one give me both ansi and Tsql quries.

  Read the article

• Htaccess help, $1 being used before its set??? what?

  - by jiexi

  I have this snippet RewriteEngine on RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteCond $1 !^(index\.php|images|img|css|js|robots\.txt) RewriteRule (.*) index.php?/$1 [L] It won't allow me to access a file at website.com/js/main.php but it will let me access index.php According to my webhost, $1 is being called before it is set. Any solutions? I'll accept answers when i get back tomorrow. Thank you!

  Read the article

• Help with query in Microsoft Access

  - by Gold

  I have 2 tables: Table A: code | name Table B: barcode | name Table B has full barcode and name, Table A has only code. I need to run update query that fill name in Table A. I tried something like: update A set name = (select top 1 Name from B where B.Code = mid(A.Barcode,1,8)) but it doesn't work.

  Read the article

• SilverLight: game programming for kids

  - by dotnet-practitioner

  Hi, Is it possible for kids with only HTML/CSS programming experience to do game programming in SilverLight 4.0? They are using Visual Web Developer 2010 Express edition. Do they have to learn c# or any other language since they are just starting out? Thanks

  Read the article

• Answered: Selecting even table rows from a table element

  - by mvrak

  The issue I am having is: How do I go from a variable pointing at an element to using CSS selectors? I want to make this work: function highlight(table) {$(table " > :even").toggleClass('highlight');} where table is a reference to a table element. I don't want answers that tell me to use $('#table') because that defeats the point of the generality I am trying to make. Thanks

  Read the article

• Create a trigger that updates a column on one table when a column in another table is updated

  - by GigaPr

  Hi, i have two tables Order(id, date, note) and Delivery(Id, Note, Date) I want to create a trigger that updates the date in Delivery when the date is updated in Order. I was thinking to do something like CREATE OR REPLACE TRIGGER your_trigger_name BEFORE UPDATE ON Order DECLARE BEGIN UPDATE Delivery set date = ??? where id = ??? END; How do I get the date and row id? thanks

  Read the article

< Previous Page | 508 509 510 511 512 513 514 515 516 517 518 519  | Next Page >