Please refer to the screen captures below. I am trying to create a stored procedure in SQL Server 2014 that does the following: Sets the “Complete” BIT in the LAST record (e.g. row #1062) to TRUE Takes a the “DateTo” value from the LAST record (highlighted in yellow) and INSERTS it into the “DateFrom” column in a NEW row. That
Tag: stored-procedures
Token unkown error in stored procedure when updating on external database
I am using Firebird and I want to create a stored procedure to do an update in another database and I do not understand what I am missing because when compiling it gives me the following error: can’t format message 13:896 — message file C:WINDOWSfirebird.msg not found. Dynamic SQL Error. SQL error code = -104. Token unknown. suspend Answer The
Best way to find cancel and substitute match from the table
I have a table which has all order information. Id is the unique key for the table and it’s grouped by Order_Id (every order for the same product has the same Order_Id). The main thing is that if order is cancelled, it is recorded as a cancelled order (Cancelled? = True) and for following orders, it must have substitute orders.
T-SQL – Flagging Common Values in One Column Based on ID and updating the database
Problem Statement: There are Two Columns, VariableName and ID. I want to map variables in the same column with a two-character alpha code such as ‘aa’, ‘ab’, ‘ac’, ‘ad’…. up to ‘zz’ in T-SQL. To Illustrate, Input Data: Desired Output As you can see above, “var_1” , is present in ids 1, 2, 3, 4 and is tagged as ‘aa’
Didnt print on Procedure on SQL
So I try to print a message when I have any confirmation or error. I have this table [Friendship] that have the ID, friend mail, their mail and the date that have been confirm the friendship, Table without data When I use the EXEC for this PROCEDURE, I have the insert values, but not the print´s acctions… Also, If I
Dapper stopped pulling joined table after updating the table with a stored procedure
Because I was having this error InnerException = {“Cannot insert explicit value for identity column in table ‘Loan’ when IDENTITY_INSERT is set to OFF.”} So I decided to change it to this stored procedure. Which is inserting the record successfully, after inserting the page will redirect to the index page and call another method to pull the list and display
postgres procedure list of values
I’m trying to pass in a list of values into a Postgres 11 procedure. The query has an IN condition. How do I pass in a list of values to the procedure & then how do I use it in the query? create …
Incorrect number of arguments for PROCEDURE… from C#
I am having trouble using parameters in a stored procedure. I believe I am not passing the parameters in correctly with the C#. My code is roughly equivalent to: public static string GetCustomer(…
Calling Procedure with ‘call’ function from within P/L SQL Script Oracle
I am not able to run this simple if/then statement in oracle database. (i think it is 10.x but not sure, seems to be an issue of my sql skill not db version). Can you help me figure out how to run …
How can I add a row to my SQL results between each “category” change in the data?
I use SQL Server 2019 to produce a long list of shipping options. This list is produced by a simple query on a table containing the list items, and displayed on a handheld terminal. Users find it cumbersome and time-consuming to navigate the list to find the correct option, and must do so several times per day. What I want