Table 1 is the parent table. PK1 is primary key of the Table 1.
FK1 is the foreign key in Table 2
Table 1 and Table 2 are joined on PK1 = FK1
Table 2 does not have a row for each row of...
I am trying to run a simple query to update my table. Can someone tell me what syntaxt error I have here?
UPDATE tbl_Moscow
INNER JOIN tbl_adequacy_list ON tbl_Moscow.SPN = tbl_adequacy_l...
We have a reporting tool which lets us create a computed column in SQL server 2000.
I want the column to be Computer Column = Column A / Column B
Sounds simple, but I have the followi...
Any clues on how to query for the updated data on an Access database? I just need to know what data has changed....
Is there a standard query for this?
(I am using Visual Basic or C# for ...
I have a table messages in MS access that has the following fields:
parent, dateCreated,threadID, sort
I have a query:
SELECT Messages.parent, Messages.dateCreated,Messages.threadID...
I'm trying to split out our mailing address field into 4 separate fields using an update query: (PhysicalStreetNumber, PhysicalStreetDirection, PhysicalStreetName, PhysicalStreetType)
the 3...
I want to run a querry that will tell me all the clients who have not book lessons with us yet. I have a Bookings sub-table that keeps track of all the bookings that has a primary key of Boo...
Iam using Reporting Services with 3 tables joined :
I want to select the highest IRR_LVR date by loanid ie. For every loanid there are a number of dates
But I only require the highest date...
I have 3 tables:
---
Table: onlineimages
Fields: image_guid, image_pubdate, import_sort, image_description, image_user
---
Table: ImageTags
Fields: image_guid, tag_id, imagetags_id
--...
This is a follow up to a previous question (search on the question title).
Table 1: POWERON
HEATNUMBER BUCKETSEQUENCE CONSUMPTION
981011 1 ...
I have a query that goes:
SELECT *
FROM activities_misc
left join AttachmentLinks as b on B.object_id = activities_misc.act_misc_id
inner join Attachments on Attachments.attachment_I...
The below dumps out the following result:
'IIS Admin Service', 6
'Symantec AntiVirus', 11
What I would like to get is
'IIS Admin Service', 6,12
'Symantec AntiVirus', 11,12
That th...
Hi
Below is part of a query that checks between 2 dates. The problem is that the TO date is not included in the results (it brings back all events between the FROM date and one day BEFORE t...
I'm using Access2003 to develop a multilang program. I store the records as followes
ID,English,French,German, ....
To visualalise the records in a single language I use
Name: IIf([namesele...
I am looking for some input regarding a discussion I had with a coworker awhile back.
We have several tables in the database, but two of them are designed as such:
TABLE2 has a primary key...
I am looking for a shortcut if statement that will allow me to change the last line of this query to something whose pseudocode goes something like this.
a.sourceCreativeID = (if a.original ...
I am trying to create a trigger to update a another field. My problem is I can't discover how to join the 3 related tables together. Simply the three tables are
sdsprp.bidstatus (which is...
I have created a SSRS Report which takes the following parameters:
RepID, NotNetworkEligibleDate, ProductType, ProductSponsor.
What I need is a stored procedure where the RepId will take in ...
Long time listener, first time caller. I'm currently building a stored procedure to locate a known field in SQL Server 2k. The approach I'm taking is an X,Y location for a field. It's a static...
Hi Experts,
Can anyone tell what' wrong with this statement?
select @MyXMLString = @MyXMLString +
'<Row><'AccountNumber >'+ AccountNumber +
...
I am clearly missing why these statements do not work. i would very much like 2 things
1. an explanation why
2. best practice for doing something like this.
I am strying to cast an integer to a string while adding fields together, but my syntax whatever I change to never seems to work. I am tryign to add in s.streintAsgnstr which I have to sum f...
I want to create a table that consists of one column (integer) with 500 rows, starting from 1 to 500. See below.
Is there an insert into statement which can insert all of these values autom...
Unfortunately the original Database Admins decided to store a peoplesoft id inside of the "ProcName" column. In order to get it out, I need to perform the substring listed. I can do so, and it...
I am working in reporting services SSRS 2005. I have a query which i need to be merged to the main query. I don't know as how to achieve this. Please advice as how to go about it...
