python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - sql-server

How to run series of values through stored procedure

I have a stored procedure that I need to run a list of values through and output into a temp table. This is the SP: EXEC [SP_ReturnHTML] @zoneid, 1 The first value, I assume, will be a variable and th...
test-img

jw11432

sql-server

stored-procedures

while-loop

database-cursor

Votes: 0

Answers: 1

Latest Answer

Something like this: drop table if exists #results drop table if exists #Data go create or alter procedure [SP_ReturnHTML] @value int, @s varchar(20) as begin select concat(' value=',@value, '; s ...
test-img

David Browne - Microsoft

In SQL How to choose two of three or more tables to join based on a condition?

I have a total of say 3 tables, but I am only interested in joining two of them based on a condition. There is a lot of Q&A on how to use Case Statements, but that's when tables are already define...
test-img

TarrotCarder

sql

sql-server

sql-server-2016

Votes: 0

Answers: 4

Latest Answer

You can left join all three and then select the non-null one using COALESCE(). For example: select p.*, coalesce(a.someinfo, b.someinfo, c.someinfo) as info from price p left join tablea a on a.pr...
test-img

The Impaler

SSIS Execute SQL Task continue execution after completion of Oracle stored procedure

I have an Oracle stored procedure I am trying to execute in SSIS Execute SQL Task. This stored procedure involves refreshing materialized views. For each and every step completion we are logging it in...
test-img

PK1128

sql-server

oracle

stored-procedures

ssis

Votes: 0

Answers: 1

Latest Answer

You can Debug your SSIS Package in Visual Studio to see what's going on. You will need "SQL Server Integration Services Project" software for this. You can install it from VS MarketPlace OR ...
test-img

Gaurav Shah

why I am getting error trying to add Foreign key to table

I Not able to add foreign key to tbl1 referencing tbl2 (Desc), here are the two tables : please notice Tbl1 includes all values,tbl2 Has more values that doesn't necessarily exists in tbl1 Error(Msg ...
test-img

Sha A

sql

sql-server

Votes: 0

Answers: 2

Latest Answer

you cant make Desc that at table tbl2 as a FK while it contains values not exists at the table tbl1
test-img

Omar Tammam

Posts

Questions

Blogs

Jobs