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...
Hi Guys, I am converting Access SQL to SQL Server and I have two problems:
First of all I cant get the city, state and zip to concatenate. It will not take the "As Location" and it will not...
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 am using the following query to create a temp table based off a query. However, I keep getitng an error message that I can't seem to resolve. Can anyone advise?
Here is the query:
CR...
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 ...
Hello,
I am trying to use XIRR function from excel in Access vba.
I have this code
Option Compare Database
Private Sub Command6_Click()
Dim obj As Excel.Application
Dim sql As String...
hello there
i want to get the current date and then subtract minutes from it.how can i do this in sql server 7.my query is below .i want to put the subtracted date in place of '2007-07-12' ...
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 new to SQL triggers, and need to write one for when a new record is added to a table.
I have two tables, say, TableA and TableB. The trigger will be on TableB.
When a new record ...
I'm trying to find a way to to migrate data that is in a DB already (MS Acces, although I can import it into SQL) in a different form. There is a name field that holds one or more names ins...
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...
How would I obtain the year from the current date rather than forcing 2007 in the following view when I create it?
Thanks!
Hi, the date I need to perform a DateAdd on is a string date and needs to be converted. I tried using CAST but recieved an err msg:
Conversion failed when converting datetime from character s...
Hello!
About my environment:
I have a hosted web database that I don't have access to other than with classic ASP and an ODBC connection that thankfully gives me both read and write access...
Hello,
I have two tables showing inventory movement transactions across a network. Table 1 (tblSent) contains date, job no and a count of the part numbers associated with the job no. Table ...
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...
I'm looking for an SQL query that will determine Unique records and Count how many of each there are.
For example:
I have a table with the following information in the 'State' field:
...
I want to write a SQL Server stored procedure which will:
1) use IF EXISTS to check whether a set of parameters to be added will be unique
2) if the parameters are unique, perform an insert,...
How can i convert UTC timestamp to GMT in php?
I have a MySQL field that saves the time with UTC_TIMESTAMP() in the INSERT command. When I pull up the record, how can i convert that time t...
I want to update the values in one table based on the city they are in which is located in another table. When I try to join the tables in my update command I get the following error message:...
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...
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...
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...
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 have a select statement in access shown in the snippet,
how do i add no lock
