Viewing 15 posts - 1 through 15 (of 595 total)
Ahh great catch Jeffery! Much thanks!!
February 5, 2024 at 9:51 pm
ahh persisted...hmm its not used that much so maybe overkill for this.
I like the two left joins - trying that now.
Thanks Phil - appreciate the help!
February 5, 2024 at 5:12 pm
Kinda yeah - feel my pain
I know there is a translate function that can sometimes be used in place of 'replace' but I'm on v120. So no easy way out...
February 5, 2024 at 4:19 pm
Yeah I tried the try cast - didn't work.
I just removed the formatting - fine for now.
Thanks guys!
January 19, 2024 at 12:55 pm
this works - but I loose the formatting
SELECT
DISTINCT
provTaxID
,provNPI
,provName
,provShortName
,'https://npiregistry.cms.hhs.gov/registry/provider-view/' + provNPI BillProvURL_NPPES
...
January 18, 2024 at 10:11 pm
I think I just may be stuck with "it is what it is" - I know its a ton of records. Really just wanted to make sure I tried everything...
January 5, 2024 at 3:50 pm
Sure, logical assumption and my fault for not specifying
It returned in same time..
January 4, 2024 at 9:15 pm
Thanks Jonathon.
Thanks Brian - yeah that table gets massive inserts and updates so I guess indexed view is a bad option.
Tried using exists - same run time:
select...
January 4, 2024 at 6:15 pm
Trying to index the view
--Set the options to support indexed views.
SET NUMERIC_ROUNDABORT OFF;
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,
QUOTED_IDENTIFIER, ANSI_NULLS ON;
--Create view with SCHEMABINDING.
IF OBJECT_ID ('dbo.FastEligibilityView',...
January 4, 2024 at 3:41 pm
Jeff
the query is the slow part of a larger process.its not being posted to a screen - query is part of universe of claims process that needs to look at...
January 4, 2024 at 12:34 pm
Thanks!
December 14, 2023 at 5:52 pm
Thanks Ant-Green. Kinda figured that.
I have an A,B servers. Sys admins want to move the B server to the new location on one weekend and server A the following weekend.
Assuming...
December 13, 2023 at 7:32 pm
*UPDATE*
Thank you all so much for taking the time to help with this issue.
It turned out to be a trigger that gets installed by default now in dbwarden. Once I disabled...
October 13, 2023 at 9:46 pm
SO...still working on this nightmare..
I found that if I run this in master:
SELECT *
FROM sys.sql_modules
WHERE definition like '%usp_drop_temp_ingenix_codes%'
On the broke server I get these two records:
538484997 CREATE PROCEDURE [dbo].[usp_drop_temp_ingenix_codes] AS...
October 12, 2023 at 4:19 pm
yeah guess they figure it works on all our other servers - the good old we dont know either must be permissions reply..
which i cant understand...feels like I'm missing something...
October 5, 2023 at 4:35 pm
Viewing 15 posts - 1 through 15 (of 595 total)