Here is another one.
Say i have three tables as detailed below.
Table1 has a timestamp and then two values.
Table2 has a foreign key and times of periods that im interested in, in...
Based on the Company_id I need to either Inner Join or skip an Inner Join (no join at all). If the Company_id is 999999999 I don't want to Inner Join to the Division table but if it is anythin...
suppose we have two tables as follows
DEPARTMENT
DEP_CODE,DEP_ PERIGR
------------------
100 ,EDP
200, MARKETING
300, SALES
400, PRODUCTION
EMPLOYEES
----------------
EMPL_CODE, ...
I am using the current query with a hardcoded date:
SELECT sStreetFullName
FROM `Residential_RESI`
WHERE `sListingDate` = '11/01/08'
How do I substitute the manually entered date with...
Hi!
I'm writing an application in VB.NET which operates data on SQL Server 2000.
One form reads data from a table. It has several checkboxes and two Date/Time pickup controls.
With the ...
Hello, I am attempting to create a stored procedure which is not working correctly. What I need it to do is to check if @UserCode is in a table and then check if either one of @RequestDomain,...
I would like to create a new empty table from an existing table structure.
I do not want to repeat the create table #tablename (col1, col2 ,....)
Also the existing table has a primary key,...
Here's the code:
SELECT armast.fcinvoice, armast.fcstatus, armast.flisprint, aritem.fitem,
aritem.fpartno, armast.fnumber, armast.fcsource, armast.fsono,
armast.finvtype, shmast.fshi...
I am currently using the following SQL statement thru MyPHPAdmin to update records in the table affiliates. How do I make this table perform the same operation on TableB and TableC without re...
What is the syntax for :
SELECT *
FROM dbo.[TableName]
WHERE (Status = 'NULL') If I want a view to show all records that have a NULL value in a specified field.
Thanks.
I have a database with over 40 tables. The PK's and FK's were originally defined as nchar(35) to be compatible with the GUID format of ColdFusion. The middleware for the project has now been...
Hi,
I have a query created in Access 2000 called qsel_SurveyDetails.
which returns a table. (see attachment)
I want to replace the ObjectRef column
With a column called ref_num from anoth...
this is a contiuation of a previous question (a couple actually) but i wil start fresh. i have an access databae with four tables in it. on table holds student information the other holds time...
Hello all. I am trying to write the code to append data to a table, however, there is some concatenation and formatting involved.
My issue is with the first piece of information. I am try...
I need to pull a weekly percentage data set from a MS Access database.
Currently I can easily pull the cumulative total, but I need to break it down by week and I cannot seem to do it.
I a...
In a MS Access 2003 query, I am trying to extract a two-digit month from a birth date field.
1) When I use DatePart('m', [birth_date]) it displays the month 1- 12. Months 1-9 are only o...
Hi, I don't know why I'm getting these syntax error. The tables and the columns are there and type correctly. But when I run the stored procedure, I get the folllowing error.
USE [CtsiMembe...
Is there any hashing in access linked table?
I mean..did the link table take data into access from ms sql.... ?
or it will directly connect to ms sql at runtime and manipulates data?
Okay, the title isn't very descriptive I know.
What I would like to do is select acct from Table1 where acct <> 5 and acct <> 4 AS 0
so basically, anything that is not 5 or 4 I want to s...
I have a make table query that pulls from a table that has records from 2004 to 2009. This make table query only pulls the records from 2007. I cannot find any year selection criteria and th...
Hello Folks: My brain is stuck in neutral this am. I want a count on one line the distinct number of values for a given field. The statement
SELECT groupidentifier, Count(groupidentifier) ...
I have a table that looks like the following:
PROG DATE PARTICIPATING LCTN_NUM
NHO 8/9/2009 True 003
NHO 9/1/2009 ...
I'm running a query similar to:
select addrid, addrline1, addrcity, addrstate, addrzip from address
where addrflag1 = 'Y' //mandatory
and addrflag2 = 'N' //mandatory
and addrflag3 = 'N' ...
Hi,
I have a table with the folowing structure
OrderDate Total Online
2/10/2007 1 Y
2/10/2007 1 N
Is it posible to convert it into the following in a single statement?
OrderDate On...
Hi,
i am trying to script the creation of a user and add it to a database like this:
declare @DbAttachName varchar(50);
SET @DbAttachName = 'test_script';
##USE @DbAttachName;##
CREAT...
