No announcements
Found 4012739 threads
-
3 VotesData Matching Reference Table
Could I approach this any other way eg would it best best to just have an entity that contains the lookup table and then use a view from MDS as ...Answered | 8 Replies | 9500 Views | Created by Buxton69 - Tuesday, November 2, 2010 8:15 AM | Last reply by Suzanne Selhorn [MSFT] - Tuesday, December 28, 2010 7:42 PM
-
2 Votes
what is the Linq equivalent (for the sql) for updating one data table with values from another data table in my app?
You can use Linq to find the update values.Answered | 12 Replies | 3477 Views | Created by Rich P123 - Friday, January 6, 2012 10:28 PM | Last reply by Louis.fr - Tuesday, January 17, 2012 5:09 PM -
0 Votes
Create a data set from data table using a regular expression match
Instead of using a DataTable.Select() medthod I used a litttle bit of Linq.Answered | 4 Replies | 4501 Views | Created by williamtholmes - Monday, October 14, 2013 3:39 PM | Last reply by Joel Engineer - Tuesday, October 15, 2013 4:19 PM -
0 Votes
Insert data from one table into another table
I need to include data from one table to another.Answered | 1 Replies | 7980 Views | Created by Tb2006 - Tuesday, November 28, 2006 12:21 AM | Last reply by Robert Varga - Tuesday, November 28, 2006 1:50 AM -
4 Votes
Matching the data with starting 2 words from two table.
Are these tables used by other processes when you are running this query?Answered | 23 Replies | 3721 Views | Created by mans.shrimali23 - Wednesday, January 2, 2013 9:04 AM | Last reply by mans.shrimali23 - Tuesday, January 15, 2013 3:29 AM -
0 Votes
Searching data in other tables and ..?
You can use the following syntax if Access can recognize the database type.Answered | 1 Replies | 3148 Views | Created by JongAm Park - Tuesday, June 7, 2011 6:51 AM | Last reply by John P Spencer - Tuesday, June 7, 2011 1:43 PM -
1 Votes
returning values from data table into lookup table
I use the constant expression '1' here, meaning that I just return the first value (which is fine if you know that the column contains the same value for ...Answered | 3 Replies | 1010 Views | Created by AlexMartini - Tuesday, October 25, 2016 2:01 AM | Last reply by Michiel Rozema - NL - Wednesday, October 26, 2016 8:14 AM -
0 Votes
Delete data from table referred in other tables
3.I was trying to delete a small piece of data (15000 rows) but the data in child tables is huge and they are being scanned for the rows to be ...Answered | 5 Replies | 1011 Views | Created by SequelBug - Wednesday, October 14, 2015 3:38 AM | Last reply by SequelBug - Thursday, October 22, 2015 7:31 PM -
0 Votes
Insert data to different table from other table
CREATE TABLE TABLE1(ID INT IDENTITY,Roll INT, Name VARCHAR(10), Amount INT); INSERT INTO TABLE1(Roll,Name,Amount) ...Answered | 3 Replies | 954 Views | Created by Sid Williams - Saturday, August 22, 2015 11:07 AM | Last reply by Eric__Zhang - Monday, August 24, 2015 7:12 AM -
0 Votes
data in tables
3 values Id, Status and ChangeDate, then you should define which value you want to enter into Status table.Answered | 14 Replies | 6013 Views | Created by Mauricio Quiroga - Wednesday, November 10, 2010 4:54 PM | Last reply by Willy Taveras - Wednesday, November 10, 2010 11:04 PM -
0 Votes
Populate data in table from another table
For example: for id =1----ques_1 id=2-------ques_1 id=3----------ques_1,id=2---------ques_2 “id=2” stands ...Answered | 2 Replies | 1136 Views | Created by emaak - Friday, November 22, 2013 10:14 PM | Last reply by Allen Li - MSFT - Monday, November 25, 2013 6:32 AM -
0 Votes
SELECT statement to return NULL by matching data from another table.
What i am trying to do is to take all the rows in the Department table and get a matching row (DEPARTMENT.NAME, DEPARTMENT_COLLECTION.REF) from the Department_Collection ...Answered | 4 Replies | 4157 Views | Created by mopatel82 - Saturday, August 28, 2010 1:13 PM | Last reply by mopatel82 - Saturday, August 28, 2010 2:44 PM -
0 Votes
Auto Insert data from one table to another
You need to understand that all we can work from is what you tell us.Answered | 6 Replies | 1305 Views | Created by Soulidentities - Thursday, September 18, 2014 2:05 PM | Last reply by pituach - Saturday, September 20, 2014 11:43 PM -
0 Votes
Matching data from two tables using simple query.
Just wanted to verify whether the table stored the value as 00174 or 174.Answered | 11 Replies | 2315 Views | Created by Shankar T - Monday, June 17, 2013 10:33 AM | Last reply by Shankar T - Friday, June 21, 2013 12:18 PM -
2 Votes
edit values in data table
Did you debug inside the loop and looked into your datatable preview to see if the data changed in datatable.Answered | 8 Replies | 4787 Views | Created by waheebc - Thursday, October 15, 2009 12:32 PM | Last reply by Codernater - Thursday, October 15, 2009 4:06 PM -
1 Votes
Matching Data using a Link/Map Table
Hi mskerry, To get the expected output, you can use CASE WHEN/IIF as well.Answered | 4 Replies | 439 Views | Created by mskerry - Friday, April 8, 2016 6:39 AM | Last reply by Eric__Zhang - Friday, April 8, 2016 9:01 AM -
0 Votes
Transfer data from a table to another table
Multiple options 1.Answered | 6 Replies | 963 Views | Created by DataNerdE - Wednesday, July 2, 2014 6:48 PM | Last reply by Itz Shailesh - Thursday, July 3, 2014 3:30 PM -
1 Votes
Update destination table when not matching data with source.
This can be beneficial to other community members reading this thread.Answered | 3 Replies | 1549 Views | Created by mkodex - Monday, July 20, 2020 3:10 PM | Last reply by Mona Lv - Tuesday, July 21, 2020 6:09 AM -
1 Votes
Using aspnet_Users data in application tables
"string.Compare" (CompareString) is what isn't supported - I've seen this recently in another (non-LS) app in LINQ-To-Objects.Answered | 13 Replies | 7912 Views | Created by KipCoder - Friday, August 20, 2010 1:19 AM | Last reply by KipCoder - Monday, September 20, 2010 8:52 PM -
0 Votes
migrating the data from one table to another table
If you have any feedback, please tell us.Answered | 10 Replies | 4444 Views | Created by Reddy84 - Monday, April 26, 2010 2:00 PM | Last reply by KJian_ - Friday, April 30, 2010 6:18 AM - Items 1 to 20 of 4012739 Next ›
No announcements
