Viewing 15 posts - 16 through 30 (of 2,645 total)
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...
February 25, 2025 at 7:52 pm
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...
February 25, 2025 at 7:48 pm
Do you have an access predicate table valued function for the rls? If so could you paste it in here?
February 20, 2025 at 6:41 pm
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...
February 20, 2025 at 5:49 pm
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
...
February 10, 2025 at 1:12 am
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...
February 3, 2025 at 1:10 am
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...
February 2, 2025 at 4:27 pm
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...
February 2, 2025 at 3:07 am
.
February 1, 2025 at 8:15 pm
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)...
February 1, 2025 at 8:14 pm
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...
January 10, 2025 at 12:15 am
.
January 10, 2025 at 12:15 am
Using SoCal_DBD's data setup:
SELECT sa1.*, sa2.Count
FROM #SampleAppointments sa1
CROSS APPLY(SELECT COUNT(*) Count
...
January 9, 2025 at 5:31 pm
SELECT T1.UNIT,
T1.DATE,
CASE WHEN COUNT(T1.PRICE) OVER (PARTITION BY T1.UNIT ORDER BY T1.DATE ROWS BETWEEN...
December 28, 2024 at 9:41 pm
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...
December 24, 2024 at 3:06 pm
Viewing 15 posts - 16 through 30 (of 2,645 total)