I am trying to list the record count for all user tables in my database.
Here is an imperfectly formed query illustrating what I am trying to accomplish.
select OBJECT_NAME(object_id), c...
I have a stored procedure that will insert a user into our database...and then well costomize settings for him.
We realised after much fustration that our procedure was failing since the u...
Just a side comment as it was unusual syntax for me. I noted in the inline views used in the solution by ee_rlee on the related question, that they were brackets used with a period []. versus...
This issue seems to litter the net but I can't find an answer to my simple situation:
Using DAO in Access (ADO not referenced)
APscan is a simple table with an integer field Attempt
...
Hi,
I am using MSSQL 2000
In MS SQL I have to substring the middle integer from the string
For Example
If String is AS-00200-1
I want result as 200
If String is AS-00200-1
...
I have a table with 3 columns, FullName, FirstName and LastName
FullName is the only column with data as it includes a full name such as John Smith with the normal space between the first a...
Here is a basic example of what I have and am trying to do:
table1:
id desc price
1 some order 50
2 other order 50
table2:
id fieldnumber decfieldvalue ...
Experts: I need to find a way to force two decimal spaces in a SQL statement in Access. However, the results always displays whole number if there are no numbers to the right of the decimal ...
I'm running a VBScript that connects to an ODBC data source. The database, in this instance, is on a SQL 2000 server.
I have chosen to use ODBC and to execute an SQL command as I will be ru...
I have a Stored Procedure I'm trying to use to add records from an ASP.Net 2.0/VB webform into a SQL Server 2000 database.
This seems to be working (no errors so far):
cmdTest.Para...
I am executing a script that loops into my table, and I get this after around 10 minutes of waiting!
--------------------------------------------------------------
Server: Msg 9002, Level ...
Hi everyone,
Where can I download Brio Query Trial version?
Thank you
I currently have an access database with a query that I need to tweak. The existing query is:
SELECT ssUsers.custom1 AS Location, Sum(DateDiff("d",[CheckIn],[CheckOut])*[rooms]) AS ActualR...
Dear EE members,
I would like to convert req_date below as a date/time field to perform the folliowing function.
Now, this field declared as text data type.
Year([req_date]) & "/" & Format(...
This is my Sql statement which appears on a datareport in vb6. In the database, paymentmethodID is formatted as a number, yet it appears in the database as a string not a number. So when I ad...
I am trying to display a list of contact names for a drop down, but the first row of the result set needs to be a custom row. Is there a way you can maually "insert" a row into the result set...
I'm new to SQL and I have a copy of a production db in a test environment. I'd like to know how to create a temporary table of query results so I can link the new table to other db tables for...
To select random records, you can execute:
SELECT TOP 10 *
FROM Products
WHERE ProductName = 'bike'
ORDER BY NEWID()
Now, what I want to do is incorporate the above syntax in an upda...
hi
i am trying to update a columnZZZ in table a where columnZZZ in table b is not equal.
i am using this statement
update adr_accounts
Set
adr_accounts.is_new = '1', adr_accounts.a...
Okay, this should be easy, but I'm fearful of doing this wrong.
In the query below, I'm returning all the results from my table (shitem) that I want to delete.
I only want to delete the re...
I have the following fields in an Access Database called "Logs":
RecordID, Zip, DonorIDDate
I have this query to count, group, and display Unique records (Between 2 dates):
"SELECT Logs...
Hello,
MS Access
I have built a query part of which formats the date to its corresponding week number. The week number is a string and I need to convert it to an integer value in order t...
How would I obtain the year from the current date rather than forcing 2007 in the following view when I create it?
Thanks!
This is part of a larger solution where I need to create nested cursors to copy data about a site, it's pages, content regions associated with each page, the content of specific regions, and U...
Hi,
What do I need to do to the following Access code to convert to using SQL Server 2005?. I have got so far but am now stuck with the INSERT statement parameters & on adding the current...
