No announcements
Found 2792304 threads
-
1 Votes3 queries combined
If not, could you please share your table structure, some sample data and your desired output to clarify your need asAnswered | 3 Replies | 880 Views | Created by Shankar T - Thursday, November 17, 2016 11:05 AM | Last reply by Shankar T - Friday, November 18, 2016 11:00 AM
-
0 Votes
Query Assistance
tango, Instead of describe your table structure and data please post: 1) queries to CREATE the table(s) 2) Queries ...Answered | 2 Replies | 746 Views | Created by tango2310 - Thursday, August 18, 2016 11:44 PM | Last reply by pituach - Friday, August 19, 2016 4:24 AM -
0 Votes
combining three queries
when i do union all like you said it is combining the three quries and 3 rows are repeated . all the 3 queries have same fields so now the result looks ...Answered | 15 Replies | 3182 Views | Created by Honeycrust - Wednesday, February 8, 2012 7:34 PM | Last reply by SergNL - Saturday, February 11, 2012 8:43 AM -
0 Votes
Assistance with Query
However, I don't want to leave you hanging totally, so here's a simplified version of the concept which might help but you down the right path: declare ...Answered | 1 Replies | 910 Views | Created by joemac130 - Monday, July 28, 2014 11:44 PM | Last reply by Patrick Hurst - Tuesday, July 29, 2014 2:36 PM -
0 Votes
combine two queries into single query
Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are.Answered | 4 Replies | 1211 Views | Created by Ven Raja - Wednesday, August 27, 2014 2:16 PM | Last reply by --CELKO-- - Wednesday, August 27, 2014 7:52 PM -
0 Votes
SQL 2008 Query Assistance
Let's start with "last, second to last, etc" Note the results of this query: SELECT ...Answered | 1 Replies | 2400 Views | Created by JeffS2002 - Monday, September 24, 2012 6:29 PM | Last reply by gvee - Wednesday, September 26, 2012 1:31 PM -
0 Votes
Query assistance
Think of them as VIEWs that exist only in the scope of the query.Answered | 5 Replies | 1063 Views | Created by malibu2 - Monday, June 3, 2013 3:18 PM | Last reply by --CELKO-- - Monday, June 3, 2013 4:17 PM -
0 Votes
Combining two queries
Linq queries are composable and are not executed unilt you ask for evaluation.Answered | 1 Replies | 4445 Views | Created by Super Dave Osborne - Sunday, September 26, 2010 10:36 PM | Last reply by Pawel Kadluczka - Saturday, October 2, 2010 5:44 AM -
0 Votes
Assistance with Query Optimisation
Write 3 separate queries, one for each table.Answered | 10 Replies | 1004 Views | Created by Adam-M - Monday, March 23, 2015 10:48 AM | Last reply by davidbaxterbrowne - Monday, March 23, 2015 3:30 PM -
0 Votes
Need help with an SQL Query .... combining to queries?
You could use DSum instead of the query you've got, so that your total query could be something like SELECT AllPeople, AllPeople/DSum("AllPeople", ...Answered | 1 Replies | 1031 Views | Created by funky348 - Sunday, February 10, 2013 10:05 AM | Last reply by Douglas J Steele, MVP - Sunday, February 10, 2013 1:02 PM -
2 Votes
Collumn Field Combination on sql query
Good luck, let us know if you still need assistance.Answered | 5 Replies | 7130 Views | Created by inaocha - Wednesday, March 23, 2011 3:52 PM | Last reply by inaocha - Friday, March 25, 2011 8:53 PM -
0 Votes
Combine 2 mdx queries
Actually i am stuck up again while joining 2 mdx queries with same hierarchy.Answered | 5 Replies | 1077 Views | Created by harshita1612 - Thursday, March 8, 2018 5:51 AM | Last reply by willson yuan - Friday, March 9, 2018 1:55 AM -
0 Votes
How to combine two compiled queries?
If you have any feedback, please tell us.Answered | 2 Replies | 4391 Views | Created by leekolo - Friday, May 1, 2009 8:04 PM | Last reply by leekolo - Wednesday, May 13, 2009 9:44 PM -
0 Votes
Combine Multiple Queries
SELECT SUM(Total) AS Cash FROM Table1 Where Payment='Cash' SELECT SUM(Total) AS CreditCard FROM Table1 Where ...Answered | 2 Replies | 735 Views | Created by Dikong42 - Friday, June 22, 2018 9:28 PM | Last reply by KevinNicholas - Friday, June 22, 2018 10:03 PM -
1 Votes
need to combine two queries in PowerPivot
I could execute my query successfully using above syntax.Answered | 2 Replies | 1498 Views | Created by SS_2011 - Wednesday, June 18, 2014 7:26 AM | Last reply by SS_2011 - Wednesday, June 18, 2014 12:19 PM -
2 Votes
How to write LINQ query to combine 3 list of objects
new { First = a, Second = b, }) .Zip(list3, (a, b) => new { //use the properties from a & b to construct your desired result First = ...Answered | 2 Replies | 8598 Views | Created by Nagond - Monday, August 20, 2012 6:22 AM | Last reply by servy42 - Monday, August 20, 2012 1:28 PM -
2 Votes
Query to combine LIKE and IN functions
T-SQL query should be the first choice if it can do the "job".Answered | 10 Replies | 7403 Views | Created by JoernE - Sunday, August 22, 2010 9:01 AM | Last reply by Kalman Toth - Sunday, August 22, 2010 6:23 PM -
1 Votes
Microsoft VSTS: Please assist with the below queries for Microsoft VSTS
You should ask in one of the Visual Studio Forums Karl When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or ...Answered | 1 Replies | 2986 Views | Created by ChinnaV - Tuesday, March 19, 2013 6:07 AM | Last reply by Just Karl - Tuesday, March 19, 2013 1:31 PM -
3 Votes
SQL Querying Row Combinations
Most SQL systems will look up a value in an index rather than scan the whole table.Answered | 5 Replies | 4803 Views | Created by Brent Serbus - Wednesday, November 30, 2011 12:15 AM | Last reply by --CELKO-- - Wednesday, November 30, 2011 3:27 AM -
0 Votes
Query that provides combination of data that meet a certain criteria
Unfortunately, as I just realized, this query will not work for combinations (option 3 in your case).Answered | 15 Replies | 2470 Views | Created by chalfirbye - Thursday, December 26, 2013 12:05 PM | Last reply by chalfirbye - Monday, December 30, 2013 10:25 AM - Items 1 to 20 of 2792304 Next ›
No announcements
