Search Results

Search found 25013 results on 1001 pages for 'transitive closure table'.

Page 90/1001 | < Previous Page | 86 87 88 89 90 91 92 93 94 95 96 97  | Next Page >

• How can I alter a temp table?

  - by William

  I need to create a temp table, than add a new int NOT NULL AUTO_INCREMENT field to it so I can use the new field as a row number. Whats wrong with my query? SELECT post, newid FROM ((SELECT post`test_posts`) temp ALTER TABLE temp ADD COLUMN newid int NOT NULL AUTO_INCREMENT)

  Read the article

• Is derived table executed once or three times?

  - by AspOnMyNet

  Every time you make use of a derived table, that query is going to be executed. When using a CTE, that result set is pulled back once and only once within a single query. Does the quote suggest that the following query will cause derived table to be executed three times ( once for each aggregate function’s call ): SELECT AVG(OrdersPlaced),MAX(OrdersPlaced),MIN(OrdersPlaced) FROM ( SELECT v.VendorID, v.[Name] AS VendorName, COUNT(*) AS OrdersPlaced FROM Purchasing.PurchaseOrderHeader AS poh INNER JOIN Purchasing.Vendor AS v ON poh.VendorID = v.VendorID GROUP BY v.VendorID, v.[Name] ) AS x thanx

  Read the article

• jQuery - count number of rows in a table

  - by danjan

  How do I count the number of tr elements within a table using jquery. Sorry, I sense this might be basic but i've been banging my head against it. I know there is a similar thread, but I just want the total rows. http://stackoverflow.com/questions/613024/count-number-of-table-rows-between-two-specific-rows-with-jquery

  Read the article

• to take values of checkbox in table attributes

  - by mwj

  i have a database patient with 3-4 tables n each table has about 8 attributes.... i have a table medical history which has attribute additional info ... under which i have 5 checkboxes.... all the values entered are taken up except the chekbox values..... plz help

  Read the article

• MYSQL DELETE from a table [closed]

  - by Hossein

  Possible Duplicate: MySQL DELETE in a single table Hi, I have this table: userurltag(id,user,Url,tag) I want to remove rows that contain urls that are used by only one user, can someone help me? It seems that DELETE...(SELECT...) is not supported in Mysql.

  Read the article

• How to transfer data to the target table from multiple sources without using Joiner Transformation i

  - by Velava

  I have two sources (source A and Source B), source B is an another one target table in my db. both are in diff user id . Now i have to transfer some data,s from these two sources to target table. Can i transfer data without using the joiner transfermation? how to do ?

  Read the article

• In @Table(name = "tableName") - make "tableName" a variable in JPA

  - by zengr

  I am using JPA and I need to make the "tableName" a variable. In a database, I have many tables, and my code needs to access the table where I specify it to read. @Entity @Table(name = "tableName") public class Database implements Serializable {...............} Any ideas?

  Read the article

• Write physical table to csv file

  - by urema

  Hi, I was wondering if anyone knows how to write an actual table/grid to a csv file....i dont mean the content of the table/grid, i mean the actual grid lines etc etc, headers, axis..... Thanks greatly in advance. U.

  Read the article

• Rewrite SQL Fulltext Function to return Table only

  - by Alex

  I have a MS SQL Fulltext Function like this: (...) RETURNS TABLE AS RETURN SELECT * FROM fishes INNER JOIN CONTAINSTABLE(fishes, *, @keywords, @limit) AS KEY_TBL ON fishes.id = KEY_TBL.[KEY] When I use this function in LINQ, it generates a special return type which includes all fields of my "fishes" table, plus Key and Rank. How could I rewrite above query, or change something in LINQ, to omit Key and Rank and just return my "fishes" results (and to have the fulltext search result objects be of type Fish, which is what I really care about, so I don't have to cast)?

  Read the article

• update myqsl table

  - by Simon

  how can i write the query, to update the table videos, and set the value of field name to 'something' where the average is max(), or UPDATE the table, where average has the second value by size!!! i think the query must look like this!!! UPDATE videos SET name = 'something' WHERE average IN (SELECT `average` FROM `videos` ORDER BY `average` DESC LIMIT 1) but it doesn't work!!!

  Read the article

• SQL Server 2008 Reporting Services Charting - adding a data table to bottom of a chart

  - by Christopherous 5000

  I would like to add a data table to bottom of a (line) chart in a report. I know I can create a matrix report with the same data source. I would like to have everything lineup automatically like it does when you add a data table to a chart in Excel (as shown at http://www.tushar-mehta.com/excel/newsgroups/data_table/). Example from Excel (from above link) Any ideas?

  Read the article

• Disable table in javascript

  - by Muhammad Akhtar

  Hi, I have many controls in table and I want to disable all the controls using JavaScript upon clicking of some checkbox. I have google and found that we can't disable table instead all controls through loop. Please suggest me, what is better idea Thanks

  Read the article

• How to quote and reference MS SQL table and field names

  - by artvolk

  Good day! Despite the fact LINQ2SQL and ADO.NET Entity Framework exists there were situations when I need to revert to plain old DataSet (not typed) and friends. While writing SQL for SqlCommand: Is it needed to quote field and table names with []? Is it good to prefix table names with [dbo] I use to use this syntax: SqlCommand command = new SqlCommand("SELECT [Field1], [Field2] FROM [dbo].[TableName]", connection); May be there is a better way? Thanks in advance!

  Read the article

• SQL Comments on Create Table on SQL Server 2008

  - by user494901

  I need to create some pretty big tables in SQL server 2008, while I do have SQL Server Manager Studio, I would like to comment the tables and the columns when I create the table. How do I do this? Example of the query I am running: CREATE TABLE cert_Certifications ( certificationID int PRIMARY KEY IDENTITY, profileID int, cprAdultExp datetime null ) I've tried COMMENT'Expiration Date for the Adult CPR' and COMMENT='Expiration Date for the Adult CPR' after the data type, and SQL server is giving me an error.

  Read the article

• how to copy a sqlite3 table to another file in python

  - by james

  hey i was wondering how i could make a copy of a sqlite3 table and save it to a seperate file in python. im confused as in python your sqlite3 object can only be connected to one database so how would i make it save to a seperate database? the reason i want to do this is in sqlite3 the database file size can never get smaller, and ive made alot of changes so i want just copy this table to another file which wont have all the extra empty space and then delete the origonal database thanks guys

  Read the article

• Google App Engine datastore-Table creation

  - by megala

  I have one doubt regarding table creation in google app engine datasore using jpa.my consatraints is ,Is it possible to create a table without using primary key.(i.e) without using @Id annotations. Thanks in advance

  Read the article

• Select column value that matches a combination of other columns values on the same table

  - by Ala

  I have a table called Ads and another Table called AdDetails to store the details of each Ad in a Property / Value style, Here is a simplified example with dummy code: [AdDetailID], [AdID], [PropertyName], [PropertyValue] 2 28 Color Red 3 28 Speed 100 4 27 Color Red 5 28 Fuel Petrol 6 27 Speed 70 How to select Ads that matches many combinations of PropertyName and PropertyValue, for example : where PropertyName='Color' and PropertyValue='Red' And where PropertyName='Speed' and CAST(PropertyValue AS INT) > 60

  Read the article

• iPhone empty table message (eg like "No contacts" in simulator, or "No results" in search )

  - by jesse001

  Is there a right way to add empty table text? For example, if you go to the simulator and open contacts, the table is empty and displays "No Contacts". Or searching that gives "no results". I could do this via a label positioned and hidden at run time, but is the correct approach? Thanks for your help

  Read the article

• CSS - center an oversized div inside a table cell which is too small

  - by domspurling

  I want to display a DIV inside a table cell which is too narrow for it. I'm using overflow:hidden to allow the div to spill out one side of the table cell but now I want to center it so that it spills out a wee bit on both sides insdead of alot on one side. How do I horizontally center a DIV inside a TD which is too narrow for the DIV?

  Read the article

• How to change the number of columns in a table dynamically but still keep the table layout intact?

  - by gurupriyan.e

  I have a 'n' column table , the first column is a drop down box , on selecting the options from the drop down, the other columns change. For eg: first drop down might need to display a text box and a button , the second drop down 3 text boxes and a button and so on. There is only one row in the table. What is the best solution to achieve this. with Sincere thanks,

  Read the article

• Can I get a table name from a join select resultset metadata

  - by Matt

  Below is my code trying to retrieve table name form Resultset ResultSet rs = stmt.executeQuery("select * from product"); ResultSetMetaData meta = rs.getMetaData(); int count = meta.getColumnCount(); for (int i=0; i<count; i++) { System.out.println(meta.getTableName(i)); } But it returns empty, no mention it is a join select resultset. Is there any other approaches to retrieve table name from reusltset metadata?

  Read the article

• how to Invoke User-Defined Functions That Return a Table Data Type

  - by nectar

  here my code- create function dbo.emptable() returns Table as return (select id, name, salary from employee) go select dbo.emptable() error: Msg 4121, Level 16, State 1, Line 1 Cannot find either column "dbo" or the user-defined function or aggregate "dbo.emptable", or the name is ambiguous. while when I run sp_helptext emptable it shows- create function dbo.emptable() returns Table as return (select id, name, salary from employee) it means function exists in database then why it is giving such error?

  Read the article

• How can I make my table cell UITextField editable when the table has entered 'edit' mode?

  - by Lee Probert

  I have a simple table view which is editable. All I need the user to be able to do is edit the text field in the cell when they choose to edit the table.

  Read the article

• How to rename a table in the sql server compact edition

  - by Nila

  Hi. I'm new to SQL Server Compact edition. I'm using Compact edition 3.5. I tried renaming the table. But, I couldn't do that through the following query. alter table tablename to newname Plz, someone help me.........

  Read the article

• Micosoft SQL Server 2005 check if temporary table empty

  - by Kevin

  Is there a fast/efficiency way to check if a table is empty? DECLARE @StartEndTimes TABLE ( id bigint, StartTime datetime, EndTime datetime ) IF @StartEndTimes IS NOT NULL

  Read the article

< Previous Page | 86 87 88 89 90 91 92 93 94 95 96 97  | Next Page >