Search Results

Search found 10101 results on 405 pages for 'temporary tables'.

Page 225/405 | < Previous Page | 221 222 223 224 225 226 227 228 229 230 231 232  | Next Page >

• Erro while join table in SQL

  - by Color Shadow

  I have two tables that have relationship with UserName field. Based on UserName column, I want to get ID from CarReserve table. Here is my SQL statement: SELECT CarReserve.ID FROM CarReserve INNER JOIN aspnet_Users ON CarReserve.UserName = aspnet_Users.UserName WHERE UserName = @UserName Unfortunately, I am getting this warning: Ambiguous column name "UserName" Can anyone here tell me what is wrong with my statement?

  Read the article

• Expand my knowledge in DB programming

  - by talgleichger

  Hi there, my name is Tal, Im working on a PHP Application the should have lots and lots of records, what DB should I use, and are there guides on the web that explains how to build efficient dbs and tables? Tnx!

  Read the article

• I need to programmatically remove a batch of unique constraints that I don't know the names of.

  - by Bill

  I maintain a product that is installed at multiple locations which as been haphazardly upgraded. Unique constraints were added to a number of tables, but I have no idea what the names are at any particular instance. What I do know is the table/columnname pair that has the unique constraints and I would like to write a script to delete any unique constraint on these column/table combinations. This is MSSQL 2000 and later. Something that works on 2000/2005/2008 would be best!

  Read the article

• dealing with a large flat data files with a very big record length

  - by gsp

  I have a large data file that is creatd from a shell script. Next script processes it by sorting and reading several times, that takes more than 14 hours, it is not viable. I want to replace this long running script with a program, probably in JAVA, C, or COBOl, that can run on windows or on sun solaris. I have to read a group of records everytime, sort and process and write to the output sort file and at the same time insert into db2/sql tables.

  Read the article

• Where should I declare a list of 5,000+ words?

  - by user647362

  I am writing a game in python in which I must periodically pull a random word from a list of words. When I prototyped my game I declared a word_list = ['cat','dog','rat','house'] of ten words at the top of one of my modules. I then use choice(word_list) to get a random word. However, I must must change this temporary hack into something more elegant because I need to increase the size of the word list to 5,000+ words. If I do this in my current module it will look ridiculous. Should I put all of these words in a flat txt file, and then read from that file as I need words? If so, how would I best do that? Put each word an a separate line and then read one random line? I'm not sure what the most efficient way is.

  Read the article

• Concatenate multi value into one record.

  - by mikehjun

  I joined two tables together and what I like to do is concatenate multi vaule in one records without duplicated value. TAXLOT_ZONE TID ZONE 1 A 1 A 1 B 1 C 2 D 2 D 2 E 3 A 3 B 4 C 5 D Desirable Final table looks like; TID ZONE 1 A, B, C 2 D, E 3 A, B 4 C 5 D

  Read the article

• Convert TD columns into TR rows

  - by TM

  Hi, Is there a quick way to translate (using CSS or Javascript) a tables TD into TR, currently I have: A B C D 1 2 3 4 and I want to translate to: A 1 B 2 C 3 D 4 ??

  Read the article

• Model association changes in production environment, specifically converting a model to polymorphic?

  - by dustmoo

  Hi everyone, I was hoping I could get feedback on major changes to how a model works in an app that is in production already. In my case I have a model Record, that has_many PhoneNumbers. Currently it is a typical has_many belongs_to association with a record having many PhoneNumbers. Of course, I now have a feature of adding temporary, user generated records and these records will have PhoneNumbers too. I 'could' just add the user_record_id to the PhoneNumber model, but wouldn't it be better for this to be a polymorphic association? And if so, if you change how a model associates, how in the heck would I update the production database without breaking everything? .< Anyway, just looking for best practices in a situation like this. Thanks!

  Read the article

• Many to many in linq with vb.net

  - by user512623

  I have 3 tables in a database: image of the database I have been looking online for a long time trying to find out how in linq and vb.net how i can do a query that has access to both the event and individual table for example showing all the events individual 1 is taking part in ect. i was wondering if anyone could point me in the right direction or know of any good tutorial sites with good examples of things similar. Thanks in advance :) Luke.

  Read the article

• Database with great read performance

  - by mscava

  I have 10 tables from which 4 contain each up to million rows. All values are inserted at once, and afterwards I only read the data many times. I am searching for a database that would perform greatly when it comes to selecting, joining or other reading etc. What is the most recommended option?

  Read the article

• dbo in SqlServer

  - by ala

  I'm converting database from Teradata to SqlServer. I've noticed all tables and procedures are named by the prefix "dbo." (e.g. "dbo.Table1"). I would like to know if and how I can get rid of "dbo" because it would make the conversion task a lot more easier.

  Read the article

• How to retrieve items from a database c#

  - by Poppy

  I have 3 tables "pics", "shows", "showpics" I want to be able to edit the table "shows". In order to do this i need to retrive the pictures that the show contains (the pictures are stored in the table "pics") the "showpics" table acts as a link does anyone have any ideas as im completely lost and have no idea where to even start Thanks

  Read the article

• How to generate report

  - by user692495

  I have problem in generate report. I use crystal report 8.5 with vb.net 2008,what I want is when I generate report it will appear red value, if the value is more or less than actual value else it will give default value but when I put this code it give me wrong result If {Intake.wheatType} = {Spec.WheatType} AND {Intake.HB43} >={Spec.M_Min} AND{Intake.HB43} >={Spec.M_Max} Then Red Else DefaultAttribute this report is related with two tables, which is table Spec and table Intake. Could anyone help/teach me how to fix this problem

  Read the article

• Simple Java web application on Tomcat

  - by EugeneP

  If we only need to graphically authorize a user, view a few tables representation (from database), ability to change data in the database visually what tools to use to write such a web application that will run on Tomcat? What framework allows to do that in the most straightforward, easy-to-manage and elegant way?

  Read the article

• How to make dll referenced by ActiveX component accessible?

  - by sherpa

  I have an ActiveX component developed in C#. I'm referencing a dll which comes with other native dlls and it is loading them on the fly expecting them to be in the same folder (probably using Assembly.GetExecutingAssembly().Location but not sure, I don't have control over them). There is also one ini file which is also expected to be in the same folder. When I run the application as Windows form app, everything is fine, of course. But the trouble comes when I run it within Internet Explorer as the base directory is at the location of iexplore.exe. Obviously neither the dlls or the ini file can be found and many temporary working files outputted by the dlls are located in Internet Explorer folder. The workaround is to copy all ddls and ini file into the ie folder but that is not something I'd be happy about. What is the proper solution to this? Can I somehow set the base path for the ActiveX component?

  Read the article

• Setting MySQL column names

  - by Richard Mar.

  Say I have these tables: people(id, name), cars(person_id, car) and this query: SELECT c.car FROM people as p, cars as c WHERE c.person_id = p.id AND p.id = 3 I want the c.car column to take its name from the name field in the people table, like this (invalid SQL, just to illustrate): SELECT c.car AS(SELECT name FROM people WHERE id = 3) How do I do that?

  Read the article

• SQL CE Compact 3.5 Identity columns for a table.

  - by rxm0203

  Is there a query I can write against an INFORMATION_SCHEMA or against the system tables to determine if a column is an identity column in SQL CE version 3.5?

  Read the article

• Generating SQL script from MySQL database table

  - by testingmysql

  Hi, Is there any application that will read a MySQL database table and generate a SQL script of INSERT statements (so that I can copy tables from one db to another db)? OR how can I transfer content from db1.table1 to db2.table2 where table1 and table2 is same. Thank you.

  Read the article

• Help with sql query

  - by user225269

  I have two tables: subject and student. I'm trying to count the number of subjects enrolled by each student. How do I do that?I'm trying the code below but it doesn't give the answer I need. Please help. SELECT COUNT( subject.SUBJECT ) , student.IDNO, student.FIRSTNAME, subject.SUBJECT FROM student, subject GROUP BY subject.SUBJECT LIMIT 0 , 30

  Read the article

• Edit table error in SQL server 2008

  - by Johanna

  Hi I use SQL server 2008 and I have created some tables but I want to edit some of them but it does not let me and will show an error ! how can i solve my problem ??? please help me

  Read the article

• Copy data from a table to another one has different structure

  - by Kernel

  I have two tables with different structure: TableSource: intId(not null), txtSummary, strDetail TableDesc: guidId(not null), guidFK(not null), Name, Detail I want to migrate data from two fields of tableSource(txtSummary, strDetail) to two fields of tableDesc(Name, Detail). For simply,suppose that guidId and guidFK are auto generation. I'v tried but not success. Could anyone help me?

  Read the article

• MVC architecture EJB funcionallity

  - by Ignacio

  HI would like to understand how do ejbs work in an MVC architecture, what i do not get is: When the web app starts, the system creates an ejb for each record in every table of db or an ejb with all the records of all tables? Thank you very much

  Read the article

• How can I select the required records?

  - by simple

  Tables: Product: [id, name, brand_id, is_published] Brand: [id, name, is_published] Awards: [id, name] ProductAwards [product_id, award_id] How do I select the list of PUBLISHED brands along with the number of AWARDS of brand's products that are Published. I am cool with all the part except issuing the "is_published" restriction when counting Awards. I hope this is clear; can anyone just suggest where to dig?

  Read the article

• TSql Lookup function

  - by OldMan

  I have a bunch of dimension tables that have unique ID and Name fields. I need a T-SQL function that returns an ID when passed a table name and a value for the name field. I'm guessing the query would build a little query then execute it? Performance isn't an issue since this is a one time ETL thing.

  Read the article

• How do I use ST_Contains in following case?

  - by Z77

  I have two tables. First with points, and second with polygons. I need to find out which points are in required polygon according to the attribute gid. Using query: SELECT table1.* FROM table1, table2 WHERE table2.gid=1 AND ST_Contains(table2.geom2, table1.geom1); What I get is empty table (only columns without data)... Tnx

  Read the article

< Previous Page | 221 222 223 224 225 226 227 228 229 230 231 232  | Next Page >