Question...
Tue, 6 Dec 2005 04:09:02 -0800
I want to do a "As" query in SQL. In Access, Query Designer, you can
specifiy in the criteria field something like:
Field name: From: DT_RDG_TO (so my field is called from)
[Reading Cons Detail - CU04TB36]![DT_RDG_TO]-[reading header -
cu04tb12]![qy_days_used]
How do I do this in SQL 2000? I have a ...
|
I'm not a SQL programmer but I need help please
Fri, 2 Dec 2005 10:48:02 -0800
Hello
Yes, I certainly am not a programmer. Access gives me enough of a headache.
What I'm after is some advice.
Me and my brother run a small business and we have decided to have a
database developed specifically for our business. The question is what do we
need? We have approached several companies of ...
|
query
Fri, 2 Dec 2005 01:38:03 -0800
hi
i have some models that end with +SP e.g. 1234+SP, abcd+SP I want to remove
only the +SP from these models. May i know how can i do it. Thank you
...
|
query
Wed, 30 Nov 2005 18:35:02 -0800
Hi,
I have some models that have hyhen in between. e.g.1200LD-VCD, abc-1234
May I know how to remove the hyhen.
Thank you
...
|
SQL HELP WITH LAST TIME ONLY
Mon, 28 Nov 2005 04:13:07 -0800
I have got a SQL query that get information from different databases,
I have all the information that I need but now I want the last information
I have three columns they are the following
Number
Durations
Date and time
I want to only select the last day and time from each records, at the moment
I ...
|
Time out problem
Fri, 25 Nov 2005 03:29:05 -0800
Time Out Problem
A single VB application links successfully to an SQL server. The
application calls simple procedures to query the database. After 30s these
queries timeout. If the timeout period is extended, all procedures return
successfully. What is going on?
Background info.
****** Processor ...
|
Merging mutliple rows from one table into columns in an other
Sat, 19 Nov 2005 09:48:02 -0800
Hello,
I have two tables. One is an export from a different database and one is the
destination table.
The Export table looks something like this:
EmpID = the ID of an employee
Contract = Code for the contract(s) the employee might have
MainContract = if -1 it's the main contract, else sub-contracts
...
|
|
|
Grouping by Distinct
Thu, 17 Nov 2005 05:26:05 -0800
Hi,
I have 2 columns of data, one has an Agent code and the other has
information about the Agent. There are duplicates of the Agent code in the
1st column, but different info in the second. For example:
Col 1 Col 2
Agent 1 Data 1
Agent 1 Data 2
Agent 1 Data 3
Agent 2 Da ...
|
Comparing Data between Tables
Wed, 16 Nov 2005 11:53:09 -0800
I messed up and now we have two tables that have slightly different
information. What is a query that would allow me to look at the data
differences between the two tables?
--
Ever Learning Net Admin ...
|
Post 1000 Message to Newsgroups Promoting my site and earn $100.00
Wed, 16 Nov 2005 16:47:15 +0000
Hello Posters !
I'm paying $100.00 to anyone who is willing to promote my site on the
newsgroups.
Start Promoting my site: http://www.dhosted.com http://www.dhosted.com . Today !!
Once you have done your 1000 posts email support@dhosted.com mailto:support@dhosted.com with the email address
you posted fr ...
|
