No announcements
Found 1644846 threads
-
2 VotesCollate problem with temp table in union
Demo follows: use tempdb; select ProductID, ProductName=Name collate sql_latin1_general_cp1_cs_as into ProductList from ...Answered | 7 Replies | 33591 Views | Created by fpcsql - Thursday, July 2, 2009 2:10 PM | Last reply by fpcsql - Thursday, July 9, 2009 2:30 PM
-
2 Votes
UNIONing or partitioning tables.
You would have to re-write your measures to add across each of these tables.Answered | 1 Replies | 1034 Views | Created by greg0connell - Sunday, September 7, 2014 2:36 AM | Last reply by greggyb - Monday, September 8, 2014 2:30 PM -
0 Votes
Tsql Transforme Table Parent/Child Hierarchy
btw, here is an example with an clean self-referencing table (aka adjacency list) and a recursive CTE: CREATE TABLE tempdb.dbo.SampleData ...Answered | 3 Replies | 2196 Views | Created by deppsos - Tuesday, September 3, 2013 9:53 AM | Last reply by Stefan Hoffmann - Wednesday, September 4, 2013 8:19 AM -
0 Votes
Single Table or Table per subclass
In this page you will find four implementation patterns with a comparison table about each ...Answered | 1 Replies | 5587 Views | Created by Diego Barbosa - Monday, November 16, 2009 9:07 PM | Last reply by Pedro J. Molina - Tuesday, November 17, 2009 8:25 AM -
0 Votes
Identification hierarchy for a table is different when spyed on whole table and when spyed on one of the row in table.
As per my knowledge, coded ui does skip some of the parent control in identifying the required ui control.Answered | 4 Replies | 2170 Views | Created by Sirisha M - Thursday, February 16, 2012 5:05 AM | Last reply by Tapas Sahoo [MSFT] - Monday, February 20, 2012 6:26 PM -
0 Votes
Working with multiple level hierarchies in a table
Hi Kumar, Based on your description, there are multiple 3-level hierarchies in your table.Answered | 2 Replies | 775 Views | Created by Rohi Kumar - Tuesday, December 2, 2014 7:12 PM | Last reply by Eric__Zhang - Wednesday, December 3, 2014 9:13 AM -
0 Votes
Union Many Tables But Number of Columns Not Same
If the extra field comes at the same ordinal position in all tables then you can try something like below: declare @tables table(tablename varchar(1000), ...Answered | 6 Replies | 602 Views | Created by Faraz A. Qureshi - Monday, June 12, 2017 8:45 PM | Last reply by SQLNeophyte - Tuesday, June 13, 2017 7:22 AM -
2 Votes
Table Inheritance
This approach would only map each entity; StaticPage, Article to a single row in the METAData table?Answered | 3 Replies | 1045 Views | Created by Glenn Knight - Monday, January 27, 2014 9:46 PM | Last reply by Glenn Knight - Tuesday, January 28, 2014 10:25 AM -
0 Votes
Table Inserts - UNION ALL or invidual insert statements to FACT table
Insert using UNION ALL or separate queries has nothing much to do here.Answered | 6 Replies | 5045 Views | Created by debn802 - Tuesday, December 27, 2011 2:55 PM | Last reply by debn802 - Thursday, December 29, 2011 1:34 PM -
0 Votes
Union Four Large Tables
You just grab 4 data sources and they'll match themselves by name inside a UNION....Answered | 7 Replies | 662 Views | Created by ryguy72 - Monday, September 15, 2014 5:54 PM | Last reply by ryguy72 - Monday, September 15, 2014 8:59 PM -
0 Votes
table union between multiple databases
Can you try granting SELECT permissions on the table in the other database to the caller?Answered | 9 Replies | 2551 Views | Created by Jogalez - Wednesday, December 21, 2011 5:04 PM | Last reply by Mariano Gomez - Wednesday, December 21, 2011 10:08 PM -
0 Votes
can i see that which table is root table?
can i see that which table is root table?Answered | 1 Replies | 4937 Views | Created by Mehmood Ahmed - Tuesday, May 11, 2010 4:15 PM | Last reply by Kalman Toth - Tuesday, May 11, 2010 6:48 PM -
2 Votes
CTP5: Multi-level inheritance hierarchy - TPH
The only thing I do know is that in the "Model first" approach an inheritance hierarchie with abstract classes, both on top as in the middle of the hierarchie, is ...Answered | 9 Replies | 9692 Views | Created by Koen j - Wednesday, December 8, 2010 11:14 PM | Last reply by Shane Hancock - Thursday, December 1, 2011 3:41 AM -
0 Votes
table design for financial hierarchy
The first one is what I currently have, but I have yet to be able to get the two fact tables to work together the way I would expect.Answered | 6 Replies | 4621 Views | Created by GerhardW - Thursday, August 11, 2011 6:04 PM | Last reply by GerhardW - Monday, August 15, 2011 4:27 PM -
0 Votes
Update Query For Hierarchy Table
Kalman, New users on the forum can not post links in the content :-) They get some type of message.Answered | 9 Replies | 1293 Views | Created by Reza Kamarian - Saturday, September 20, 2014 2:14 PM | Last reply by pituach - Monday, September 22, 2014 4:25 PM -
0 Votes
Multiple Table Hierarchies in SSAS Tabular
No you can't create hierarchies across multiple tables in a tabular model like you can with multi-dimensional models.Answered | 2 Replies | 3033 Views | Created by James H. Robinson - Wednesday, May 18, 2016 9:38 PM | Last reply by PowerDAX - Thursday, May 19, 2016 3:35 AM -
0 Votes
Linking two tables simultaneously to third table
1) Introduce a Table-Per-Type (or Table-Per-Hierarchy) inheritance hierarchy and a common "supertype" ...Answered | 1 Replies | 821 Views | Created by Y a h y a - Thursday, June 16, 2016 9:21 PM | Last reply by davidbaxterbrowne - Thursday, June 16, 2016 9:28 PM -
0 Votes
Union some tables and left join another
SELECT H.MbrNo FROM (SELECT MbrNo FROM([UNAUTHORIZED_OVERDRAFT_33-37_CODES] UNION SELECT MbrNo FROM UNAUTHORIZED_OVERDRAFT_DEBIT_40_CODE UNION ...Answered | 5 Replies | 384 Views | Created by John Reddrick - Monday, August 24, 2015 3:50 PM | Last reply by .theDBguy - Monday, August 24, 2015 9:55 PM -
0 Votes
union vs appending to a temporary table (performance wise)
Please check-out below link http://stackoverflow.com/questions/2635615/sql-server-are-temp-tables-or-unions-better Regards, Ahmed ...Answered | 3 Replies | 4178 Views | Created by Semika - Friday, June 15, 2012 7:20 PM | Last reply by Semika - Monday, June 18, 2012 3:38 PM -
0 Votes
Mapping inherited tables to multiple stored procedures
Seems like you have a table per type going on.Answered | 2 Replies | 3090 Views | Created by Thread77 - Wednesday, November 17, 2010 12:15 AM | Last reply by Thread77 - Wednesday, November 17, 2010 3:19 PM
No announcements
