No announcements
Found 244079 threads
-
0 Votes
SelectIncrementalInsertsCommand - CommandText contains two different tables with an inner join.
I have two tables Product and ProductBarcode. -
0 Votes
Problem with EntityDataSource using commandtext/include
If I Use a commandtext in EntityDataSource how would I be able to integrate the inner join statement?Answered | 1 Replies | 10555 Views | Created by TooMuch204 - Wednesday, January 28, 2009 3:15 AM | Last reply by Shrikant Maske - Monday, April 6, 2009 8:05 AM -
0 Votes
WQL Script for SCCM using the INNER JOIN function
Different.Answered | 3 Replies | 2580 Views | Created by Mr Me 2 - Thursday, October 1, 2015 7:33 PM | Last reply by Bill_Stewart - Thursday, October 1, 2015 8:45 PM -
0 Votes
INNER JOIN in reports
Change Inner Join to Left Join.Answered | 1 Replies | 6690 Views | Created by brosimba - Tuesday, August 4, 2009 8:43 AM | Last reply by Andrii Butenko - Tuesday, August 4, 2009 8:44 AM -
0 Votes
Join two columns from two different tables where both the columns have partially similar data
Join Clause: Select * From A Join B On B.Answered | 4 Replies | 1161 Views | Created by tkhan17 - Wednesday, July 18, 2018 7:18 PM | Last reply by Ahmad Adel Gad - Wednesday, July 18, 2018 8:15 PM -
0 Votes
Inner Join Challenge
Can anyone point out what am doing wrong with this inner join command.Answered | 3 Replies | 1703 Views | Created by kremilk - Monday, May 13, 2019 5:11 AM | Last reply by Guido Franzke - Tuesday, May 21, 2019 7:26 AM -
1 Votes
How to convert inner join to QueryExpression?
I suggest you use a tool - fetch XML tool (stunnware) which you can download for free.Answered | 4 Replies | 5195 Views | Created by nixjojo - Wednesday, July 20, 2011 9:53 AM | Last reply by DhavalPanchal247 - Tuesday, October 16, 2012 12:41 PM -
0 Votes
How to download all records of a table?
To download all rows (without any filters), you would need to create another scope without filters and then make a request with no anchor blob (this is ...Answered | 3 Replies | 7322 Views | Created by FireArms - Thursday, April 14, 2011 12:37 PM | Last reply by Selvin - Wednesday, April 20, 2011 9:47 AM -
2 Votes
Create a view from two tables having different number of Columns
. - Becker's LawAnswered | 5 Replies | 7461 Views | Created by devROGUE - Monday, May 7, 2012 7:17 AM | Last reply by devROGUE - Monday, May 7, 2012 6:13 PM -
3 Votes
SQL Join not returning any rows
select [CREATEDDATE] ,[REQUEST_ID__C] ,[STORE_NUMBER__C] ,[PROJECT_TASK_ID__C] FROM dmb_survey_c,dmb_Load_Sales_Force WHERE ...Answered | 3 Replies | 9721 Views | Created by zoomer61 - Thursday, July 22, 2010 2:43 PM | Last reply by Ed Price - MSFT - Monday, December 10, 2012 4:16 AM -
0 Votes
LEFT JOIN CHANGETABLE intention of SelectIncrementalInsertsCommand
While to download, it will execute SelectIncrementalInsertsCommand, SelectIncrementalUpdatesCommand and SelectIncrementalDeletesCommand.Unanswered | 2 Replies | 7647 Views | Created by Fransiscus Agung Marsono - Wednesday, September 22, 2010 1:43 AM | Last reply by Fransiscus Agung Marsono - Monday, October 11, 2010 7:29 AM -
2 Votes
Problem joining of multiple tables
SELECT Incident.TicketNumber AS [Case Number], Incident.Title AS [Case Title], Incident.CustomerIdName AS Customer, Incident.SubjectIdName, Incident.CreatedOn, Email.ActualDurationMinutes, ...Answered | 4 Replies | 3386 Views | Created by JR099 - Wednesday, September 21, 2011 5:27 AM | Last reply by JR099 - Thursday, September 22, 2011 3:32 AM -
8 Votes
Sync Framework "Filter rows " using Data Source Configuration Wizard (SyncAdapter)
Two follow-up questions: 1.Answered | 22 Replies | 13919 Views | Created by Joe Manjiyil - Friday, January 29, 2010 10:37 AM | Last reply by JuneT - Sunday, July 18, 2010 2:46 PM -
0 Votes
Synchronization help
You can filter the data in the SelectIncrementalInsertsCommand on the SQL Server 2008 DB and nothing need to do at mobile db side. ex.Answered | 3 Replies | 9855 Views | Created by Jagadeesh Babu - Thursday, July 23, 2009 7:51 AM | Last reply by L Zhou [MSFT] - Friday, July 24, 2009 5:30 PM -
0 Votes
Snapshot synchronization deletes all rows in tables
I changed to a new SD card today, and so far (1/2 dozen tests) have not been able to reproduce either data corruption or deleted rows, so this issue (in my case anyway as ...Answered | 4 Replies | 9798 Views | Created by cbp - Wednesday, February 18, 2009 9:42 PM | Last reply by cbp - Monday, February 23, 2009 7:55 PM -
0 Votes
How to sync only new records between two tables, local to remote?
Once pressing F5, one page pop-up and display all messages (about 35 lines).Answered | 21 Replies | 9070 Views | Created by aspfun - Tuesday, March 16, 2010 8:53 PM | Last reply by aspfun - Thursday, March 18, 2010 6:20 PM -
0 Votes
Startup always downloads huge amount
To collect the logs: Start, All Programs, Live Mesh, Collect Live Mesh logs.Answered | 5 Replies | 3267 Views | Created by TimothyinCT - Friday, April 3, 2009 4:35 PM | Last reply by kensm [msft] - Saturday, April 4, 2009 5:08 AM -
1 Votes
initial synchronization and "joining" two objects with the same identity
i.e. same item cannot be created in two different locations.Answered | 9 Replies | 8180 Views | Created by Robert Ginsburg - Monday, March 1, 2010 4:56 PM | Last reply by Aaron Greene - Monday, March 15, 2010 8:10 PM -
1 Votes
Can we sync two database tables with different schema?
If you use the SyncSvcUtilHelper tool to provision your database, you can use it to select tables and columns you want to sync.Answered | 1 Replies | 7602 Views | Created by Jyoti sharma - Friday, November 26, 2010 6:05 AM | Last reply by Sid Singh [MSFT] - Friday, November 26, 2010 6:18 AM -
0 Votes
set the table rows dynamically depending on a field value
Iam very new to html... so i really do not know how to dynamically construct the table ... the main issue is that i want to add rows respective to the number given in the field...Answered | 3 Replies | 1703 Views | Created by Amy.4 - Tuesday, May 13, 2014 12:03 PM | Last reply by Anupam Bishui - Wednesday, May 14, 2014 5:10 PM - Items 1 to 20 of 244079 Next ›
No announcements