No announcements
Found 1242358 threads
-
1 VotesPartioning Master Detail tables
Hello, According to the requirements of move partitions: No foreign key from another table can reference the source table.Answered | 1 Replies | 1642 Views | Created by JanDV - Monday, April 14, 2014 12:56 PM | Last reply by Fanny Liu - Wednesday, April 16, 2014 11:43 AM
-
0 Votes
Master record with 3 detail table
You can also use nested tables/tablix and a UNION query to return the details.Answered | 4 Replies | 3830 Views | Created by sandeep.studd - Tuesday, May 12, 2009 11:49 AM | Last reply by Aaron Meyers - Thursday, May 21, 2009 9:32 PM -
0 Votes
Re-Index a partioned table
I need to add insertdate + RowID (incremantal) as partion index.Answered | 3 Replies | 7727 Views | Created by mecn - Wednesday, December 1, 2010 5:22 PM | Last reply by Tom Li - MSFT - Sunday, December 5, 2010 11:05 AM -
0 Votes
Master-Detail with combobox as master
So it will be much easier to select a Master record via the keyboard.Answered | 3 Replies | 4415 Views | Created by Adam VFP - Monday, November 15, 2010 5:21 PM | Last reply by Mattyg07 - Friday, November 19, 2010 7:47 PM -
3 Votes
Master-Detail-Detail Screen
(2) is harder, and you will have to use custom control and write custom render code to load all the Orders for each Customer, then build a list/table to display ...Answered | 3 Replies | 2452 Views | Created by Dragonalw - Monday, March 25, 2013 8:36 AM | Last reply by Huy Nguyen MSFT - Thursday, March 28, 2013 4:38 AM -
0 Votes
Inserting into Master AND Detail table at the same time
You need to save Order and retrieve Order Id and then update order details table.Answered | 2 Replies | 5981 Views | Created by TPascal - Thursday, May 19, 2011 1:54 AM | Last reply by Pratap Bhaskar - Tuesday, May 24, 2011 11:02 AM -
3 Votes
Cannot insert/update data on the detail table via master-detail form
overall update process of tables with master-detail relationship.Answered | 9 Replies | 2403 Views | Created by ioulianos - Saturday, November 12, 2011 10:14 AM | Last reply by ioulianos - Thursday, November 17, 2011 7:19 PM -
0 Votes
Master-Detail(Master)-Detail C#, WPF App
For a clear cut code sample see my MSDN code sample that reads from a database (as mentioned above it truly does not matter the source but after the DataSet is loaded) and has a ...Answered | 8 Replies | 1031 Views | Created by Markus Freitag - Monday, June 25, 2018 4:43 PM | Last reply by Kareninstructor - Wednesday, June 27, 2018 5:02 PM -
0 Votes
how to calculate master/detail table discount as value
The term “master” is not part of RDBMS; it is from mag tape files and network databases.Answered | 2 Replies | 2867 Views | Created by haqayyum - Saturday, December 21, 2013 10:27 AM | Last reply by --CELKO-- - Monday, December 23, 2013 12:58 AM -
1 Votes
Table Partioning
Table partitioning is very broad subject and the question if table needs to be partitioned is a bit separate from data/filegroups layout.Answered | 2 Replies | 1204 Views | Created by Preetha7 - Tuesday, June 24, 2014 6:02 AM | Last reply by Dmitri Korotkevitch - Friday, June 27, 2014 1:59 PM -
2 Votes
Inserting master detail table records in a single query in sql server 2008
This will insert 1200 records in Details table with PK generated in Master table.Answered | 4 Replies | 10161 Views | Created by sathyguy1 - Tuesday, October 14, 2014 7:57 AM | Last reply by Visakh16 - Wednesday, October 15, 2014 11:51 AM -
0 Votes
Master Detail with an Identity column
Retrieve the identity values after the rows been added to your table, and merge them back to your business keys 3.Answered | 5 Replies | 4472 Views | Created by BShaw - Tuesday, March 24, 2009 6:31 PM | Last reply by Todd McDermid - Tuesday, March 24, 2009 8:21 PM -
1 Votes
Master-Details for first record in details
But, can you explain it in more details?Answered | 12 Replies | 2529 Views | Created by IT_Technician - Sunday, August 5, 2012 9:45 AM | Last reply by IT_Technician - Thursday, August 23, 2012 6:28 AM -
0 Votes
How to programming Master Details Details Details
Hi, For a start you need to determine or tell us what TYPE each of the fields in the tables are please.Answered | 2 Replies | 3251 Views | Created by KhaLeeL ZoURoB - Sunday, July 26, 2009 8:12 AM | Last reply by John Anthony Oliver - Sunday, July 26, 2009 9:19 AM -
0 Votes
Data partioning sql2005
Is it compulsory to have table partioned for switch operation?Answered | 2 Replies | 5286 Views | Created by srm_2010 - Wednesday, July 7, 2010 8:58 AM | Last reply by srm_2010 - Thursday, July 22, 2010 5:52 AM -
1 Votes
Master detail
Hi Carlos, There are two options to display a master detail view, one option is use web part connection and another one is use custom Jquery code to diplay the ...Answered | 2 Replies | 761 Views | Created by CarlosFlores119 - Wednesday, July 6, 2016 1:36 AM | Last reply by Jerry Zy - Thursday, July 7, 2016 6:49 AM -
0 Votes
Master Detail Form
All this complicated code is needed to work with a master and detail grids and a datasource?Answered | 7 Replies | 938 Views | Created by SHISHIR WAHI - Saturday, November 26, 2016 3:26 PM | Last reply by DA924x - Sunday, November 27, 2016 7:41 PM -
0 Votes
entitydatasource.... master details... querying
I have two tables in my entity model with a one to many relationship...Answered | 1 Replies | 4178 Views | Created by treeman2 - Monday, July 27, 2009 2:30 AM | Last reply by Diego B Vega [MSFT] - Monday, July 27, 2009 4:41 AM -
0 Votes
Entity Framework: performance issue regarding Loading Master and Detail tables
One thing we concern about separetely querying/loading Master and Detail tables is we load all detail table data into memory.Answered | 4 Replies | 3647 Views | Created by JJChen - Wednesday, April 21, 2010 10:48 PM | Last reply by Michael Sun [MSFT] - Thursday, April 29, 2010 12:53 PM -
0 Votes
Partioning possibilities in standard sql 2005?
I set up the load script such that it checks to see if a new month has happened, and if so: - acquire an app lock that the reading stored precedure also attempts to ...Answered | 12 Replies | 4472 Views | Created by OuttaCyTE - Tuesday, September 1, 2009 6:38 PM | Last reply by OuttaCyTE - Friday, May 28, 2010 4:22 PM - Items 1 to 20 of 1242358 Next ›
No announcements
