Hi,
There is an Access database in the network folder and an exact replica in the local drive. I want to be able to click a button in VB and have the local Access database update all the t...
Please tell me what this SQL statement does. Very detailed if possible thanks.
Hello. I have an insert query where i obtain the max number of a column and add 1 and then insert it into the table. I would also like to send that value out in a querystring, but i have not b...
I have used the following crosstab query as the record sourse for a form
TRANSFORM Count(tblHSERegionCrossTab.ROCID) AS CountOfROCID
SELECT tblHSE.HSE, tblHSERegion.HSERegion, tblComCareArea...
Hi Experts,
I'm using MS Access and Coldfusion to construct my page. I'm trying to select one random record from my query out of a table that I have. I need to know how to construct the SQL...
Hi,
I am using SQL Server 2000. One of the IT people installed SQL Server with only Windows as the authentication. We actually need SQL Server and Windows as the authentication. I tried t...
I need to rework a database design and populate multiple rows (aprox 10) for a new table called tblRegUsed that contains 2 columns
ProjID, RegID
(where RegID is a new lookup table (one side ...
Just trying create simple date reference temp table. They it is currently set up it is doubling each time the while statement is run.
I am trying to acheive:
ddtate
2007-01-01 00:00:00...
I have a sql query and need to display only the hours and minuets. I cannot work out how to only remove the seconds from the output. Thanks
dateadd(minute,DateDiff(minute,timein,timeout),...
In Excel I have data as follows and I would like to make this data show up as one row for each of the records utilizing the '=' as the indication of a new row. Some records have 4 lines, some...
i have a column that contains the first and last name, i need to split out the first and last name into two separate columns. anyone have an idea as to how within an access query?
I am using MS-SQL 2005.
I have two tables called 'SalesLeadsBoard' and 'SalesLeadsReply'
And colums below
SalesLeadsBoard SalesLeadsReply
---------------------- ...
What is the correct syntax for using an IF in a WHERE clause? I need something like
Where IF (A, B='PO', C='OS')
In this example "A" is a logical
B is an Order Type
C is a Status)
Here is the code:
select ID , Answer1 AS Answer
from yourTable
where ID=1
UNION
select ID , Answer2 AS Answer
from yourTable
where ID=1
UNION
select ID , Answer3 AS Answer
from ...
Hi
To simplify this question I have a view containing 9 columns
ID, CalcId,SequenceId,VariableType,From,To,ActualMins,ActualWeight, Rate
it contains 2 rows of data
1,1,1,MINUTES, 0...
Hello, I manually create a matrix using excel to dertermine what after school acitivity each week students signed up for and are are doing.
I have SQL server 2005 management studio express ...
I have a stored procedure with variables being sent to it such as dates, facility, employees, which are used in the final SELECT statement (See snippet). Sometimes an Employee or Facility is n...
I am creating a database to track verifications on welds. The user is free to enter welds in whatever order they would like as welds are not always verified in order. I would like a query that...
I have been working on simple database stuff.
Took the suggestions from here...
But wondering a little bit more about why.
*Indexes and Primary vs Unique*
From my reading, I have s...
Hi,
I have a table which has in this format:
Name Access
--------------------------
John areaA
John areaB
John areaC
Peter ...
hi,
i am in need of a query statement to run as a DTS to delete 6 month old data from a table (data) in mssql server?
i have a column (instime) with the insert date in it and it is define as...
I have a query that I need to do for a report and I can't seem to wrap my mind around how I am going to do it. If anyone could give me some pointers I would really appreciate it. I am using ...
Hello, I need to perform an update where I set the value to something like this:
dateone ~ datetwo
or
12/12/2008 ~ 12/14/2008
I'm converting the datetime into varchar and then attempting...
Hi,
I want to find if a variable has a particular value but i dont know the syntax, heres the sql code i have:
CREATE PROCEDURE usp_GetFilteredTimesheet
@clientID uniqueidentifier,
@Proj...
Hi everybody,
i'm stuck again with this SQL query.
I used to have this query where i would check the stock.
And compare it with our current pending orders from customers and get from th...
