No announcements
Found 363077 threads
-
0 Votes
Stored Procedure to Compare 2 table and create new records if new
Hi team, I am new to SQL, I have the concept below I want this to implement in my project, Please assist me how can I achieve this, I ...Unanswered | 2 Replies | 1101 Views | Created by sarathkousi - Tuesday, November 3, 2020 1:21 PM | Last reply by DA924x - Tuesday, November 3, 2020 3:02 PM -
0 Votes
stored procedure return table header
Hi, I wrote a store procedure for select statment "Select * from mytable where ...Answered | 2 Replies | 11953 Views | Created by boobyy - Friday, June 20, 2008 4:29 AM | Last reply by Ed Price - MSFT - Friday, May 11, 2012 4:26 AM -
0 Votes
create a oracle stored procedure
how to create a oracle stored procedure - 1. select statement insert/update and ...Answered | 1 Replies | 5917 Views | Created by Sathishkumar.spsk - Wednesday, September 14, 2011 6:33 PM | Last reply by Jens K. Suessmeyer - - Wednesday, September 14, 2011 9:08 PM -
0 Votes
onChange compare old and new values
Is there an easy way to compare the old and new value during an onChance event? Or do I have to make a SOAP request to get the original data ...Answered | 4 Replies | 7011 Views | Created by Jay C. _ - Wednesday, September 29, 2010 1:31 PM | Last reply by Andrii Butenko - Wednesday, September 29, 2010 8:12 PM -
0 Votes
adding stored procedure to table adapter with mySql
I have used table adapters ALOT, but always with SQLServer 2005. I have set up mySql and am trying to use a very simple stored procedure to ...Answered | 1 Replies | 9223 Views | Created by jamesm1983 - Sunday, October 12, 2008 7:27 PM | Last reply by Vijay Mullick - Monday, October 13, 2008 1:26 PM -
0 Votes
CRM 4 - Create accountvia stored procedure
You'll need to create 2 addresses in the customer address tables.Answered | 3 Replies | 5632 Views | Created by Gordon Johnston - Friday, February 4, 2011 10:55 AM | Last reply by Andrii Butenko - Friday, February 4, 2011 11:36 AM -
0 Votes
Stored Procedure Priming and Identity Reseeding
a wall attempting to fix them. The first is "MSCRM Stored Procedure Priming", which fails with the following error: ...Answered | 2 Replies | 8377 Views | Created by Sean W. McGinnis - Monday, September 28, 2009 7:02 PM | Last reply by ckeller - Wednesday, September 30, 2009 3:25 PM -
0 Votes
Synclock in CLR Stored Procedure
Dear All, I start a SQL Server Project, and write a CLR Stored Procedure. The SP (1) first reads from one table, then ...Answered | 1 Replies | 9197 Views | Created by Bjørn Sigurd - Thursday, September 4, 2008 8:45 PM | Last reply by Shrikant Maske - Monday, November 3, 2008 8:09 AM -
0 Votes
how to check if BACKUP DATABASE stored procedure was successful?
I am using C# to run a stored procedure with BACKUP DATABASE and I want to know how to returnAnswered | 1 Replies | 8204 Views | Created by Jassim Rahma - Wednesday, July 8, 2009 7:28 AM | Last reply by ashawani_dubey - Wednesday, July 8, 2009 1:07 PM -
0 Votes
How to create new Table in Dynamics CRM?
Hi, Do you need to create the new entity (table) using code? or do you want to create the new entity using MS CRM user ...Answered | 1 Replies | 6556 Views | Created by diam80 - Wednesday, October 14, 2009 6:03 PM | Last reply by Hassan Hussain - Wednesday, October 14, 2009 6:06 PM -
0 Votes
create a new entity
relationships between entities within MSCRM. You may want to create a new custom entity, import the contents of your table into the new entity and ...Answered | 1 Replies | 6351 Views | Created by KhatiaG - Wednesday, October 22, 2008 6:59 AM | Last reply by Karlo Swart - Wednesday, October 22, 2008 7:02 AM -
0 Votes
create a stored procedure to split the values of column of table on comma separator.
edition on windows 8.1. I have to create a stored procedure to split the values of column setA of table namedAnswered | 1 Replies | 645 Views | Created by mekshinu - Friday, May 22, 2015 11:27 AM | Last reply by Anuj Tripathi - Friday, May 22, 2015 1:29 PM -
0 Votes
Calling Stored Procedure from JS
If the stored procedure is in the CRM database, then this would be unsupported and I am going to say no. IF NOT, then here is ...Answered | 1 Replies | 2403 Views | Created by Atanas Desev - Tuesday, November 15, 2011 12:30 PM | Last reply by Jamie Miley - Tuesday, November 15, 2011 4:19 PM -
0 Votes
OnSave - Handling New Records
Hi,I have the following situation. When a new record is created in dynamics an ajax request is sent to an external system which returns an INT which is the records ...Answered | 2 Replies | 5166 Views | Created by Stephen Hewison - Tuesday, October 6, 2009 2:32 PM | Last reply by Stephen Hewison - Tuesday, October 6, 2009 2:57 PM -
1 Votes
Workflow to execute external SQL Stored Procedure
You shouldn't use a trigger to call a stored procedure, at least not a trigger on a table in the CRM database. That wouldn't be supported. AAnswered | 4 Replies | 2452 Views | Created by Pete Newman - Thursday, August 28, 2014 5:23 PM | Last reply by Jithesh Karumampatty Kalam - Friday, August 29, 2014 5:01 AM -
0 Votes
MSCRM 2011 Custom Stored Procedure
Making any additions/changes to MSCRM database is not supported. If you need to access Stored Procedures for your reports, please create ...Answered | 1 Replies | 2845 Views | Created by HonKuan - Monday, June 11, 2012 11:17 AM | Last reply by Sam - Inogic - Monday, June 11, 2012 11:28 AM -
0 Votes
stored procedure in ssrs reports
Hi, Can we use stored procedure to create MS CRM reports through ...Answered | 1 Replies | 8542 Views | Created by Raji kambar - Monday, February 4, 2008 12:10 PM | Last reply by Imran [MVP-MS CRM] - Monday, February 4, 2008 12:16 PM -
1 Votes
Example of Plugin to call stored procedure
used as an audit log. To simplify the actual requirement: If a Contact's Firstname is changed the plugin should run and call a ...Answered | 2 Replies | 2225 Views | Created by Basquiat - Wednesday, November 28, 2012 10:56 AM | Last reply by Mohammad Yusuf Ansari - Wednesday, November 28, 2012 12:43 PM -
0 Votes
Error Reassigning records: [SqlException: Could not find stored procedure 'dbo.p_CascadeCollectAssign'.]
looking for a stored procedure that is missing that is related to cascading type logic. There are known issues related to Update ...Answered | 6 Replies | 6304 Views | Created by kcompter - Friday, October 1, 2010 4:06 PM | Last reply by kcompter - Saturday, October 2, 2010 4:47 PM -
0 Votes
Create New
showing on that dialogue. I want people to be able to create a new address if what they want isnt in the list. What did I do wrong? How can I get it ...Answered | 16 Replies | 8214 Views | Created by SeeingStarsIsBlinding - Tuesday, March 25, 2008 9:11 PM | Last reply by Adi Katz - Thursday, March 27, 2008 1:49 AM - Items 1 to 20 of 363077 Next ›
No announcements