All Questions
Tagged with stored-procedures sql-server-2008
2,300 questions
0
votes
0
answers
176
views
How to use SQL Server stored procedures in React js express server
I have a page, I need to submit the data of that page into a SQL Server database table. There is already written the queries in the procedure. I need to use those queries in my server. How can I use ...
0
votes
1
answer
247
views
Stored procedure for table search without cycles or cursors
I have a view vwValues in my SQL Server 2008 database with these columns:
ExamObjID (uniqueidentifier)
Locus (varchar(10))
ValOrder (tinyint)
Value (varchar(5))
IndexType (char(1))
PersCount (tinyint))...
- 53
1
vote
0
answers
825
views
Do SQL Server temp tables live in memory even after the script finishes executing?
If I have a stored procedure that users are running constantly that creates temp tables and don't clear these temp tables at the end of the stored procedure, do these temp tables continue to exist and ...
- 705
0
votes
1
answer
50
views
Find which where clause is the most troublesome
Problem background
I am trying to pin down to what condition(s) are causing no records / rows the most, so to allow me to find the root cause of what data in the database might need scrubbing.
So for ...
- 743
1
vote
1
answer
527
views
In Case statement update date not greater than today date
Hi as per current statement i am updating the date in table as per below statement. I want to update the date that will be not more than today date. If the date will be more than today date then it ...
- 3,494
-2
votes
2
answers
454
views
Stored procedure expects parameter 'Incorrect syntax near ':'.'
I have the following stored procedure in SQL Server:
CREATE PROCEDURE [PROC_SET_BRN_RPT_STSTC]
@I_RPT_I varchar(max),
@I_MSTR_TBL varchar(max)
AS
BEGIN
DECLARE
@VD_PSTG_D ...
- 125
-1
votes
2
answers
1k
views
How to send true or false if there's data in child table in SQL Server?
I have 2 tables that are related (parent-child), if there's any attachment added there will be an entry in the child table. We are fetching data using a stored procedure. I want to return true or ...
- 107
0
votes
2
answers
56
views
Get null for DEFAULT SQL
I have a table with candidate details which insert base64 image as the profile picture. When I getting huge number of candidate list from the table the profile picture is taking too much space. I have ...
user15959877
-2
votes
1
answer
65
views
Procedure or function 'InsertUpdatePerson' expects parameter '@pr_name', which was not supplied
I got an error that comes from the database "Procedure or function 'InsertUpdatePerson' expects parameter '@pr_name', which was not supplied"
I've checked the stored procedure and I've found ...
0
votes
1
answer
64
views
How stored procedure output instead of rows count?
My stored procedure always returns 0. I tried unique data and duplicated but the insert is done with success but the return value is always the same @new_identity = 0
CREATE PROCEDURE [dbo].[...
- 15
0
votes
1
answer
81
views
query to Get sum of two different items that is mapped onto same code
I have this Inventory table for Rooms :
dtm
hotelid
roomcode
intqty
2000-01-04
23
svr
9
2000-01-04
23
ovb
9
this is my mapping table :
hotelid
roomcode1
roomcode2
externalroom
23
svr
ovb
023
I am ...
0
votes
1
answer
341
views
Convert rows to columns and sum with group by
I have a table with columns ID, WorkingDate and AmountReceived where data is show as
ID WorkingDate AmountReceived
-------------------------------------
1 13/April/2021 201999.01
2 ...
-2
votes
1
answer
51
views
Between clause not giving desired results in query
I need to return results from a mssql stored proc on the basis of datetime2. There's a employee table with punch in and punch out time. I need to return results all the data from an employee on the ...
- 1
0
votes
2
answers
150
views
How to remove conversion failed date / time error from SQL Server?
I wrote a procedure which is giving me this error
Msg 241, Level 16, State 1, Procedure SumByDay, Line 7 [Batch Start Line 36]
Conversion failed when converting date and/or time from character string....
1
vote
1
answer
1k
views
How to mock multiple rows in a SELECT in a stored procedure?
This might be a silly question but I have tried several things and can't obtain the result I want.
I am currently testing a very tiny API that consumes data from an SQL Server database. In order to ...
- 13