No announcements
Found 2901734 threads
-
2 VotesMapping multiple (two) row into one entity – how to?
https://stackoverflow.com/questions/8082057/how-to-use-pivot-table-with-entity-framework Or loop the table records, assign to one ...Unanswered | 2 Replies | 466 Views | Created by Uzivatel 919 - Thursday, October 18, 2018 8:27 AM | Last reply by Zhanglong Wu - Friday, October 19, 2018 1:36 AM
-
1 Votes
Mapping multiple tables to one entity
Hi TimmyC,Here is an ADO.NET Team Blog about mapping two tables to one entity,Answered | 5 Replies | 6981 Views | Created by TimmyC - Wednesday, October 14, 2009 10:45 AM | Last reply by Yichun_Feng - Tuesday, October 20, 2009 2:16 AM -
0 Votes
Two Table mapping into one entities
Hi All Is it possible to map two tables into one entity with not the same primary keys? E.g. Order ...Answered | 1 Replies | 3834 Views | Created by hnchass - Thursday, November 27, 2008 11:15 AM | Last reply by MatthieuMEZIL - Thursday, November 27, 2008 3:22 PM -
0 Votes
Multiple views with same layout mapping to one entity
marked your reply as answer. It was not the answer I was hoping for, but at least now I know I can't map one entity to multiple views / ...Answered | 2 Replies | 1994 Views | Created by pexxx - Tuesday, October 25, 2011 11:46 AM | Last reply by pexxx - Tuesday, October 25, 2011 1:36 PM -
0 Votes
One Row into multiple Column
One more method: CREATE TABLE #ids (empid VARCHAR(200)) INSERT INTO #ids SELECT '100,200,300,400' INSERT INTO #ids SELECT ...Answered | 5 Replies | 842 Views | Created by Vaishu - Friday, January 31, 2014 5:20 PM | Last reply by Prashanth Jayaram - Friday, January 31, 2014 5:52 PM -
0 Votes
Multiple columns into one row
How do I make this happen automatically (without having to copy and paste each section)? Thank you!Unanswered | 1 Replies | 3111 Views | Created by ana_elisap - Wednesday, July 25, 2012 8:35 PM | Last reply by Mike Kinsman - Monday, July 30, 2012 7:28 PM -
2 Votes
concatenate multiple row values into one row
CREATE TABLE #mable(mid INT, token nvarchar(16)) INSERT INTO #mable VALUES (0, 'foo') INSERT INTO #mable ...Answered | 3 Replies | 4078 Views | Created by SQL_tp - Thursday, June 27, 2013 10:35 AM | Last reply by Uri Dimant - Thursday, June 27, 2013 10:56 AM -
4 Votes
How to combine data from two rows into one row
Steps: 1. Make a temp table . 2. While loop Begin Fetch a row from given tables field_value separate it by , ...Answered | 4 Replies | 1937 Views | Created by TheBrenda - Friday, September 26, 2014 10:30 PM | Last reply by Uri Dimant - Sunday, September 28, 2014 8:58 AM -
0 Votes
How to merge two rows into one row in sql??
there an easy way to turn this into format below ??Answered | 3 Replies | 762 Views | Created by kjleong - Thursday, September 24, 2015 1:48 AM | Last reply by Eric__Zhang - Thursday, September 24, 2015 2:39 AM -
3 Votes
Mapping row data into from multiple rows to single
its frying to transpose most of this into one row to display all the data across columns per Patient_OIDAnswered | 7 Replies | 402 Views | Created by SimonKEvans - Wednesday, May 3, 2017 6:22 AM | Last reply by Uri Dimant - Wednesday, May 3, 2017 8:51 AM -
0 Votes
Mapping Entity Hierarchy to multiple views
Ok, now I understand, thank you. The Entity Framework does allow mapping inherited properties to separate tables, but the designer does not support this scenario. So, if ...Answered | 3 Replies | 3745 Views | Created by PJ on Development - Thursday, December 11, 2008 6:17 PM | Last reply by Noam Ben-Ami - MSFT1 - Friday, December 12, 2008 6:26 PM -
0 Votes
MSSQL - Merge two row into one
I want to combine "Freight-in (Go) and Freight Savings" row into a singleAnswered | 1 Replies | 588 Views | Created by zXSwordXz - Thursday, February 26, 2015 10:04 PM | Last reply by Jingyang Li - Thursday, February 26, 2015 10:12 PM -
0 Votes
Split one row into multiple rows
; I want to Split the above row into the rows like below. Date, Ref, ...Answered | 2 Replies | 9879 Views | Created by bonosungho - Friday, January 27, 2012 2:31 AM | Last reply by Vinay Valeti - Friday, January 27, 2012 5:19 AM -
0 Votes
Single Row multiple columns into one column
Hi Lenoj, I don't quite get "I wanted to get the latest based on enddate and the other one the enddate is June 6. I need to ...Answered | 9 Replies | 733 Views | Created by Lenoj - Thursday, June 4, 2015 8:32 AM | Last reply by Lenoj - Thursday, June 18, 2015 5:24 AM -
0 Votes
Collapsing multiple rows into one row
from 1 to probably 30+ products which means each id will have a variable number of rows. What i'm trying to do is get one row per id that will show ...Answered | 2 Replies | 2583 Views | Created by AlphaVictor87 - Wednesday, October 26, 2011 5:49 PM | Last reply by AlphaVictor87 - Wednesday, October 26, 2011 6:01 PM -
5 Votes
Collapsing Multiple Rows Into One Row
readmission, rather than just one. So, I need to collapse the SNF claims data into SNF encounters. The grouping for payments is the sum of the ...Answered | 19 Replies | 675 Views | Created by Adam Quark - Wednesday, May 3, 2017 3:55 PM | Last reply by Adam Quark - Friday, May 12, 2017 4:00 PM -
0 Votes
Rolling up multiple rows into one row
The only problem with that approach is that I don't want to hardcode employeeid = 10. I want this query to actually return the salesrates for all employees (with each ...Answered | 6 Replies | 6943 Views | Created by sqlserver_newbie - Thursday, January 15, 2009 12:54 PM | Last reply by sqlserver_newbie - Thursday, January 15, 2009 2:33 PM -
2 Votes
combining two rows into one row with two columns
select 'ZAA',1800,'N' SELECT * FROM #TMP trying to make a single row for each name ...Answered | 2 Replies | 2498 Views | Created by Vaishu - Wednesday, February 22, 2012 12:01 AM | Last reply by Vinay Valeti - Wednesday, February 22, 2012 12:10 AM -
0 Votes
Combining multiple rows into one row
In the report, rows 1, 2, 3 from the results should roll into one row with the ScannedByTimeStamp from each row returned by the queryProposed | 3 Replies | 762 Views | Created by duane casteel - Sunday, April 12, 2015 4:28 PM | Last reply by duane casteel - Tuesday, April 14, 2015 1:46 PM -
0 Votes
Unable to insert two values into one row SSIS
values separately into two rows one by one but i want to insert these two values in one row ...Answered | 6 Replies | 2737 Views | Created by ashuthinks32 - Wednesday, September 21, 2011 7:07 AM | Last reply by Sudeep Raj - Wednesday, September 21, 2011 10:32 AM - Items 1 to 20 of 2901734 Next ›
No announcements
