No announcements
Found 2927464 threads
-
1 VotesLinq inserting double records to the table
I've noticed that in the table I have duplicated records (different ID (withPK)). So, I think that this method, or entire message is executed twice. I was trying ...Answered | 2 Replies | 320 Views | Created by VoVoTT - Tuesday, June 16, 2015 5:00 PM | Last reply by VoVoTT - Tuesday, June 16, 2015 6:17 PM
-
1 Votes
Inserting records to table
I want to do a insert operation from SourceTable to Desitnation Table but the length of the source and desination columns are differentAnswered | 6 Replies | 4373 Views | Created by CSharp Enthusiast - Wednesday, August 11, 2010 4:05 AM | Last reply by Kalman Toth - Tuesday, November 30, 2010 6:05 AM -
4 Votes
Inserting records in temp table
I am unable to put result in #temp table and gets incorrect syntax error message. Declare @Country integer='A' select into ...Answered | 5 Replies | 641 Views | Created by Jugnu67 - Wednesday, March 20, 2019 5:52 PM | Last reply by Natig Gurbanov - Wednesday, March 20, 2019 10:02 PM -
0 Votes
Sort a table when inserting records
Hi guys, I was wondering if it is possible to sort the table automatically when entering records...since I didn't find any ... -
1 Votes
Inserting Records
Thanks. One additional thought to add more complexity. Some records in the destination table are populated. Is there a way to add a ...Answered | 5 Replies | 6247 Views | Created by kubmg - Monday, April 27, 2009 1:28 AM | Last reply by Ken Simmons - Monday, April 27, 2009 2:22 PM -
0 Votes
extracting and inserting records into DB table
How wide is your table also matters than the number of records. Inserting 140 million records in a table from another table would consume ...Answered | 5 Replies | 5587 Views | Created by dbablackbelt421 - Monday, March 21, 2011 8:41 PM | Last reply by dbablackbelt421 - Tuesday, March 22, 2011 1:09 PM -
1 Votes
inserting double number into data table
The OledbCommand uses a string so you don't need to convert the textboxNote to a double. The Text is already a string. The ...Answered | 2 Replies | 591 Views | Created by tedtom - Friday, April 11, 2014 11:38 PM | Last reply by tedtom - Saturday, April 12, 2014 8:20 AM -
1 Votes
Inserting records
--Currently I am inserting records in many lines. can we insert in one line, as per desired script but I am getting error. Any idea please. Insert into temp Select * from ...Answered | 2 Replies | 3923 Views | Created by Khan_K - Monday, January 18, 2010 3:40 PM | Last reply by Khan_K - Monday, January 18, 2010 4:58 PM -
2 Votes
LINQ to SQL. Inserting data from one table to another.
Hi guys. I have two tables in the database and I need to create LINQ to SQL query that will select specific data and insert it into the other ...Answered | 2 Replies | 970 Views | Created by Wizard_C - Tuesday, June 10, 2014 9:22 PM | Last reply by Wizard_C - Wednesday, June 11, 2014 11:43 AM -
0 Votes
Inserting records
one, and the relationships between the tables was messing us up. We were able to insert records in the end by using a small table that ...Answered | 5 Replies | 7929 Views | Created by Proguy1984 - Monday, August 24, 2009 7:20 AM | Last reply by pratixa1 - Tuesday, August 25, 2009 6:43 AM -
0 Votes
Update relational table when inserting records
Task_Assignments table to create the relationship between the tables Tasks and Personnel. <Answered | 6 Replies | 1435 Views | Created by sander_d - Thursday, May 2, 2013 6:20 AM | Last reply by --CELKO-- - Thursday, May 2, 2013 2:07 PM -
0 Votes
Check for Duplicate Records before inserting records into SQL Table
Hi, How can i check records in main table first before inserting records from second table. I cannot have ...Answered | 3 Replies | 2227 Views | Created by sullman - Friday, April 24, 2015 2:05 PM | Last reply by Cor Ligthert - Friday, April 24, 2015 3:31 PM -
0 Votes
Inserting multiple records in MS Access table...
Create connection to Access database file and execute either of the following statements (modify path to correspond to your file location). The SELECT ...Answered | 8 Replies | 6704 Views | Created by malliks - Friday, January 4, 2008 8:00 AM | Last reply by Paul P Clement IV - Monday, January 7, 2008 9:04 PM -
0 Votes
Inserting records manually into a fact table?
Datamart has missing records... The real problem is that management decided to, instead of trying to make those records to our transactional, ...Answered | 3 Replies | 416 Views | Created by maca128 - Monday, July 4, 2016 10:58 AM | Last reply by davidbaxterbrowne - Tuesday, July 5, 2016 4:38 PM -
0 Votes
inserting huge volume of records in to table-slow performance
Hi I need to insert 100000 records into the master table from temperory table. i have 100000 records in ...Unanswered | 7 Replies | 4768 Views | Created by Arun.Mohan - Thursday, May 31, 2012 11:34 AM | Last reply by Arun.Mohan - Friday, June 1, 2012 11:12 AM -
0 Votes
Inserting records from staging to main table where records don't exist in main table
insert the new records that are coming in today. So, when this staging table loads to my main table. i want to see just the distinct ...Answered | 1 Replies | 1635 Views | Created by SqlCraze - Friday, March 1, 2013 10:33 PM | Last reply by Todd C - Saturday, March 2, 2013 3:58 AM -
0 Votes
INSERTING 20Mill Records into a Table with 100Mill Records..
Table2.* from Table 2 where exists (select 1 from Table3 where Table2.xyz = Table3.xyz and Table2.abc = Table3.abc); Whats the most ...Unanswered | 4 Replies | 4877 Views | Created by MKR10 - Sunday, June 24, 2007 3:17 PM | Last reply by Arnie Rowland - Sunday, June 24, 2007 8:11 PM -
0 Votes
Inserting records in to Cube..
, then you will likely have to process all partitions where the data has changed. Or process the entire cube, if you have no way of tracking what data has changed. If ...Unanswered | 2 Replies | 4835 Views | Created by SQLrocket3003 - Thursday, August 14, 2008 6:56 AM | Last reply by SQLrocket3003 - Thursday, August 14, 2008 1:19 PM -
2 Votes
Permission inserting to the table
MS SQL 2008. Guys, please, tell me, if I have a stored procedure that inserting strings to the table should I give any permissions on ececution procedure or simple ...Answered | 4 Replies | 3888 Views | Created by SunnyIngulia - Friday, November 26, 2010 3:21 PM | Last reply by Badii Gharbi - Friday, November 26, 2010 4:07 PM -
0 Votes
Inserting records issue SSIS
You need to identify whether the incoming source data is an existing record in the destination table and if yes you need to filter out such ...Answered | 9 Replies | 1857 Views | Created by BandSr - Thursday, October 4, 2012 11:18 AM | Last reply by BandSr - Thursday, October 4, 2012 4:31 PM - Items 1 to 20 of 2927464 Next ›
No announcements
