Search Results

Search found 10424 results on 417 pages for 'persisted column'.

Page 249/417 | < Previous Page | 245 246 247 248 249 250 251 252 253 254 255 256  | Next Page >

• True or False: Good design calls for every table to have a primary key, if nothing else, a running i

  - by Velika

  Consider a grocery store scenario (I'm making this up) where you have FACT records that represent a sale transaction, where the columns of the Fact table include SaleItemFact Table ------------------ CustomerID ProductID Price DistributorID DateOfSale Etc Etc Etc Even if there are duplicates in the table when you consider ALL the keys, I would contend that a surrogate running numeric key (i.e. identity column) should be made up, e.g., TransactionNumber of type Integer. I can see someone arguing that a Fact table might not have a unique key (though I'd invent one and waste the 4 bytes, but how about a dimension table?

  Read the article

• Developing iPhone Application, How do i get video "length" from a video saved to my app docs folder?

  - by mrburns05

  Basically i record / import video , it saves to the docs folder and im trying to figure out how to get the length (time) so i can display it for each individual video.. I have a column in the database for it and the neccessary code to display it, just not sure how to get it.. Any help is greatly appreciated

  Read the article

• first Occurrence Of Non Blank Cell vba

  - by Madhu Kiran

  Hi, I am trying to write VBA code which works on my Excel sheet. Range("A65536").End(xlUp).Row gives me the row number of the last non blank cell. similarly i am trying to get the row number of the first non blank cell in that particular column. Thanks in advance. madhu

  Read the article

• How do I write this Django model in SQL?

  - by alex

  I want to create a new column. How do I write this in SQL? class mytable(models.Model): created_at = models.DateTimeField(auto_now_add=True)

  Read the article

• Extended properties with Entity Framework or NHibernate

  - by Artem Tikhomirov

  Hello, everyone! Is there are an easy way to store some of entitie's properties in a column as a bulk, as XML or something? Querieng by those properties of course is not an option, but it still'd be valuble to be able to extend data model without database migration.

  Read the article

• jQuery resize width on firefox

  - by LM35DT

  I'm doing some experiments with jquery n widths for a liquid column and I'm not sure why it isn't working on firefox. It works fine on IE6,7,8 Chrome, Opera(sluggish). I found some articles about firefox not recognizing the .resize attribute but no explanation/solution =\ $(document).ready(function(){ $(midCol).width((window,$(window).width()) - 470) $(window).resize(function(){$(midCol).width((window,$(window).width()) - 470) }) });

  Read the article

• Does SQL Server CheckSum calculate a CRC? If not how can I get MS SQL to calculate a CRC on an arbit

  - by Brian R. Bondy

  Does SQL Server CheckSum calculate a CRC? If not how can I get SQL Server to calculate a CRC on an arbitrary varchar column?

  Read the article

• How do I write a Oracle SQl query for this tricky question...

  - by atrueguy

  Here is the table data with the column name as Ships. +--------------+ Ships | +--------------+ Duke of north | ---------------+ Prince of Wales| ---------------+ Baltic | ---------------+ In the Outcomes table, transform names of the ships containing more than one space, as follows: Replace all characters between the first and the last spaces (excluding these spaces) by symbols of an asterisk (*). The number of asterisks must be equal to number

  Read the article

• Using combo boxes with a binding source and multiple tables

  - by Scott Chamberlain

  I have two data tables in a data set for example lets say Servers: | Server | Ip | Users: | Username | Password | ServerToConnectTo | and there is a foreign key on users that points to servers. How do I make a combo box that list all of the servers. Then how do I make the selected server in that combo box be saved in the data set in the ServerToConnect to column.

  Read the article

• C# Calculate items in List<int> values vertically

  - by Deepu

  Hi Experts, I have a list of int values some thing like below (upper bound and lower bounds are dynamic) 1, 2, 3 4, 6, 0 5, 7, 1 I want to calculate the column values in vertical wise like 1 + 4 + 5 = 10 2 + 6 + 7 = 15 3 + 0 + 1 = 4 Expected Result = 10,15,4 Any help would be appreciated Thanks Deepu

  Read the article

• MySQL More Tables or More Rows

  - by Pez Cuckow

  I am working on a game that I am going to open to the public to have on their game. The game stores lots of information (about 300 rows) per website and spends a lot of time updating values within this MySQL database. Is it better (faster/efficient) to add a new table for every website or to just have 1000's of rows in one table and add a column "website_id" or similar?

  Read the article

• Rails 3: How to validate that A < B where A and B are both model attributes ?

  - by Misha Moroshko

  I would like to validate that customer_price >= my_price. I tried the following: class Product < ActiveRecord::Base attr_accessor :my_price validates_numericality_of :customer_price, :greater_than_or_equal_to => my_price ... end (customer_price is a column in the Products table in the database, while my_price isn't.) Here is the result: NameError in ProductsController#index undefined local variable or method `my_price' for #<Class:0x313b648> What is the right way to do this in Rails 3 ?

  Read the article

• MySQL: count enumerated values?

  - by John Isaacks

  If my table looks like this: daily_individual_tracking', 'CREATE TABLE `daily_individual_tracking` ( `daily_individual_tracking_id` int(10) unsigned NOT NULL auto_increment, `daily_individual_tracking_date` date NOT NULL default ''0000-00-00'', `sales` enum(''no'',''yes'') NOT NULL COMMENT ''no'', `repairs` enum(''no'',''yes'') NOT NULL COMMENT ''no'', `shipping` enum(''no'',''yes'') NOT NULL COMMENT ''no'', PRIMARY KEY (`daily_individual_tracking_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 basically the fields can be either yes or no. How can I count how many yes's their are for each column over a date range? Thanks!!

  Read the article

• How to solve - Illegal mix of collations in mysql?

  - by rocksolid

  Am getting the below error when trying to do a select through a Stored procedure in mysql. Illegal mix of collations (latin1_general_cs,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '=' Any idea on what might be going wrong here? The collation of the table is latin1_general_ci and that of the column in the where clause is latin1_general_cs Thanks!

  Read the article

• How to count how many items for distinct items in mysql?

  - by Vincent Duprez

  Imagine a have a table with a column named status: status ------ A A A B C C D D D How can I count how many rows have A, how many rows have B etc? this kind of output: A |B |C |D |E ------------------ 3 |1 |2 |3 |0 As for E = O , this will always be A,B,C,D and E Output should be one row (thus 1 query). When doing a distinct count (most returning answer on my searches, it does return how many different elements there are, 4 in this case...)

  Read the article

• How to split records per hour in order to display them as a chart?

  - by Axel

  Hi, I have an SQL table like this : sales(product,timestamp) I want to display a chart using Open Flash Chart but i don't know how to get the total sales per hour within the last 12 hours. ( the timestamp column is the sale date ) By example i will end up with an array like this : array(12,5,8,6,10,35,7,23,4,5,2,16) every number is the total sales in each hour. Note: i want to use php or only mysql for this. Thanks

  Read the article

• Save Field Names in Microsoft SQL Query Analyzer

  - by Michael Shnitzer

  When you save the results of a SQL query using "Microsoft SQL Query Analyzer" (version 8), the results of the query are saved but the column headers (field names) are not. Any idea how to save the field names to the results file as well?

  Read the article

• How Can i Populate Bulk of Data from a DB Table into a Combo Box? - C#.NET

  - by peace

  MenuItem menus = new MenuItem(); GridView1.DataSource = menus.GetDataTable(); GridView1.DataBind(); menus.GetDataTable() returns a DataTable. In the above case, we are returning to GridView. I need to populate the data into a combo box. How can i do it? NOTE: Assume GetDataTable only returns records of a single column.

  Read the article

• What method can I override in GridViewHeaderRowPresenter to prevent it from drawing some columns?

  - by Carlo

  The thing is that I created a custom column that inherits from GridViewColumn, and I added a Visibility dependency property to it. Now I want to create a custom GridViewHeaderRowPresenter, that does not draw the columns when their visibility is hidden or collapsed, but other than the OnRender() method, I can't think of anything else. Thanks. Btw, the reason I'm doing this is because removing or adding columns doesn't work like we would expect it (some specs for our app) and I believe what I'm trying to do here would work if pulled out correctly.

  Read the article

• What's an efficient way to convert month and year string to a date?

  - by adam0101

  I have column with varchar values like "022008" that I need to convert into a datetime like "02/01/2008". This will run on millions of records for a conversion process. What is an efficient select statement for doing this?

  Read the article

• Load a .bin file in SQL server 2005 Express database in vc++ application

  - by Feroz Khan

  I would like to put a binary file in varbinary(MAX) column using _RecordsetPtr in a vc++ application.I am sure that lot of people have done this before. But I am new to database programming. Help is urgently needed ...Thanks in advance.

  Read the article

• How can I make a list in a Repeater Section?

  - by JPJedi

  I need to create a repeater section that will show 4 columns - First Name, Last Name, a link based off of stored column data that says. All the data plus some extra not being used is in a players profile. How do I link the data on the code-behind to the repeater control with the databinders? I am using visual studio 2008, VB.NET for the code behind.

  Read the article

• How to use split in SQL Server 2005?

  - by meenakshi

  Table column has values with comma separated for ex: (1,2,3) How to split this like 1 2 3 or 1 2 3 in SQL Server 2005.

  Read the article

• Is there any query in sqlite to choose a substring ?

  - by john terry

  Hey, Lets say I have a table Y with column X. There is one row of "X" with the string "abcdefg", and another row with "qwerty". Can I make a SELECT query in sqlite to choose the row which contains the substring "abcd" ? Thanks in advance.

  Read the article

• SQL - First row inserted every day for the past X days

  - by okie.floyd

  A tough SQL question (I'm using postgres by the way). I need the first row inserted every day for the past X days. one of my columns is a timestamp, which i hold the time inserted, and another column is the row id. If it's not possible to get the first row inserted every day, i at least need a unique one; a single row for every day for the past x days. Any suggestions? Thanks okie

  Read the article

< Previous Page | 245 246 247 248 249 250 251 252 253 254 255 256  | Next Page >