1 support issue
- All
- Questions
- Suggestions
- Problems
Eric Osmann
Jan 29, 2024
Multiple commands or instructions all on one line
Is there a NO Format mode you can provide?
The default behavior is completely messing up the script for both running and readability
Such as
IF dbo.dbProcedureExists('RBC_sp_Imports_Load_RBCMMR_Daily') = 1 DROP PROCEDURE RBC_sp_Imports_Load_RBCMMR_Daily
Where the following instruction is appended to the same line. I realize that the code may not be written to spec but this is why a RAW feature would be nice. Currently, I see no option that will show the code in its original form on the screen.
Here is another example where the DECLARES are all appended to the end of the UPDATE command:
--Update Fund ID's
UPDATE
Import
SET
Import.ShareClassID = SC.AutoID
FROM
fs_ShareClasses_v2 SC,
RBC_Imports_RBCMMR_Daily Import
WHERE
Import.Share_Class_Cusip = SC.CUSIP DECLARE @ImportDate datetime DECLARE @DateMonthly datetime DECLARE @EndOfLastMonth datetime --Check auth table for date and Fund entry if does not exist add entry for date and all funds to all Dynamic FCD tables using fs_sp_FCD_Insert_DateRows
SELECT
TOP 1 @ImportDate = [Date]
- Report illegal content
- Copy link