I am trying to update a date field in one table with a date field from another table. I have started to write the script however I don't seem to be getting anywhere. So I need some expert advi...
Hi
Is there an option to identify the row created time in sql? I dont have any date time field in the table but would like to return all rows from the table with the time the row was inserte...
I have the following function that simply returns a number of hyphens equal to the argument length passed in to the function. However, it only returns one hyphen.
Hi,
I'm creating an SQL Query that cobbles together information from various tables. Everything is working fine and as expected, except for one of my columns.
In the last column I am perfo...
Hello,
This is my SQL database engine :
http://www.h2database.com/html/frame.html
Which SQL code to make a quotes 5 mns time frame table from a 1 mn
time frame table ?
I have alrea...
I am having a problem with one of my SQL queries. I am using MS Access to build and test the query. When I run it, I am returned an empty table.
The purpose of the query is to:
1. Find t...
Hello,
I have a table in MySQL and a table in MSSQL. all the records in both tables have an email adress field. i want to update the MySQL table with the MsSql table.
I have this query r...
Hello,
I'm using ASP and MS Access.
I would like to retrieve value from same field name with different table.
I have tables called Categories and Items
Both tables contain field name ca...
I have attached a code snippet of the ASP page I'm working on.
The problem I have is that it seems to return more than one entry for each company that matches!
I have tried placing a 'DI...
I am writing a Top 10 orders of the year dashboard and obviously want to limit the results to the top 10 orders. Below is my sql statement...how to I only return the first 10 desc values?
I have a table that calculates charges for partial service periods. There have been some calculation issues so I'd like to double check the values in the table for the year. I have no idea h...
Hi i have two SQL Queries but i wanna combine the both queries
1.Query
SELECT TOP (100) PERCENT MONTH(KayitTarihi) AS Month, COUNT(KayitTarihi) AS [Total Customer]
FROM dbo.tb...
I am retrieving a string from a recordset based on locaiton name. I am using this string as an img src for either a google map or a stored image. The page does not display the image, just a ...
How to display row value of each class as a column value
ID NAME CLASS HOURS SCHOOLNAME
1 Allen Maths 12 school1
2 Sam Maths 12 school1
4 Pam Maths 10 school1
3 Sam Comp 10 school...
I have the following database setup:
Table: invoices
-----------------------
id - int
amount - int
Table: payments
----------------------
id - int
invoice_id - int
amount - int
...
MYSQL
Mind to show me some example on How to create simple FUNCTION SQL and DO FUNCTION CALL and show result if can
Also can you explain abit why we need to use FUNCTION SQL?
I have a table that logs Archive/Restore transactions. I'm need help creating a query that will give
me a list showing one record per machine w/ the last transaction that occurred for that ma...
I have a query that returns 3 rows for each person in the query. I need to get the value of pldate in the middle row. my problem is it is not the top1 when sorted desc or asc so how can I ge...
can you tell me what will be the syntax for this query then access database is the source .
in other words this is a SQL syntax can you convery into access syntax ?
UPDATE t_q_brkdwn
SET...
I want to make an sql query from two tables, and I dont want double values from certain field in certain table.
This is my query:
each user has several files
each file has several commen...
I have an asp:AccessDataSource which selects some data on gift certificates. I need to sum the applied certificates from one table, but don't want to use aggregate functions on the other, so ...
I am trying to pull data from a SQL Server 2000 DB table into an Access DB table but I keep getting one syntax error iafter another. I'm only a beginner in SQL and I've been using books to ge...
Hello Experts,
I am trying to calculate an average. I want to group the average by store.
I currently have each store in a separate table. (normalization issues aside for now)
I wan...
I have a table tb_nmp_ascii_h which has columns metric_month, metric_num, clec_id and tperm_score
Another table is tb_nmp_ascii_prod which has the same columns.
I need to update tperm_scor...
In SQL I have string similar to
6,6,15,28,15,28,28,28,28,28,28,28,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,27,27,27,27,27,23,55,98,98,98,98,98,98,98,98,61,23,23,24,24,24,24
I...
