SQL Server :: Adding A Bunch Of New Records To The English Table / Repeating The Data Entry Into The Spanish Table
Oct 29, 2010
I have two tables for storing language translations - tblEN and tblES. They have the same structure which is nvcEnglish and nvcLocal - both nVarChar fields.
In nvcLocal of the Spanish table, I enter the Spanish translations of words and phrases used within my app. Problem is, when I add a bunch of new records to the English table I also have to go in and repeat the data entry into the Spanish table. I am wondering if there is a way to import the newly added records into the Spanish table using Transact SQL?The plain language query would be something like:
If the data in tblEN.nvcEnglish does not exist in tblES.nvcEnglish then insert a new row into tblES with the values from tblEN
View 5 Replies
Similar Messages:
Oct 15, 2010
I have 2 tables:
- Salesmen with Pk.SalesmenID
- Appointments with Fk.SalesmenID and busy(bit)
How can I check if every salesmen has at least one appointment
Am I on the right way with statement below, though I got syntax problems
[Code]....
View 5 Replies
Jan 3, 2010
I am fairly new to ASP.Net and web programming in general and I am having issues trying to add values from a dropdown list in my gridview to another table.
Here is my scenario. I have 2 tables in my SQL Express DB. When editing the values of table2 in a gridview, I would like to show some data from table1 in a dropdown so users can select a value from table 1 and enter that value in table 2.
I have the Gridview setup to show table2 data.
I created a field template and inserted my dropdown list and linked it to my table1 data source.
When I run my web form, I can click to edit one of the fields in the gridview, and my dropdown list correctly displays the data from table 1, but when I try to update the table2 with the dropdown value, it doesn't correctly update. The row in table2 never updates.
posting the dropdown value from table 1 into the appropriate field in table2..
Again, I am new to this and have been following the tutorials etc on this site, but can't find one pertaining to this topic.
View 1 Replies
Jul 29, 2010
if It is okay to delete entry directly in any aspnet_* table ? because i screwed something.
View 3 Replies
Jul 22, 2010
Using vb.net 2005/asp.net I thought I had the issue solved: I have some strings with spanish characters such as "ñ" and I need to replace characters with their non-spanish equivalent, ex: the example I just mentioned would be changed to "n".
[Code]....
when I put a breakpoint I see that usually my code replaces the characters the way that I want and all is good but some replacements are not working well and looking at my breakpoint it appears that there are non-readable characters that are included with the spanish characters and it seems that I need to do some kind of normalization on the string but not sure what to do. I have a text "caroliné" that i processing and in the code above it appears to replace the last char with an "e" but when I return the value from the function I am able to see some non readable characters (appearing on my watchlist as a small square) and the resulting string is actually "carolina" which is confusing.
View 3 Replies
Jul 15, 2010
Why would a DropDownList switch from Spanish into English when one selects a new item in it? And how does one prevent that from happening?
[Code]....
When you first come to this page after having chosen Spanish as your language, the dropdown is populated with the ListItems texts displaying -- as expected -- in Spanish. But when you go to select another item from the dropdown, all the items come back in English!
When you examine the dropdown before the AutoPostBack (both server-side and in FireBug), each ListItem is properly set, as in
Value="Some English" Text="Some Español"
whereas **after** the PostBack, it looks like
Value="Some English" Text="The same English"
Why is this happening, and what can I do to get it to keep the Spanish one sees before any PostBacks?
**Notes**:
1. The routine pointed to in `OnSelectedIndexChanged` is currently commented out, so the problem is not there.
2. I added `EnableViewState="true"` to the DropDownList, but that didn't make any difference, so I removed it.
3. As suggested below by Ichiban, I moved setting the `Thread.CurrentThread.CurrentUICulture` from `Page_Load` to `Page_Init()`, but that too didn't make any difference.
View 4 Replies
May 21, 2010
I'm suffering a well known problem with globalization, but, I tried to find the answer in the forum and got nothing. My computer has regionalization or globalization from Colombia, as i live there. I made my site and when I published I started to get errors on dates. This errors happen because in Spanish the date format is 'dd/MM/yyyy' being dd:day, MM:month and yyyy:year. In English the date format is 'MM/dd/yyyy'.There is any form or way to correct this in the entire site?? Maybe something in the web.config file?
View 2 Replies
Nov 29, 2010
I have two tables as below.
I tried to establish a relation between two tables in such a way that Table_Contracts will still accept NULL values for [PO_No], but [PO_No] on TableContract will be automatically updated when [PO_No] on Table2_PONo changed. Moreover, if you want to delete a record on Table2_PONo, it needs to be stopped if there is a related data in Table_Contracts.
I set a relation with these parameters:
Check existing data on creation or re-enabling>
No
Enforce for replication>
No
Enforce foreign key constraint>
No
Delete Rule>
No Action
Update Rule>
Cascade
I got this error
Introducing FOREIGN KEY constraint 'FK_Table_Contracts_Table2_PONo' on table 'Table_Contracts' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Table2_PONo
[PO_No]
(primary key)
[Project_ID]
[SupplierID]
[Description]
[TotalPrice]
[PO_Currency]
[VATpercent]
[CostCode]
[Notes]
[PO_Date]
[Reality]
[UpdatedBy]
[FromAccess]
Table_Contracts
[ContractID]
[ProjectID]
[PO_No]
(accepts null values)
[ContractNo]
[ContractDate]
[ContractValue_woVAT]
[ContractCurrency]
[SupplierID]
[ContractDescription]
[ContractType]
[LinkToTemplatefile_DOC]
[SentToSupplier]
[SignBySupplier]
[SignByMercury]
[CollectionBySupplier]
[LinkToPDFcopy]
[ArchivedByMercury]
[UpdatedBy]
[Retention]
[Note]
View 2 Replies
Sep 15, 2010
If I want to update 1000 records at a time in the database what is the best approach.
View 6 Replies
Sep 2, 2010
I simply have a lot of data in two columns in an excel spreadsheet of data that I gathered. I want to copy and paste this (manually) into a table that I have created in my ASPNETDB in my ASP.NET web application. I thought it'd be as easy as copy the column, and hit paste in the "table data" view, but it's not (it only pastes one cell).
Is there a way for me to manually copy data from excel and paste it in a table in my SQL Server?
View 3 Replies
Oct 26, 2010
CDC or Change data capture is a new feature in SQL Server 2008, which is an ability to record changes to table data into another table without writing triggers or some other mechanism, Change data capture records the changes like insert, update, and delete to a table in SQL server.I have sql 2005 and I have created triggers and tables CDC to capture the data. everything functions good and the data is being updated in the _CDC tables. all i need to do now is to generate the updated data as a report (excel/html)- what should I do ......?i need to show only the updated columns when user selects the date periods ( Range between dates ) and the person name - i need to display any updated info about that person during that period. So this updated columns about this person should be displayed in excel formatted column wise.
View 2 Replies
Nov 18, 2010
I have an Access 2010 DB that I have a table of RAW data in. In my scenero when table 'a' has been populated all the rows with the updatedate of Now() get moved to another table... the SQL is like this...
[Code]....
As you can see it is a very simple query but it does NOT return any rows. There are actually 404 rows with todays date in teh Append_Date column.
I am stumped as to why it does not return rows?
View 1 Replies
Jan 3, 2011
I have an SQL 2005 db with a table named "industry_suppliers."
I've created a query to enable someone to search this table using 3 parameters.
The results need to be grouped by "product_description" (which is essentially a category). When displayed on an .aspx page, for example, the results need to look like this:
Apples
Acme Apple Company
Bradbury Orchards
Oranges
A1 Citrus Company
Belfast Growers, Inc
Bradbury Orchards
Notice how "Bradbury Orchards" is repeated under both categories. This is the result I want, EXCEPT in cases where someone wants to filter the search results by category. Let's say someone wants to search just for apple suppliers. The problem I'm having is that any record that appears under apples will also get listed again under any other categories associated with that record. So, searching for apple suppliers, the results are this:
Apples
Acme Apple Company
Bradbury Orchards
Oranges
Bradbury Orchards
I'm having trouble figuring out how to revise my query to avoid this problem.
[Code]....
View 4 Replies
Dec 10, 2010
my main intention is that, the exsisting table of sql server database(.dbo) with 1000's of records, that should be import to a new access database table(.mdb).for example if we want to had a new table in db2, of exsisting table in db1 with some conditions by using "select * into New_Tabel from (select * from Exsisting_Table where <Condition>) as objectName". Here the new table is created and records inserted in one execution in db2. The same work should be done for access(sqlserver db --> Access db).Here the new access database table with given name (as string_sysdate) must be created dynamically by clicking a button (multiples time creating new table).Is there any query or c# code for sql server database to access database.
View 2 Replies
Dec 23, 2010
I have an asp:Table and around the mid point of the table there is a DDL with values 2-5. What I want to do is add the selected amount of rows using AJAX right after the table row that has the DDL in it. I know how to dynamicly crate the rows, the info in the rows, and how to use AJAX to make things. Problem is I can not put the ContentTemplate tag inbetween the asp:TableRow which would mark the location I want the dynamic rows to start being added. I did some searching on here but most posts I find start with making the table from code and not the asp:Table tag
View 2 Replies
Aug 7, 2010
I have two tables and I want to display the second one based on the primary key:
the first table is tbl1 (id,fName,lName), and the second one is scnds(id,course,tbl1id).
I am practice using MVC 2.0, so I bulilt the the class repository
[Code]....
Then created the Studentcontroller
[Code]....
The problem is if I used Details method it will show only the first record, but I want to display every course that specific a student has. I don't know if the problem in repository or in the controller.
View 2 Replies
Aug 12, 2010
I am using SSRS 2005.
I have a problem when I am exporting my report to Excel.
When exported to excel, I could see the table header on only the first page but not on all the pages. I have also checked the option "Repeat Header rows on New Page", but that didnt work.
View 7 Replies
Oct 25, 2010
I have records that were inserted into a sql server 2005 table using a stored procedure. I now need to remove or delete these records. The only problem is that the table does not contain a relevant column to define in my where clause when using delete command.
Is there any way I can identify these records for deletion.
View 4 Replies
Nov 9, 2010
i have xyz.mdf file on live server every day i want to upload records on it for that i m downloading that file , make a changes on it and upload it . which is very time consuming and not a good practice is there any tool or any simple code i can write to do this for life time.
for sql i know there is a tool sqlpublishwizard which generate a query from selected table and that we can run directly on live server query analyzer and we can get the new records.
View 1 Replies
Jul 21, 2010
[URL]above url contain a html table.I want to save this table value on XML and also want to save this table value on database MS2008.How to save html table values on database
View 3 Replies
Dec 27, 2010
i've created one package using ssis ..
That is used for transferring the data from the tableA to tableB daily at evening..
now my problem is ..
i've huge amount of data i.e upto 2GB of data while transferring for first time
the whole amount data is transferred.. and now i want to transfer only the daily updates
i.e what data i've entered today that much only it should transfer instead of whole data (2GB)..
how to do it .
View 8 Replies
Oct 8, 2010
im new to trigger concept
when i insert data in a table [DSR_OUT_PRO] data get enter in another table ie [trg_Insert_DSR_OUT_PRO] but 2 times..
Is it ok, or something is wrong..
View 1 Replies
Oct 15, 2010
i have a table which records visits to a page, what i want to do is get a count of the last 24 hours and group the visits by the hour.
This is my table structure;
ID, ChannelNewsID, AddDate
This is what i did so far however it gives me both past and future records where as i want 24 hours previously starting from when the query was run. Here is what my query looks like;
[Code]....
View 7 Replies
Oct 19, 2010
I have a piece of sql code that selects the top 10% of a table. See below a sample of the database table
And this is my code
[Code]....
So what this code does is add up all the points in the points table, (also works out what percentage of the points each user has) and then displays the top 10%, which in this case will give me "John" and "Dave"
So what I need the sql to do is check if any other records in that table have the same number of points ast the last selected record, and to select it to.
View 3 Replies
Sep 16, 2010
I have created table into database dynamicaly,while inserting records into that dynamic table i faced problem.
The name "STD000001" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. this error occured.
I created dynamic table by ,
declare @STUDENT_Table varchar(50)
set @STUDENT_Table = [dbo].[GetStudentTable](@SchoolID)
exec (@cmd)
[code]....
this stored procedure.....
Should i give any permission while creating dynamic table.
View 7 Replies
