No announcements
Found 166835 threads
-
0 VotesNested SQL select query format problem
My sql query isn't being accepted. I keep getting ORA-00907, ORA-00933 or ORA-00979 errors. Can any one see what is wroing with the syntax? SELECT ...Unanswered | 1 Replies | 7804 Views | Created by dvandeus - Friday, February 19, 2010 9:08 PM | Last reply by Harry Zhu - Thursday, February 25, 2010 6:02 AM
-
0 Votes
filters inside a nested query
inside the nested query. select distinct test.nbAnswered | 3 Replies | 5265 Views | Created by BUGS Bunny Race - Monday, October 4, 2010 3:17 PM | Last reply by DavidBerry - Thursday, October 7, 2010 7:15 PM -
1 Votes
Dynamics Query CRM Data - Date format problem
and create a dialog which fetches data with "Query CRM Data" step. I filter the ScheduledStart with the Process - Execution Time field. It works if I set the ...Unanswered | 4 Replies | 4603 Views | Created by Tamas Molnar - Thursday, June 7, 2012 12:20 PM | Last reply by Vijay Deshpande - Thursday, June 6, 2013 3:57 PM -
0 Votes
.net Nested Repeater Problem.
hi everyone... I'm using nested repeaters for my category-subCategory tables... but I'm getting an error... my all codes,Error and DB shown as ...Unanswered | 2 Replies | 1243 Views | Created by Başar Şen - Tuesday, May 14, 2013 12:16 PM | Last reply by Lisa Zhu - Wednesday, May 15, 2013 2:10 AM -
0 Votes
Nested sql statement help
I have a sql query that is taking the latitude and longitude from the table and comparing it to the set latitiude and longitude from my location. I want to be able to have a case ...Unanswered | 2 Replies | 1106 Views | Created by chopich05 - Thursday, June 26, 2014 3:31 PM | Last reply by Carey Frisch - Tuesday, July 1, 2014 6:56 AM -
0 Votes
Problem executing sql query agains filtered views
I am using the code below to try to execute an sql query against some views , inside aAnswered | 2 Replies | 5192 Views | Created by CRM User - Friday, April 30, 2010 9:01 AM | Last reply by CRM User - Friday, April 30, 2010 9:56 AM -
0 Votes
CRM Linq query cause sql lock with select top 5001
I'm using linq to query data, but some times it cause sql lock: Language Event 0Unanswered | 2 Replies | 1676 Views | Created by Awen Hu - Thursday, November 20, 2014 9:20 AM | Last reply by Awen Hu - Thursday, November 20, 2014 9:47 AM -
0 Votes
LINQ select query with OR
Executing 'SELECT' query with 'WHERE' clause which have 'OR' and 'AND' operators give wrong result. Example: Have 4 tables: ...Unanswered | 1 Replies | 9017 Views | Created by spv098 - Friday, September 10, 2010 8:57 AM | Last reply by SachinW - Saturday, September 11, 2010 12:43 AM -
0 Votes
Select query not getting data
i am using a query in my asp.net application "select * from tablename" it is not working. the table is in relationship with two other table i removed relation but still notAnswered | 6 Replies | 947 Views | Created by Ifitikhar Iffy - Monday, March 16, 2015 6:47 AM | Last reply by Carl Cai - Wednesday, March 25, 2015 8:41 AM -
1 Votes
format problem
First start windows installed in d: -> Now press right click on c: -> Select Format -> Select Quick Format -> Click ...Unanswered | 6 Replies | 3734 Views | Created by mudisrinivas_mudi4 - Sunday, December 23, 2007 7:40 AM | Last reply by Saket_Asati_c2cb04 - Tuesday, January 29, 2008 9:55 PM -
0 Votes
SQL query
You can use the CONVERT function with argument 101: select convert(datetime, '12/31/2016 01:03:03PM', 101) Since you asked in the Training and ...Answered | 1 Replies | 994 Views | Created by Gunjan1402 - Tuesday, July 5, 2016 1:24 PM | Last reply by Alberto Poblacion - Wednesday, July 6, 2016 5:32 AM -
0 Votes
SQL Query Help
I have a parent entity Contact and child entity employment. I want to select contact name, who has atleast 1 employment record with Comany ... -
0 Votes
SQL Query
query.The row is getting duplicated in #Fact table. Where is my query going wrong. Query i wrote: INSERT INTO #FACT ...Answered | 2 Replies | 872 Views | Created by Leo00 - Tuesday, November 19, 2013 4:30 PM | Last reply by Just Karl - Tuesday, November 19, 2013 7:52 PM -
0 Votes
SQL Query
Hi As David said, we are not allowed to do CRM - SQL operation you can post your query explanation to here (what kind of query you are ...Proposed | 5 Replies | 3072 Views | Created by suray kathir - Friday, December 16, 2011 7:00 AM | Last reply by Bhautik Desai-XRM Tech - Friday, December 16, 2011 1:15 PM -
0 Votes
Nested dropdown in detailsview problem
Hello everyone, I am a complete newbie with ASP and VB.net so please forgive me when I ask something stupid! Sorry this is also a bit long! I have a detailsview with a ...Unanswered | 1 Replies | 10504 Views | Created by Mr SH - Thursday, August 28, 2008 1:32 PM | Last reply by Martin Xie - MSFT - Wednesday, September 3, 2008 10:16 AM -
0 Votes
SQL Query
This was moved to the Off Topic forum. I can move it to a specific forum for you, if you'd like. Thanks! Ed Price (a.k.a User Ed), SQL Server Experience ProgramAnswered | 2 Replies | 11662 Views | Created by kms2007 - Sunday, June 15, 2008 10:46 PM | Last reply by Ed Price - MSFT - Thursday, May 10, 2012 7:07 AM -
0 Votes
Problem using datagridview and sql query notifications
Hi I am using datagridview and sql notifications as follows: In Form A i have the datagridview and sql notifications binded ...Unanswered | 1 Replies | 7489 Views | Created by badshahkhan - Monday, December 1, 2008 11:52 AM | Last reply by Michael Sun [MSFT] - Thursday, December 4, 2008 8:21 AM -
2 Votes
SQL Report Design / Query
Hello. In SQL Server in your CRM organization DB you have a lot of datetime functions which can help you build your requests easily. You can find ...Answered | 2 Replies | 6491 Views | Created by The Great Believer - Monday, September 27, 2010 9:39 AM | Last reply by Andrii Butenko - Monday, September 27, 2010 6:58 PM -
1 Votes
select SQL statement
'2014-10-24 00:00:00:000' order by CHECKTIMEUnanswered | 3 Replies | 760 Views | Created by ghost-man - Saturday, November 8, 2014 6:08 PM | Last reply by Mr. Wharty - Tuesday, November 11, 2014 8:44 AM -
0 Votes
Convert a SQL query to Fetchxml query
Following is the SQL query for the same. select mcg_name, countAnswered | 1 Replies | 1073 Views | Created by Nikhil Naralkar - Friday, June 13, 2014 9:50 AM | Last reply by DavidJennaway - Monday, June 16, 2014 12:39 PM - Items 1 to 20 of 166835 Next ›
No announcements
