No announcements
Found 3820458 threads
-
10 VotesHow to add multiple records to table at same time?
Thank you Brian, I am trying to add multiple records to the same table just to different drawing_names in that table.Answered | 16 Replies | 15721 Views | Created by nickjohnson - Tuesday, September 11, 2012 8:38 PM | Last reply by Ken Sheridan - Wednesday, September 26, 2012 9:41 AM
-
2 Votes
compare data from tow tables ?
If both table has same data with 'column2' , it will be able to retrieve the COLUMN1 data.Answered | 3 Replies | 5648 Views | Created by abu5alilo - Wednesday, September 15, 2010 1:05 PM | Last reply by Prakash Nandwana - Wednesday, September 15, 2010 2:01 PM -
0 Votes
How to get missing records from one table
I am a long time enemy of anything RBAR - hence my immediately going to the numbers table I posted.Answered | 16 Replies | 928 Views | Created by mutlyp - Wednesday, April 22, 2015 12:52 AM | Last reply by Jason A Long - Thursday, April 23, 2015 2:01 AM -
0 Votes
Cannot add record in ProjectEmployee Table when Employee drop down changed and show in same view
>"how to add record when drop down employee changed" Did you encounter a exception when executing following code?Answered | 2 Replies | 640 Views | Created by eng-ahmed-salah - Thursday, August 18, 2016 8:53 PM | Last reply by DotNet Wang - Friday, August 19, 2016 8:34 AM -
0 Votes
Deleting Records With The Same Value In One Feild
The only way I knew to do this, with the ability to add another pre-generated record on the edit screen, without causing the program to slow down by checking every ...Answered | 3 Replies | 2263 Views | Created by JangleKlown - Tuesday, January 24, 2012 9:02 PM | Last reply by Bob Wu-MT - Friday, January 27, 2012 8:35 AM -
0 Votes
moving records from one table into another table
Also, as you mentioned that each of the tables have their own unique RequestIDs, there has to be a way to match the records from the 2 tables.Answered | 4 Replies | 1641 Views | Created by Jim03_Jim03 - Wednesday, May 1, 2013 8:52 PM | Last reply by Megha Barpande (MCSE-Business Intelligence) - Thursday, May 2, 2013 11:14 PM -
0 Votes
How Access one Record in two user in at a time
Hi I am ok with this option but put a flag for seleted row how resrited two user attack the same row bcoz two user click the same ...Answered | 11 Replies | 7703 Views | Created by gvbas - Thursday, May 19, 2011 6:23 AM | Last reply by gvbas - Thursday, May 26, 2011 6:46 AM -
0 Votes
How to count same record in a table
1 If you also want the ID's and CODE's of the multiple records you can use this: SELECT * FROM ...Answered | 5 Replies | 762 Views | Created by thanh phan 33 - Friday, October 24, 2014 6:57 AM | Last reply by cnk_gr - Friday, October 24, 2014 8:51 AM -
0 Votes
How to not insert the same record multiple times
Hi, I have an insert statement similiar to the following: INSERT INTO Table (employeeID, employeeFirstName, ...Answered | 3 Replies | 4878 Views | Created by geekchick - Monday, February 22, 2010 10:41 PM | Last reply by Gert Drapers (MSFT) - Monday, March 1, 2010 5:59 AM -
1 Votes
How to tell SSIS to import One record at a time
It just depends on how big each row is.Answered | 9 Replies | 6000 Views | Created by subbaraokv - Monday, January 25, 2010 8:28 PM | Last reply by Todd McDermid - Monday, January 25, 2010 9:54 PM -
0 Votes
getting records from one table to another
Mitja shows you how to add records from one table to another.Answered | 2 Replies | 3288 Views | Created by Clutty - Saturday, June 11, 2011 7:31 AM | Last reply by Kee Poppy - Friday, June 17, 2011 9:16 AM -
0 Votes
Selecting different no. of records from the same table
As I am running these queries one by one in same order as given above, will second query take less time than it should if run standalone (only second query is ...Answered | 11 Replies | 5088 Views | Created by Sach Vaidya - Wednesday, September 1, 2010 10:42 AM | Last reply by Abhay_78 - Thursday, September 2, 2010 8:06 AM -
0 Votes
How do you select records from a database, make a change to one column and add it back to the same table
You essentially just INSERT that SELECT statement you posted (except substitute in the 'C' for the new SchAB column): INSERT testSchedTemp ...Answered | 1 Replies | 4693 Views | Created by WesMar - Thursday, October 29, 2009 9:35 PM | Last reply by Brad_Schulz - Thursday, October 29, 2009 9:38 PM -
0 Votes
Returning Non Indexed Records From Sorted Table - Speed Same As Indexed?
How about queries?Answered | 16 Replies | 964 Views | Created by Jesus Tebow - Tuesday, December 1, 2015 10:31 PM | Last reply by - Thursday, February 4, 2016 1:56 AM -
4 Votes
how to move crores of records from one table to another
I believe that will also take the same amount of time.Answered | 18 Replies | 6195 Views | Created by Iam_Rakesh - Friday, May 11, 2012 12:24 PM | Last reply by Iam_Rakesh - Tuesday, May 15, 2012 4:35 AM -
0 Votes
how to fetch the recordes from multiple tables across the databases in a same instance?
CREATE VIEW NEWVIEW AS SELECT * FROM [Database A].Answered | 3 Replies | 1243 Views | Created by rupc - Wednesday, October 9, 2013 9:26 PM | Last reply by SaravanaC - Thursday, October 10, 2013 3:46 AM -
0 Votes
Update table from a view
If the row count is the same as the number of records in the HR_Table, it means no records had been changed in the View.Answered | 2 Replies | 4172 Views | Created by sl5454 - Wednesday, March 24, 2010 11:30 AM | Last reply by Adam Haines - Wednesday, March 24, 2010 2:09 PM -
0 Votes
Compare records in same table
Here is one solution: SELECT testrunid, pageuri, controlcount, errorcount, createddate FROM ( SELECT testrunid, pageuri, controlcount, ...Answered | 3 Replies | 6124 Views | Created by logmeinsuckers - Wednesday, March 3, 2010 3:37 PM | Last reply by Plamen Ratchev - Wednesday, March 3, 2010 3:48 PM -
0 Votes
how to delete records from multiple tables.
You are best served by creating a stored procedure that takes the parent table key and remove any records from the child tables.Answered | 6 Replies | 6276 Views | Created by Debadatta Sahoo - Thursday, September 23, 2010 6:28 AM | Last reply by Mariano Gomez - Thursday, September 23, 2010 1:43 PM -
1 Votes
How create from 2 table one table?
Hello I have already try DataSet1.Tables["Table1"].Merge(DataSet2.Tables["Table2"]); but ...Answered | 11 Replies | 3080 Views | Created by PinkFloyd11 - Wednesday, May 18, 2011 3:43 PM | Last reply by GregHenry - Friday, May 20, 2011 5:31 AM - Items 1 to 20 of 3820458 Next ›
No announcements
