No announcements
Found 1712333 threads
-
2 Votes"Select Related Tables" Question
It is not SSAS dimension/cube designer which automatically involve the related tables, it asks you to select the tables which you want to analyze that's it.Answered | 2 Replies | 858 Views | Created by pepwave - Thursday, December 10, 2015 10:50 PM | Last reply by Amit-Tomar - Friday, December 11, 2015 1:54 AM
-
0 Votes
Related table query
>I have query as below.Answered | 2 Replies | 569 Views | Created by Y a h y a - Wednesday, July 6, 2016 1:29 AM | Last reply by --CELKO-- - Wednesday, July 6, 2016 2:35 AM -
1 Votes
Query A Table Twice in a DataSet
Hi Toby, You can create two datasets with different where clause base on you requirement in the query, in this case you can get two different sets.Answered | 2 Replies | 1777 Views | Created by Toby Ellis - Wednesday, December 12, 2012 10:47 PM | Last reply by Toby Ellis - Tuesday, December 18, 2012 4:25 PM -
1 Votes
query null values in related tables
or start a new query design and copy paste SELECT companytbl.*, equipmenttbl.*, swhwattachmenttbl.Answered | 8 Replies | 4024 Views | Created by taking - Thursday, December 23, 2010 4:45 PM | Last reply by taking - Thursday, December 23, 2010 9:49 PM -
1 Votes
Join same table twice in sql Query
If anything it tends to run faster since the table only has to brought into memory once.Answered | 2 Replies | 2803 Views | Created by Michael.M.193 - Tuesday, January 8, 2013 3:59 AM | Last reply by JRStern - Tuesday, January 8, 2013 4:52 AM -
1 Votes
Query not directly related tables
Create a query on ProductReplacements with a parameter where Product.Id = @productId.Answered | 5 Replies | 1715 Views | Created by BorryZe - Thursday, February 23, 2012 11:28 AM | Last reply by Kostas Christodoulou - Wednesday, February 29, 2012 3:09 PM -
0 Votes
Dimension:Join on the same table twice
(These values related to each other).Answered | 5 Replies | 617 Views | Created by AngelosPs - Thursday, February 16, 2017 2:03 PM | Last reply by AngelosPs - Friday, February 17, 2017 11:01 AM -
0 Votes
Does Select query Lock the table
So there is a chance to get same data twice or thrice or no data.Answered | 13 Replies | 15099 Views | Created by Rohit Binjola - Wednesday, July 17, 2013 10:16 AM | Last reply by scott_morris-ga - Wednesday, July 17, 2013 12:58 PM -
4 Votes
Query Twice Execution.
The problem is when I try Fetching data the query executes twice for an ID where I got more then two rows In Items and Payment Tables.Answered | 4 Replies | 2002 Views | Created by Habib ur rehman - Friday, April 12, 2019 2:19 AM | Last reply by Habib ur rehman - Friday, April 19, 2019 11:13 AM -
1 Votes
Query to relate 2 tables and showing on a screen in Lightswitch
Hello The way I'm doing it's going to table screen and relate the two items (model and acessory) .Answered | 4 Replies | 4147 Views | Created by Aiatola - Monday, September 6, 2010 2:34 PM | Last reply by Aiatola - Wednesday, September 15, 2010 1:55 PM -
0 Votes
Dynamically Select Table in SQL Query ?
In a relational database, a table is supposed to model a unqiue entity.Answered | 6 Replies | 646 Views | Created by Sign of Shine - Monday, May 18, 2015 7:04 AM | Last reply by Sign of Shine - Monday, May 18, 2015 8:21 AM -
0 Votes
Recursive query, parent-child relations mixed in a table
Hi Satheesh, Thanks for this query.Answered | 12 Replies | 7926 Views | Created by zondan - Saturday, December 29, 2012 11:21 PM | Last reply by Erland Sommarskog - Sunday, December 30, 2012 11:51 PM -
0 Votes
In a query, I am trying to set relations with the parent table and 2 child table....VFP9 doesn't like that.
You have to join Customer table twice.Answered | 2 Replies | 2311 Views | Created by TransApp - Friday, September 16, 2011 9:01 PM | Last reply by Olaf Doschke - Saturday, September 17, 2011 12:41 PM -
0 Votes
use queried values twice in a report
Hi Eric, I tested to see if the DataSet executes once or twice.Answered | 10 Replies | 1413 Views | Created by GreenCapitalist - Saturday, August 3, 2019 8:54 PM | Last reply by GreenCapitalist - Tuesday, August 13, 2019 1:10 PM -
1 Votes
SQL Query Problems select only the ones in twice
It would be helpful if you post table schema, sample data in the form of "insert" statements, and expected result.Answered | 9 Replies | 2539 Views | Created by MarkS007 - Friday, April 27, 2012 7:06 AM | Last reply by Naomi N - Friday, April 27, 2012 3:59 PM -
0 Votes
selecting twice from the same table on a join
But it is definitely possible to join twice to the same table in different ways.Answered | 2 Replies | 3801 Views | Created by danielsn - Thursday, July 8, 2010 8:56 PM | Last reply by danielsn - Sunday, August 8, 2010 7:27 PM -
2 Votes
Query related Tabular table Relationship (DMV)
So it is possible with DMV queries, but it's just a bit tricky as the DMVs use the DMX language, not SQL so you can't do joins in the query, you have to join the data up yourself ...Answered | 2 Replies | 1567 Views | Created by Shashank Yadav MJHT05 - Tuesday, July 10, 2018 11:44 AM | Last reply by Darren Gosbell - Wednesday, July 11, 2018 6:46 AM -
0 Votes
Queries as tables
SELECT ...Answered | 7 Replies | 592 Views | Created by Y a h y a - Tuesday, July 5, 2016 5:45 PM | Last reply by Sam Zha - Wednesday, July 6, 2016 6:11 AM -
0 Votes
Query parent child relation in multiple tables
create table table1 (ParentID varchar(2), ChildID varchar(2)); insert into table1 values ('P1','C1'); create table table2 (ParentID varchar(2), ChildID ...Answered | 3 Replies | 883 Views | Created by nextwarren - Thursday, July 21, 2016 11:58 AM | Last reply by Johnny Grun - Friday, July 22, 2016 3:04 AM -
4 Votes
Top related threads show the same thread and twice
Where do you find the "Top Related Threads"?Answered | 4 Replies | 3116 Views | Created by Naomi N - Friday, June 21, 2013 4:33 AM | Last reply by Naomi N - Monday, June 24, 2013 11:39 PM - Items 1 to 20 of 1712333 Next ›
No announcements
