I've adapted this piece of code below, I think its working, but the NewID and OldID strings are not operating in the update query SQL i.e. Access comes up with 'enter parameter values' for bo...
Hi ,
I got stuck again with some datetime conversion problem.What I am trying to do is this.I have the following SQL Querry:
select T.*,S.[Mean value trade]
From
(
Select Start,[Artic...
I am running a query against my order table and I need to find out what my customers' last order was.
For example.
ORDERID NAME ORDER DATE
1 John Smith ...
I need to "append" a column of Email addresses (EMAIL) from one table (Listserver) to another column (DESCRIPTION) in table (Activity) where only some rows (ACTIVITY_TYPE = 'EGROUP') from tabl...
I have an SQL statement that an Experts Exchange expert constructed for me that works perfectly allowing me to output a ranking order listing the ranking number, the user name for that ranking...
Hi experts,
I wanted to create a stored procedure using T-SQL. I couldn't find a lot of good sources for T-SQL that's probably why there are some syntax errors in my statement. Can someone ...
The question is very easy, I need to order the results by Lastdate. Lastdate being a subquery result, access doesn't like it on the ORDER BY clause, I have tried ORDER BY 1 DESC but access see...
I'm almost sure that the problem is with the punctuation of this statement, but I can't find it.
I've attached an image of the error message given. SQL/VBA is below.
I am getting the syntax error in creating the stored procedure.
I am using the T SQL in the sql server 2005
The sql server is showing that the error is comming on this line
"And + ...
I have the following code but it does nto work, I think it is something to do with the Round and sum functions inside the case clause.
SELECT
Case When @JobsInvoiceVatiD = 1 then
...
I currently use a where statement like: WHERE CallDate between '2006-01-01 00:00:00' and '2007-01-01 00:00:00' to pull records for a specific period of time. I'd like to be able to query for a...
Hi
I have a SQL question that I hope you can solve for me.
Consider the 3 tables below
table article
articleid name
== ====
a1 article1
a2 article2
a3 article3
table subsc...
Hi Experts,
I have two seperate views with exactly the same field names and data types. What I would like to do is create another view to consolidate the fields and data from the two seper...
How to determine Top X in an MS Access Query and sort from top down
Hi:
I'm new to SQL and am trying to create a query in a CF form. The database records contain information about various meeting rooms, including the size of the room, i.e., number of people ...
I'm trying to modify one of my triggers for a database or ranking information. Currently, any action in the table will set the date in the last update field. But I really only want the date ...
Hey Experts,
I am working on developing a query from 2 tables. The first table is Collector_Targets and the relevant fields are Code, Target, StartDate and EndDate. This table holds agent...
Looking for the syntax in SQL to remove all freespace and truncate your transaction logs.
I have a server that is using large amounts of I/O and SQL processes aren't releasing as they shoul...
My table A contains records with multiple entries of same ID (Attached Table A structure) also it contains modified date column as well.
Now i require a query to get only the latest modifie...
The top SQL statement in the code snippet below selects customer information and policy information for each customer in a database.
However there may be one than one policy for each custom...
Given the following Table:
Student LessonID TotalNumLessonsInSyllabus
--------------------------------------------------
Student1 C001 8
Student1 C002 ...
Hello,
I need help with a query involving 7 tables. I've attached a visual schema that I hope will help.
What I want to do is select all of the documents and display their associated data ...
Say i have a table as follows:
create table test (x date);
test
____
2008-10-20 15:15:15
2008-10-20 15:15:16
2008-10-20 15:15:17
2008-10-20 15:15:18
2008-10-20 15:15:35
2008-10-20...
I'm not sure what I'm doing wrong here.. I have these two queries and both return positive values in the 1k+ range on their own. The first returns a value of 1277 and the second returns a va...
i'd like to be able to order some data in a customised way. But i'm unsure of how to do this. It may be easier to explain the ordering required by looking at the attached:
1. current output...
