37,211 questions
0
votes
0
answers
35
views
The module being executed is not trusted - for procedure "with execute as" clause
I have a stored procedure in a database OmegaCoreAudit that queries the master.sys.fn_get_audit_file records and stores them to a table in the same database.
The owner of this database is login ...
- 369
0
votes
0
answers
33
views
Why am I receiving this empty xmlns?
I'm switching over a BizTalk port from adapter 'SQL' to 'WCF-SQL' due to the former being removed from the next version of BizTalk, I can receive the message from the stored procedure fine, except for ...
- 17
0
votes
1
answer
74
views
Call stored procedure in separate session in SQL Server
I tried calling a SQL Server stored procedure in another session.
This is my code:
CREATE PROCEDURE [dbo].[CI_AdHoc_PrepareJob]
(
@JobName NVARCHAR(50),
@StepName NVARCHAR(50),
@Value ...
- 1,416
-2
votes
0
answers
35
views
I want to create a task which will be calling a procedure and the procedure will be calling a scala file on snowflake [closed]
I want to make a Snowflake task which will call a procedure and the procedure will be calling the Scala file. Please refer the below diagram:
+--------------------+
| Snowflake Task |
|------------...
0
votes
1
answer
58
views
Iseries, acs and external stored procedures. So where's my LDA?
On our Iseries machine we have a routine which returns some information regarding the status of a third party package, it tells us if it's up or down (it's Sage if you're really interested)
I've ...
- 1
-1
votes
2
answers
36
views
snowflake bind variable not set . while i am passing it through proc argument
Here is my code-
CREATE OR REPLACE PROCEDURE some_proc_name("LOAD_MONTH" INTEGER, "LOAD_YEAR" INTEGER)
RETURNS VARCHAR(16777216)
LANGUAGE SQL
EXECUTE AS CALLER
AS declare
...
- 380
-2
votes
1
answer
59
views
I have a stored procedure that compares separated values to the values in the columns from a table but how do you return the entity [duplicate]
I have a stored procedure that compares text values in a table:
ALTER PROCEDURE [dbo].[getThreadsBySearchTerm]
@searchTerm nvarchar(80)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @pos INT
...
- 2,353
0
votes
3
answers
113
views
Getting duplicate rows when using temp table and inner joins
I have a temp table and inserts the search term inside the temp table that has a search term of split spaces, but when I query the SQL the rows are duplicated because of how many rows are in the temp ...
- 2,353
-3
votes
0
answers
30
views
How can you return the number of rows from a temp table [duplicate]
I have a temp table which inserts values from a split of white spaces, what i need is a way to say if temp table has more than 1 row, then execute the code else execute different part of code:
ALTER ...
- 2,353
1
vote
1
answer
82
views
Comparing a search term that contains more than one word and searches different variations for the search term and pulls out records
If I have a search term that equals "Hello Connor Mcgregor", then how would I use this search term so that the search term loops each search word in the list for example:
searchTerm[0] = &...
- 2,353
1
vote
0
answers
18
views
SQLCMD executing sp_help_jobhistory via XP_CMDSHELL and trying to write results to table
When I run the command, I get Column name or number of supplied values does not match table definition.
The output from sp_help_jobhistory returns 11 columns which I have defined in my table.
Here is ...
- 11
0
votes
1
answer
72
views
Fetch data from EntraID into SQL MI table
We have a Azure environment and a SQL MI instance (with SSMS) and a Azure AD (EntraID) that is handled by the security team at our company.
Today we are reading Active Directory data via SQL Server ...
- 514
-1
votes
1
answer
40
views
Pull out Descriptions as Variables
I have a table that has fields for table name, field name, and descriptions of those fields.
I want to assign the descriptions for fields of a specific table to variables for use in a stored procedure....
0
votes
1
answer
38
views
Snowflake stored procedure creation from Airflow
Problem: I'm unable to create a stored procedure in Snowflake via Airflow.
Description: I want to create a Snowflake stored procedure via Airflow.
Here is the sample code:
CREATE OR REPLACE PROCEDURE ...
0
votes
0
answers
32
views
Call SQL stored procedure using python -> Previous SQL was not a query [duplicate]
I'm trying to call the stored procedure using the python.
Background: I retrieve the doc_id which I need to pass to stored procedure which is varbinary value. I had the issue where my string doc_id ...
