Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Record Numbering
#5
Ekim Wrote:You need to set a condition for your statement. to change only the needed rows.

I do not know what condition I should set. All I need is to change the Record Numbering from CON01 to CON00001 for multiple contacts at once. The first SQL query provided by Joe works but then for the UPDATE query I am not sure what condition I have to put.
Reply


Messages In This Thread
Record Numbering - by polanskiman - 05-20-2014, 10:13 AM
Re: Record Numbering - by joebordes - 05-20-2014, 02:14 PM
Re: Record Numbering - by polanskiman - 05-21-2014, 04:13 AM
Re: Record Numbering - by Ekim - 05-21-2014, 06:11 AM
Re: Record Numbering - by polanskiman - 05-21-2014, 07:06 AM
Re: Record Numbering - by joebordes - 05-21-2014, 08:41 AM
Re: Record Numbering - by polanskiman - 05-21-2014, 08:49 AM
Re: Record Numbering - by joebordes - 05-21-2014, 09:06 AM
Re: Record Numbering - by polanskiman - 05-21-2014, 09:10 AM
Re: Record Numbering - by joebordes - 05-21-2014, 09:21 AM
Re: Record Numbering - by polanskiman - 05-21-2014, 09:34 AM
Re: Record Numbering - by joebordes - 05-21-2014, 09:40 AM
Re: Record Numbering - by polanskiman - 05-21-2014, 09:51 AM
Re: Record Numbering - by polanskiman - 05-26-2014, 06:25 AM
Re: Record Numbering - by joebordes - 05-26-2014, 08:42 AM
Re: Record Numbering - by polanskiman - 05-26-2014, 09:20 AM
Re: Record Numbering - by joebordes - 05-26-2014, 09:45 AM
Re: Record Numbering - by polanskiman - 05-26-2014, 09:52 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)