Dear Experts,
Please help me.
I need to create a stored procedure which takes one input parameter.
Then return all rows where equal to input parameter.
Loop the results while adding a ce...
Hello,
I am still very new to Access so this question may be simple. I have a very basic query to select the top 5 records from a table - select top 5 drops from tbl_drops; This works great...
I keep getting the error:
Server: Msg 241, Level 16, State 1, Line 152
Syntax error converting datetime from character string.
Experts,
I have a PO_Detail table with an AutoNumber PK, data type Long Integer.
My select statement starts with Table B and I need to join table PO_Detail.
The problem is this my for...
Ok I am having a bit of a problem here. I have the following syntax that does not work:
select ponumber, postatus, potype, user2ent, docdate, vendorid, vendname, buyerid from pop10100
wh...
I'm trying to develop a CASE statement but I can't get it right. I want to evaluate the following SELECT statement:
SELECT `rate` FROM `rates` WHERE `project` = 105 AND `category` = 'JrPart...
I have two tables in an Access database with the following fields:
Files
====
File_Num
Active
Statements
=========
File_Num
Credit
Debit
They are both linked by the File_Num fi...
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 filter a DataGridView using a filter based on the text entered into a Text Box. The SQL Server Query looks like
SELECT *
FROM <TableName>
WHERE (<Tabl...
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...
Ok I'm building a query to create a view in SQL server 2005 for work. One of the columns of the view is a simple 0/1 answer.
0 = the user in this record, has no records in TableB
1 = the u...
Hi All,
I have a datatype float in sql server for the field Hours which i need to get from the client side. I get the value in the textbox like this
double Hours = Convert.ToDouble(txtHour...
Hi, I have a datatype of DateTime.
I want to parse out parts of the value to build my custom string, e.g.
cast(datepart(dd, BeginTime) as char(2)) + '/' + cast(datepart(mm, BeginTime) as c...
I have a question in concerns with counting rows. I have two tables
table1
CaseID, UserID, CaseTitle, CaseDescription
Table2
ID, CaseID, CaseNotes
How can I create a stored procedu...
How should we use the single quotes, double quotes while building the dynamic SQL having some contants, some keyword and some directory path.
Hi,
In SQL Server I can write a query which will return all records x amount of days from today date using the code below.
dbo.cart.Creation_Date > GETDATE() - 3
Is the an equivenlt i...
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...
I want to create the same table from another table in my database. How do I write a sql statement to do a duplication of the table structure???
I have to identical (same structure) SQL 2000 tables in two different databases. I need to copy a data from one table to another.
Source Table:
ID Name ...
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(...
I am running SQL 2k SP4. Here's a sample query of what I'm trying to accomplish. It is simplified to highlight the specific issue:
SELECT PN.*
FROM FD__PROGRESS_NOTE PN
LEFT JOIN T4W_SI...
I am trying to use the case statement in my select query. I have two columns in my table as follows:
1. Product name
2. retail price.
What i would like to do is that if the product name st...
MS Access 2003
I need help with my syntax.
IIF([district1] is null, like "*" or NZ([district]), [district1])
This is my criteria, [district1] is undefined and gives a msgbox(think that...
I have one table I need to pull a record from per id. Each ID can be shown mulitiple times with new pricing and update dates. I need to pull the record with the last update per ID. Thoughts? I...
We are trying to find a SQL command that will help us find the table structure of a database. We are talking about 200+ tables on a database. We will be converting from SQL Server to Oracle.
