I'm looking for free implementation of pivot table view for Qt. Does someone know where to find such piece of code? Or maybe it's trivial to implement...
Which of the following three options would you choose for a column name in a SQL Server table, and why?
YearToDateWages
YTDWages
YtdWages
Follow up:
SSN
Ssn
SocialSecurityNumber
hi,
i am using php/mysql.
i have a product table .
in which most product have starting name with number.
i want to listout all products start with any number.
any one have idea about it....
Trying to get something similar for Firefox extension using XUL. The most difficult part is the grid with unequal number of rows.
I tried <grid> but it didn't work well. Also don't want to use HTML inside of XUL. Any ideas how to build such table?
how to set anything in database then he not allow duplicate rows in a table
means
name abc
name abc
means some row sames as each other then i need to take one copy of it and remove each other
A table row with two columns. One contain a image and another column contain a very large text. The text should start to the right of the image and if goes beyond the image size then the next line should come below the image.
IMAGE. Text starts here and then
follows like this
I have table and I want to swap the values from two rows. I have the rows IDs of the two rows.
Is there any query to do that? Here is an example. Before the query I have this:
row1 : 1,2,3
row2 : 5,6,7
After the swap I want this:
row1 : 5,6,7
row2 : 1,2,3
I don't want write it in .NET code because I think an SQL query is easier than that.
I am trying to get the value of a cell in a table view but it won't let me. If someone could help that would be great.
int numberOfChecks = -1;
numberOfChecks = numberOfChecks +1;
if ([objectsForTable count]-1 >= numberOfChecks) {
UITableViewCell *cell = [self.tableView cellForRowAtIndexPath:numberOfChecks];
NSString *cellTitle = cell.textLabel.text;
}
I'm trying to pass a table name into my mysql stored procedure to use this sproc to select off of different tables but it's not working...
this is what I"m trying:
CREATE PROCEDURE `usp_SelectFromTables`(
IN TableName varchar(100)
)
BEGIN
SELECT * FROM @TableName;
END
I've also tried it w/o the @ sign and that just tells me that TableName doesn't exist...which I know :)
What is an index in table? Related with realworld entitly like librabry.
what are the types of indexes? please related this too also with real world entity.
i am calling the data from xml in table view. after the the first row of data in tableview, my second row is empty in tableview, and from third row data is available. but my last data for row is missing from tableview, because of the second row.
how can i fill that second row.
i have a problem which is that i want to extract information about FAT(file allocation table) in C# but the restriction is i cannot use System.IO
so How i get drive types?cluster information e.t.c
I'm struggling getting my head around the Django's ORM. What I want to do is get a list of distinct values within a field on my table .... the equivalent of one of the following:
SELECT DISTINCT myfieldname FROM mytable
(or alternatively)
SELECT myfieldname FROM mytable GROUP BY myfieldname
I'd at least like to do it the Django way before resorting to raw sql.
Hi All,
I have a table called Employee with EmpID,Salary,Name fields.
I want to get top two employees with maximum salary.
How can i write this query ?
I want to confirm if the statement below is indeed true:
There is no way to specify a storage engine for a certain database, only for single tables, You can, however, specify a storage engine to be used during one session with:
SET storage_engine=InnoDB;
so you don't have to specify it for each table.
How do i confirm, if indeed all the tables are using InnoDB
All the tables were using myISAM.
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
My table looks like this with duplicates in col1
col1, col2, col3, col4
1, 1, 0, a
1, 2, 1, a
1, 3, 1, a
2, 4, 1, b
3, 5, 0, c
I want to select distinct col1 with max (col3) and min(col2);
so result set will be:
col1, col2, col3, col4
1, 2, 1, a
2, 4, 1, b
3, 5, 0, c
I have a solution but looking for best ideas?
I am having a hard time understanding how to change the width of columns when creating a table view.
I know you can set the width in pixels of a column but that is not what I want to do.
Say, for instance, I have 2 columns and want each column to take up half the screen. How do I do this without explicitly setting the pixels, so that my code can work on multiple screen sizes?
I am getting data from a query and processing it using Javascript in the xaction file.
Now I want to pass the processed data (a 2D array) down to a prpt where it will be used to generate graph and table.
What is the format in which Javascript would generate the data and how is it passed to and received by the prpt file from the xaction.
Thanks...
Hi All,
Is there some way to backup the data in a table in sql server by using sql scripts. Note: I dont want to take the backup of the whole database.
And later on restore the same data back in case of any failure.
Please suggest some solution.
I am developing an application which may be hosted on a microsoft sql server, or on Azure SQL, depending upon the end user's wishes.
My whole system works fine with the exception of some WCF functions which determine the last modification time of tables using the following technique:
SELECT OBJECT_NAME(OBJECT_ID) as tableName,
last_user_update as lastUpdate
FROM mydb.sys.dm_db_index_usage_stats
This query fails in Azure. Is there any analogous way to get table last modification dates from Azure's sql?
can any one explain hiow this query works..It's for getting the Nth largest elemet from a table.here it's 4 th largest
SELECT a.ID
FROM tblitem a
WHERE (4) = (select count(*)
from tblItem b
where b.id < a.id)
Thanks in advance
Hi,
I have two tables like of this structure
content (content_id, content_type, user_id, time, comment_count)
comments (comment_id, content_id, userid, comment, comment_time)
What I wold like to do is update the comments_count field with sum of comments i.e COUNT(content_id) from the comments table.
I am not able to figure out the right syntax
Thanks