Problem Is there any way to optimize this stored procedure? Maybe something instead of so many joins? It takes some […]
Tag: stored-procedure
Update column based on input variable in stored procedure
Problem The purpose of the below code is to update a column based on the name of the field name […]
Optimize store proc performance being called in c# on array loop
Problem I have a c# application(mvc) that allows a user to upload an excel sheet containing an account number key […]
Find & Delete Duplicate Records on All Tables in current MSSQL Database
Problem The purpose of this code is to search the entire database for duplicate records and produce a script that […]
Get all company branches using stored procedure
Problem Am creating an application for a transportation company that will store information about their drivers, the cars they drive […]
Stored Procedure with many If Else if statement
Problem In this Stored procedure (called by this inventory-checking function), many if else if statement are used. How can it […]
Step 2: Creating functions the business tool will use
Problem I’ve been working on this project and here is my first function for step 2. I feel this is […]
Searching school data
Problem I am running a test load using Telerik Test Studio using 100 users at once entering search filters on […]
Stored procedure where column to ORDER BY depends on input parameters
Problem I’m getting three inputs and based on those three inputs, I’m returning. Input items may vary, so I used […]
MySQL procedure to extract a letter from a phrase
Problem Create a function called GETLYRICS, which will receive as parameters a word of at most 15 letters and a […]