I don’t know how to easily explain what i need to do but i’ll try. Lets say i have a user table with 5 users. instead of just do a select * from users i need to do this different and more difficult. I need to build a query that for each row in users table runs a query with
Tag: parameters
MS Access – Selecting which table to merge
Is there a way to choose which table do I merge using SQL in MS Access through entering parameter value? Let’s say I have 3 tables: Users, 2021 and 2022. Any my query is: I get “Enter Parameter Value” window to filter the code that I want to check, but I would like to get the same to choose …
Create a JSON object to be sent as parameter to Stored Procedure
I have a stored proc say sp_proc_1 which takes in a few parameters say @val1, @val2, and @val3. I would like to make a JSON object using the values @val1 and @val2 so that I can pass that JSON object as one of the parameters to a second stored procedure sp_proc2 which I will be invoking from sp_proc1. Please …
Search SQL database with multiple filters
I have the following code: This gives me the rows where “category_id” is equal to the 1. I now want the SELECT statement to return rows where the “category_id” is equal to one of the values I give it. So a simple SELECT statement would look something like this The problem is that I wou…
Call tabled function with parameters in sql
I’m a newbie in SQL and with programming languages in general. I’m trying to make a tabled function in SQL (SQL Server): and then I have to call it in another sql page. I’ve tried to use this syntax: If I run my SELECT I don’t have any result, because my parameters are not initialized.…
VBA 3131 error in SQL using variables in query
Can you please help me? I was trying to figure it out for about 2 hours but I still have some error in the syntax. I have the following code with String variables which I need to pass into the SQL …
How to bybass sql injection error in Javascript
I am getting sql injection error while trying to run the below code in javascript. I am trying to see a way to update this using parameter or some place holders to bybass the injection error but I am …
What is the simplest way to put pass an array of values into a parameter of TVF
Objective: I would like to have a parameter in my function to allow the user to input a list of values. Ideally, the simplest solution … Note: I dont have permissions to create tables in dbs. …
Can I bookmark SQL query with bind parameter?
I’m quite new to databases. I’m using phpmyadmin and I’m writing just simple SQL queries. I’m curious if I can bookmark a query with bind parameter so I could set the parameter next time again. I have the following query and I want to set myID every time I run the query without rewriti…
Stop Access from asking for parameters in Query
Access keeps asking for parameters qTtlSalesbyParent!SumOfSales My query SELECT tblCMAP.Parent, Sum(tblCMAP.Sales) AS SumOfSales, IIf(Nz([qTtlSalesbyParent]!SumOfSales],0)>=1000,20, IIf([…