Below query will not run.
DBA has created a linked server to oracle server I am running query against.
First time trying to access Oracle tables from SQL.
USE [RMReports]
GO
/*****...
Hi experts:
I'm currently using SQL 2000. I have this table that looks like the following:
CODE Type BegDate EndDat
V70.0 2 01/01/2008 ...
I have a question regarding how to build a t-sql query.
I want to get a list of Products that is part of a given brand.
The problem is that I have two tables named 'Products' and 'Brand...
How do i get the required result from querying the two tables.
tblGroups
Group R Folder3
Group RW Folder1
Group R Folder2
Group RW Folder4
Group R Folder5
tblFolders
Fold...
Please see the attached displaying - 1. the current table data and - 2. the desired output.
This data is looking at clients, assessments undertaken on them, and answers given in these asses...
I have a stored Procedure that gives me the activity for a customer for a given time frame. It returns sperate variables for each field. ie.
Month Amount
Month2 Amount
Month3 Amount
etc,...
I have the following string:
Site3|Bag|N/A|00000|N/A|N/A
I am using | as a delimiter for these strings. I would like to extract: 00000
from the above string. I was using:
substri...
I need to run a query on a database table (let's call it TABLE1) to KEEP the LAST 4 characters for all values in the SSN field. How do I do this? Thanks.
Database: SQL Server 2000
I do a query but for every year of T2 I have not only one date
I would like to get the result for only the last date of every year
SELECT
DISTINCT T1.NAME,
T2.STATUT,
T2.APPLICATIONDA...
SQL statement for the advanced recordset in result page does not work in Coldfusion. No data is retrieved from database.
Please see attached codes for both the search and result pages
I am trying to update the format of dates stored within a table they are currently stored as:
2008-10-16
and I would like to convert it to:
16/10/2008
I am storing these as a nvarc...
Hello Experts,
I have an access database that I have inherited and looking for a little help. I have a simple select statement where I need to pull only the records from yesterday. The on...
Hello Experts,
I have a mysql database where date and time is stored in the dateline format (UNIX_TIMESTAMP). I need a sql query which should pull up the data entered between two given tim...
Hi Everyone,
I'm trying to delete records in one table with one criterion based in another table. In words: "delete record from "Scans" table if it is marked for delete and also it is not...
I have seen a ton of information on using the SQL BulkCopy Class to transfer data from Excel to SQL server but for the life of me I am just not getting it. I have tried to change the code that...
Hi, Is there a easy way to create a select statement that involves about 20 tables in a database? In table0 I want to select everything. Using the Id column in table0 I want to join that wit...
Good Day:
I am using SQL Server 2000. I am trying to write a stored procedure that updates the ExtendedPrice column based on calculations, but I get an error that reads: Incorrect syntax a...
Hi Experts,
i have graduate accountants training tables as follows
tblGradlAcctTrainingCategories (CatID(pk),Category)
tblGradAcctTrainingSubject(SubID(pk),Subject,CatID(fk))
tblEmployee...
I know how to do a multiple insert using a subquery:
INSERT INTO table1 (name, description)
(SELECT Name, Description FROM table2 WHERE Status = 1)
But my current situation is kind of w...
Hi Gents,
I basically have 3 tables in SQL.1->TagNamesTable,2->FloatTable,3->TagTable the scripts for these 3 tables are as follows:
1->
CREATE TABLE [dbo].[TagNamesTable] (
[TagName]...
I have posted this question in both the mysql forum and the mssql forum since this is a basic SQL question.
I have two tables: userinfo and moneytrans.
The userinfo contains (amongst oth...
This should be a simple question...
I am using UNION to join multiple tables with the same columns. At the end of the my UNION I am aliasing the whole thing as a tableX. After that I have a...
hi,
i am using this statement in oracle:
select a.PRODUCT_ID, a.PRODUCT_NAME, a.UNIT_PRICE, a.UNIT_TYPE, a.G_L_ACCOUNT, a.PRODUCT_ID_ACTIVE, b.DESCRIPTION_PRODUCT_GROUPS from PRODUCTS a, ...
Hi I am trying to update a field which has a fomat of '00000'.
When I update using this code:
a.version = TO_CHAR( a.version + 1, '00000')
I am getting for instance ' 00001'. P...
I need to modify this piece of VBA code to do something a lot simpler. For the selected record, write to a new field I created STATUS = '1' that I created in the [Cient List] table.
Public ...
