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 - database-cursor

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

Need to match ClockIn with Clock out, multiple clocks on same day SQL

I'm trying to get the clock in and clock out times to correspond to each other so that I can calculate hours worked/amount of breaks/time worked within working hours etc. I have a 'Clocking' table tha...
test-img

Jarryd vn

sql-server

join

inner-join

database-cursor

Votes: 0

Answers: 2

Latest Answer

You can do this in a single scan of the base table, and no joins, by using window functions: WITH NextValues AS ( SELECT *, NextClockOut = LEAD(CASE WHEN c.ActivityID = 2 THEN c.Clock_Time E...
test-img

Charlieface

Different results when using a CURSOR and direct SQL execute? - PL/SQL

While debugging, I came across a strange situation today with a query that has a join condition on a column that could be NULL. I have data in two tables like this: emp_payment_trans_tab: emp_payment...
test-img

Uthpala Dl

oracle

plsql

plsqldeveloper

database-cursor

Votes: 0

Answers: 1

Latest Answer

To me, it seems that you're misinterpreting reality, because BOTH SQL and PL/SQL option return nothing. SQL: SQL> SELECT emp_no, payment_date, expense_id, a.company_id 2 FROM emp_payment_t...
test-img

Littlefoot

Hide Custom Cursor on mobile

I have the following code for a custom cursor. I am trying to hide the cursor on mobile, but I don't know which code I need to use and where I need to paste it. Can someone help me? Thank you! <d...
test-img

HunterD

javascript

css

database-cursor

Votes: 0

Answers: 1

Latest Answer

Just set display: 'none' for the cursor element @media only screen and (max-width: 700px) { body .cursor { display: 'none' } }
test-img

kameHame HA

Posts

Questions

Blogs

Jobs