I'm trying to eliminate the function by rewriting the code where it is used. The listed function, Oracle.xxxfloat, I would like to remove from the column2 statement; (These functions...

Create a new schema:

IF NOT EXISTS (SELECT 1 FROM sys.schemas WHERE name = 'oracle')
    EXEC('CREATE SCHEMA oracle;');
GO

Create the function:

GO
CREATE OR ALTER...

Do you have an access predicate table valued function for the rls? If so could you paste it in here?

SELECT DISTINCT t.SomePK, t.Ellips, t.CONL, ss1.value AS MatchingWord
  FROM #temptable t
 CROSS APPLY STRING_SPLIT(TRANSLATE(t.Ellips, '=,/()', '     '), ' ') ss1
 CROSS APPLY...

It looks like there is more than one row in ICT with the same transaction_header_guid.

In SQL Server you could correctly write it as this:

UPDATE DFR
  ...

• This reply was modified 7 months, 3 weeks ago by Jonathan AC Roberts. Reason: write a BigQuery

Thank you!

I have some questions:

1. re the output parameter option solution.  Will that message show up in the output window?

2. re the alternative solution.  I am getting an error...

Actually...the above two outputs are not that important.  The SP is run in SSIS so I never see the above two issues.  Ok for now.

The more pressing...

Actually...the above two outputs are not that important.  The SP is run in SSIS so I never see the above two issues.  Ok for now.

The more pressing issue is...

.

• This reply was modified 8 months ago by Jonathan AC Roberts. Reason: deleted, duplicate

I made some progress.  New code:

ALTER procedure [dbo].[RunStoredProcedures]
as

BEGIN TRANSACTION

BEGIN TRY
truncate table dbo.testtable
select 1/0
END TRY

BEGIN CATCH
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION
RAISERROR('Rollback of stored procedures was successful', 10, 1)...

Hi SSC team,

I wanted to leave the answer here just in case anyone else needs it. This works. Only caveat is that you need to use dts.vaiables instead...

.

• This reply was modified 8 months, 3 weeks ago by Jonathan AC Roberts. Reason: deleted, duplicate

Using SoCal_DBD's data setup:

SELECT sa1.*, sa2.Count
  FROM #SampleAppointments sa1
 CROSS APPLY(SELECT COUNT(*) Count
             ...

SELECT T1.UNIT,
       T1.DATE,
       CASE WHEN COUNT(T1.PRICE) OVER (PARTITION BY T1.UNIT ORDER BY T1.DATE ROWS BETWEEN...

You need something like this:

DECLARE @var1 nvarchar(30);
SET @var1 = 'Database1';

DECLARE @sql nvarchar(max);
SET @sql = '
USE ' + QUOTENAME(@var1) + ';
-- Add the rest of your script below:
SELECT...