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 other
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 guide.
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 wouldn’t know the values to search
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. How can I insert values
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 rewriting it in the code. Is it
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([…