No announcements
Found 2890153 threads
-
0 VotesHow to write subquery
The problem for us is to write similar LINQ to Entities queryAnswered | 2 Replies | 2652 Views | Created by Dusan Kocurek - Sunday, July 10, 2011 6:04 PM | Last reply by Alan_chen - Monday, July 18, 2011 3:54 AM
-
0 Votes
how to write subquery in linq using VB.NET
Hi, how to write subquery in LINQ using VB.NET Thanks in Advance.....Discussion | 4 Replies | 21911 Views | Created by anil_litam - Monday, May 4, 2009 5:19 AM | Last reply by anil_litam - Tuesday, May 5, 2009 12:40 AM -
0 Votes
How to write "subquery for LINQ"
Hi, I need to write linq for ...Answered | 2 Replies | 4701 Views | Created by MSDN_Forums_User - Sunday, March 7, 2010 8:08 AM | Last reply by Amyo Kabir - Sunday, March 7, 2010 9:25 AM -
0 Votes
How to write subquery with alias column in ado.net entity
sql query but i don't know how to write it in ado.net entity query below is the working query which is fulfilling my purpose but its in raw sql not in ado.net ...Unanswered | 16 Replies | 1305 Views | Created by Learner177 - Friday, January 3, 2020 10:26 AM | Last reply by DA924x - Friday, January 3, 2020 10:13 PM -
0 Votes
how to write an mdx subquery
i want to write a subquery using mdx. in sql that would be something like CREATE PROCEDURE sp_proc @param1 ...Unanswered | 3 Replies | 8343 Views | Created by mdx buggy - Friday, May 5, 2006 9:52 AM | Last reply by srinivasR - Wednesday, December 11, 2013 6:52 AM -
1 Votes
subquery in linq
how to write subquery in linq?Answered | 3 Replies | 2960 Views | Created by nirav.sahayata - Monday, September 13, 2010 7:29 AM | Last reply by Louis.fr - Monday, September 13, 2010 8:45 AM -
0 Votes
How to write query with subquery more efficient
select a number of fields, but in the subquery i select a number of fields which are the same. Is it possible to write it more efficient? Thans ...Answered | 10 Replies | 4505 Views | Created by Hennie_Ergon - Tuesday, August 31, 2010 6:23 AM | Last reply by Gert-Jan Strik - Friday, September 3, 2010 8:34 PM -
0 Votes
How to write the subquery on multiple columns in sql server
HI i have the below query select User_Domain0 as WorkGroup,Netbios_Name0 as MachineName,v_AgentDiscoveries.AgentTime as Heartbeattime from v_R_System where User_Domain0 in ...Proposed | 5 Replies | 1381 Views | Created by Ychinnari - Wednesday, June 24, 2015 11:29 AM | Last reply by HarSan Online - Wednesday, June 24, 2015 2:10 PM -
0 Votes
HOW TO WRITE A SUBQUERY FOR SELECTING A RECORD AND FOR INSERTING AND FOR UPDATING THE RECORD IN DATABASE IN WINDOWS FORMS
newly inserted record by taking the 4 values from the 4 textboxes fields in the form.I was stucked at this point. Can anyone help me how to write a perfect query in my ...Proposed | 1 Replies | 472 Views | Created by Dileep Kumar.K - Thursday, January 1, 2015 1:37 PM | Last reply by BonnieB - Friday, January 2, 2015 12:29 AM -
0 Votes
how to write insert query using subquery in sdf
I'm try to write a sub query in sdf but i got an error ...... "insert into dailystatus(projectid,ddate,msg) values((select projectid from addproject where ...Answered | 2 Replies | 1691 Views | Created by Nandakumar A - Friday, February 15, 2013 12:55 PM | Last reply by Joshua Honig - Friday, February 15, 2013 2:51 PM -
0 Votes
How to write Query
thanks to reply Lydia. Lydia qustions are not fix. It is change. Some time it is 4 & sometime it is 6 & sometime it is 1. Then ...Answered | 4 Replies | 975 Views | Created by AK9841 - Wednesday, June 18, 2014 1:45 PM | Last reply by Visakh16 - Thursday, June 19, 2014 12:51 PM -
0 Votes
SQL Microsoft Access Question
You are asking us to do your assignment for you. That is not what we are here for. The assignment is intended to test your understanding of how ...Unanswered | 1 Replies | 533 Views | Created by GMitc - Sunday, July 28, 2019 9:28 PM | Last reply by Ken Sheridan - Sunday, July 28, 2019 10:30 PM -
0 Votes
Error showing when try to write subquery
showing Msg 116, Level 16, State 1, Line 1 Only one expression can be specified in the select list when the subquery is not introduced with ...Answered | 2 Replies | 370 Views | Created by baiju krishnan - Friday, July 29, 2016 7:09 AM | Last reply by Erland Sommarskog - Friday, July 29, 2016 8:34 AM -
0 Votes
Report Builder 3 - SQL subquery to get unique values.
Select Distinct on a subquery to my query, that brings me back to my original problem of not knowing how to write a subquery into the ...Answered | 3 Replies | 5268 Views | Created by tefkae - Thursday, July 19, 2012 10:20 AM | Last reply by irusul - Friday, July 20, 2012 6:18 AM -
0 Votes
How to write recursive TSQL Replace query?
On Thu, 20 Oct 2011 20:27:01 +0000, ironryan77 wrote: I am using SSMS 2008 and am trying to write a recursive replace statement. I have a good ...Answered | 1 Replies | 5051 Views | Created by ironryan77 - Thursday, October 20, 2011 8:27 PM | Last reply by Plamen Ratchev - Thursday, October 20, 2011 8:50 PM -
0 Votes
Update table with a subquery
].[FacultyCourseSection]. also, check out this link. It shows you how to write a split function which could be used ...Answered | 3 Replies | 4392 Views | Created by jdbargas - Wednesday, June 25, 2008 8:26 PM | Last reply by jdbargas - Wednesday, June 25, 2008 8:40 PM -
0 Votes
Replace subquery
in subquery. This query can be stored in a variable and that variable can be used in ole db source. but i want the query to be ...Answered | 2 Replies | 3391 Views | Created by Sweety P - Tuesday, March 31, 2009 1:59 PM | Last reply by Sweety P - Wednesday, April 1, 2009 5:52 AM -
0 Votes
Help, LINQ with Subquery
Hello, How would I write a LINQ that looks like this in T-SQL select ...Answered | 2 Replies | 4610 Views | Created by ShyGuy82 - Friday, August 1, 2008 6:20 PM | Last reply by ShyGuy82 - Monday, August 11, 2008 4:02 PM -
0 Votes
T-SQL Correlated subquery to MDX or SSAS measure
after transforming these source tables to SSAS cube. How should I construct my cube( Should i have to create Sepearte measure for each date like start date,end date) or ...Unanswered | 2 Replies | 1008 Views | Created by Bhojarajan V T J - Sunday, October 12, 2014 12:52 PM | Last reply by Bhojarajan V T J - Wednesday, October 15, 2014 10:33 AM -
2 Votes
how can i write this without subquery??
I want to write the same query without using subquery. How can i write that?Answered | 7 Replies | 2737 Views | Created by Incredible15 - Wednesday, November 30, 2011 7:18 PM | Last reply by Brian Tkatch - Thursday, December 1, 2011 2:19 PM - Items 1 to 20 of 2890153 Next ›
No announcements
