Hello,
This is a tricky one... Using only the prod_name hardcoded in the query - I am trying to display...
Prod_id prod_name PROVIDER CUSTOMERS
---------------------...
I am using a variable to capture the text that the user enters. This is used in the SQL per the appropriate field and works without issue unless; an apostrophe is used in the text. Example:...
I need help with this select distinct query:
SELECT DISTINCT
, Field1
, Field2
, Field3
, Field4
FROM SomeTable
The issue is that I want the distinct to appy only to Fie...
Good morning all,
I am trying to import data into Excel from an Access query. When I try to add the query via the Microsoft Query manager in Excel, I receive the following error “Undefined ...
I need to find the total (RTotal) of a specific value (Reimbursement) in a table. Everything works except that without line 7 i get the full total of all the values. With line 7 I get a return...
Hi, not sure if this is the correct category, but I want/would like to know how to create a where clause
whereby it selects values based on a 'range' or a 'set' of values.
I.e., say I have...
Hi,
Can you help me write up a sql to find and replace?
table1(id,trigraph)
table2(cid,digraph,trigraph)
I want to replace trigraph of table1 with the digraph.
Hello, I was wondering how I can modify the sql query I have below so that instead of setting @StatCode manully each time It would select all of the StatCodes in a table and complete the opera...
Hi,
The last half an hour has confirmed to me that I know so little when it comes to MySQL. I have been trying to update the value of a column (guest_account) in a table (customers) where ...
On the first day of every month we create a table of data for the previous month, I then join them in a union statement as below.
select etc
from out_jan08
where
union all
select...
This has to got to be so simple but I can't get it to work....
I am trying to update 2 fields per record based on the results of a query. I can run the query by itself and it returns the data...
I need an sql which works on MS-SQL and sqlite and does this::
update person SET pers_SecTerr = Comp_SecTerr FROM person join company on Pers_CompanyId = Comp_CompanyId WHERE COALESCE(pers_...
I am having issues with the following sql query in Microsoft Access.
SELECT ApptData.*, Procedures.ProcDescr
FROM Procedures
INNER JOIN ApptData ON Procedures.ProcKey = ApptData.ApptServ...
I have a web site with a membership table (id, lastname, firstname, dateregistered, etc.) and a sessions table (membership id, dateloggedin, etc.) which has a record for each date/time a membe...
I'm a total newbie to sql and my developer is not available. I need urgently to add certain fields of the address_book table to the code below, so I can export this information including the m...
Below is my select statement. I need to sum the three EST* columns, the the same for the thee ACT* columns, then create the difference. I must be missing something, I keep getting errors.
H...
I am trying to figure out how to group some results from a survey.
I have 4 tables: SurveyResults, SurveyAnswers, SurveyQuestions, and Users
SurveyResults
---------------
results_id
...
I would like to retrieve count of the rows in ScanPT table.
I wrote this query in Hibernate console and got the result 2.
When i use it in my Java code it throws me ERROR org.hibernate.hql...
Hi!
My Problem is that I need to update multiple rows of a table with only one query.
lets say i have a table like this:
------ Table: ranking ------
list_id | list_item_id | rating
...
Hi,
1. My tsql script is as follows:
use databasex
go
SELECT COUNT(*) AS Totals, SUM(DISTINCT VisitLength) AS Length
FROM ClientVisitLength
GROUP BY VisitLength
2. Af...
suppose we have two tables as follows
DEPARTMENT
DEP_CODE,DEP_ PERIGR
------------------
100 ,EDP
200, MARKETING
300, SALES
400, PRODUCTION
EMPLOYEES
----------------
EMPL_CODE, ...
Hi:
I'm writing some queries running on a database I created with MS ACCESS 2007.
I knew that ACCESS 2007 has some tools to help to build the query. However, I don't want to use the wiza...
HI
It is something similar to this i am trying to do
declare @query nvarchar(500) ,
@value int
set @query ='select count(*) from table_a'
i want to assign the count t...
DECLARE @x int
SET @x = (select map_x
from poledata
where cir1type like '%urd%')
DECLARE @y int
SET @y = (select map_y
from poledata
where cir1type like '%urd%')
select [name]
fro...
I am developing an application using Access as the front end and SQL Server as the back end database.
If I perform the following query, it executes successfully:
SELECT ztbl_Source_SSFII...
