Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
ALTER procedure [dbo].[MTS_Load_Config_Saved_All_Providers]( @practice_id varchar(4), @location varchar (40), @document varchar(40), @practice varchar(40)) as select description, pm.provider_id into #providers from provider_mstr pm join provider_practice_mstr ppm on pm.provider_id=ppm.provider_id where ppm.attending_ind='Y' and pm.delete_ind='N' and ppm.delete_ind='N' and ppm.practice_id = @practice_id order by description insert into MTS_Fax_Config_Saved_ (seq_no, practice_id, created_by, modified_by, txt_document_description, txt_practice_name, txt_location_name, txt_provider_name) select newid(), @practice_id, 0, 0, @document, @practice, @location, description from #providers
|SQL Server - SQL field is defined as text||3||27|
|Whats wrong in the below query? Any help would be appreciated...||2||14|
|Oracle 10g - Select rows into colums||4||10|
|Find data in a column which is not in a date format||29||10|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!