I have a table called 'tags' with id (integer auto-increment) and title varchar(200). Other tables reference these tags through a foreign key that...

Matt Jimison

11-27-2007 09:42 AM
Matt Jimison

You do not say which vendor the SQL database is from but you could try I assume you don't are which emplicensecode value is returned Here are 2...

undercups

06-12-2007 05:32 AM
undercups

hi all, I am using the PSQL in that how can i change the database user name... Is it possible. I am already having some tables in the database, there...

sathiya_psql

09-13-2006 12:16 AM
sathiya_psql

Can anyone provide me with pointers on how to create a trigger for a university course db where students may not enrol for more than 180 points at...

Nick

09-11-2006 04:30 PM
Nick

I have a couple of scripts (on seperate files) that needs to be run on sql server (create or alter tables, create views, insert or update data, etc)...

AT

08-03-2006 04:04 AM
Jack Vamvas

Hello , Could you tell me how to create a hash table in oracle. do we need to use sql or plsql. can anyone explain me with example. - Thanks in...

AT

07-28-2006 02:35 AM
AT

Hi looking for some help I am trying to move some software, this software uses msde2000 and I was thinking how difficult can it be to install....

brian

07-11-2006 03:41 PM
brian

Is there a way to kick off something similar to bgp from a unix script? I have this script that has compiled data from various unix machines, now...

AT

07-03-2006 05:36 PM
AT

Dear Friends, I am using following query to get result form MySQL SELECT COUNT(ID) AS TotalOrder, SUM(Amount) AS TotalPrice, Time FROM orders WHERE...

AT

07-03-2006 02:12 AM
AT

Hi Everyone, I want to get the second row of the table. is it possible to get that through a query. For example I have a table Table A col1 col2...

AT

06-26-2006 09:11 AM
AT

Hi, I have table that has two int values, one called "home" and one "away". These int values refer to a primary key in table "team" which has...

AT

06-14-2006 01:35 AM
AT

Hi Everybody. May I draw your attention to our new SQL database, which can be used both as Distributed client/server and as an embedded database. We...

AT

05-31-2006 06:40 AM
AT

Hello guys, I have one question about mapping table: I would like to a mapping table between this 2 database table1/database1 (id ClientCode age

ina

05-02-2006 09:25 AM
ina

Hi friends I have a small query on joins For Example I have EMP_ID in TABLE A EMP_NAME in TABLE B EMP_DESIGNATION in TABLE C EMP_SALARY in TABLE...

v_dinesh1982

03-12-2006 05:05 AM
undercups

Hi Everyone, i have two tables in the database . One is called address table and one is adressPhone Table. Below is the sample of those two...

vinki05

03-11-2006 06:08 PM
undercups

How To Copy Tables Across Servers? Hi, We got a production database that gets tables added to it daily. So, every single day we transfer those...

sqlny1

03-08-2006 12:27 PM
CASTILLO Esteban INGDESI

Hi Friends, Please help me out with a optimized query for the following as soon as possible with in today.Thanks in advance. Employee Table Eno 4...

subi_04

01-18-2006 01:22 AM
subi_04

Damn, it has sure been a while... I just realized today that it's been 18 months since I went out with a special lady last, but I'm pretty happy to...

belle.gobble5355@wbcdefg.com

01-16-2006 09:00 AM
belle.gobble5355@wbcdefg.com

New to the SQL environment... need some help Is there are way i can extract the Job Number and activity when i start a SQL script? Thanks

aquaflow

01-10-2006 03:02 PM
aquaflow

Hi All, I have an employee table: id name hiredate My question is how I would find all the people that were hired within the current year?

kchan_bs

01-08-2006 09:32 AM
undercups

In ACCESS they have a nice utility for analyzing the schema called "Documenter." It gets you all the pertinent information you need to evaluate the...

raysgoogle

12-06-2005 09:24 PM
rbedick@yahoo.com

Hi all, I encountered this small problem I have two tables A and B with two columns 1 and 2 each, I would like the first column of each table when...

alomrani@gmail.com

11-29-2005 02:26 AM
alomrani@gmail.com

try this EXEC sp_MSforeachtable @Command1 =" sp_SpaceUsed '?' " --- sqlny1 <sqlny1 (AT) yahoo (DOT) com> wrote:

aneesh

11-15-2005 10:19 PM
aneesh

figured it out !!!!!!!!!!!!!! (select SP.po_nbr,max(SP.act_shp_date) as ship_date from bigcdb_shipments sp group by sp.po_nbr) SP

relaxies1

10-20-2005 05:35 AM
relaxies1

HI all, I need to write a query to return the most recent dated record only. For example i have an order number many times but only want the...

relaxies1

10-19-2005 04:26 AM
relaxies1

Hi Friends, I am looking for some basic software to run it in WIN based system and communicates to UNIX-Server via TCP/IP and gets the SQL script...

S.Sunil Kumar

10-13-2005 01:17 PM
S.Sunil Kumar

Dear Group - Any expertise appreciated here. I'm trying to select a database product for an application and need to know a few things - any replies...

jm

10-11-2005 07:29 AM
jm

Hi everybody, I has an access database that I export to SQL Server, but I have a problem with Autonumeric columns, which in SQL Server I don’t know...

Miguel Sanchez

10-07-2005 01:50 AM
Miguel Sanchez

Have a customer name, need to find the orders he placed, and the line items of the orders? You need to enter 3 queries: select * from customer where...

baybreezesoft

10-06-2005 11:29 PM
baybreezesoft

I just restored a db backup on my sql server 2000 and now I cannot add new database users to any database, I just get "Error 0:". Anyone know what...

Snake

10-04-2005 11:33 AM
Snake

Topics sounds confusing, right? Welcome to my world! Here's an example. I have a database of phone numbers, such as this: table: members field:...

Kevin Blount

10-03-2005 08:18 AM
Kevin Blount

kamran Look at using XML. Your application can build an XML document with multiple instances of the rows you want to insert/update and that can be...

undercups

10-02-2005 06:44 AM
undercups

I have the following Query. Unfortunately the DB has a PROJ_ID = 0 that is not in the REPORTPM.PROJECT table. How do I write the query to include...

j_ferree@yahoo.com

09-17-2005 12:29 PM
undercups

Hello friends, Sir/Madam, I would like to know whether the values in the table will be changed if we alter the views...... thanks in...

vsphanindra

08-16-2005 08:27 AM
vsphanindra

Has anyone implemented replication at their job and if so can I get=20 your contact info. Thank you ------------------------ Yahoo! Groups...

biirir

08-16-2005 08:21 AM
biirir

Hi everyone, I have a SQL server 2000 DB and I need to keep track of prices. However, whenever I have a decimal the db truncates the decimal making...

Andrew Caldwell

08-16-2005 08:08 AM
Andrew Caldwell

Hi, I am VERY new to SQL and I do not know if I am word this question=20 correctly, so forgive me. I would like to create a new table that does...

Hasana Monique

08-15-2005 07:54 PM
Hasana Monique

Please check out my new paper concerning how to implement a framework=20 for Data...

geoffrey_slinker

08-08-2005 11:59 AM
unites@vigill.com

I'm not sure I'm going to be able to explain this clearly but hopefully someone can give me a suggestion on how to proceed. I have 701 values that...

zoobs72

07-31-2005 11:53 PM
zoobs72

I have the following table: id ca cb 1 A B 1 C D 2 O P 2 Q R And I want the following result:

CASTILLO Esteban INGDESI

07-29-2005 02:27 PM
undercups

Hi, I search to convert Hex values to String and INSERT in my Database ? INSERT INTO PAYS CODE values (0x37); My input is an hex values and not a...

pcouas@infodev.fr

07-18-2005 04:24 AM
pcouas@infodev.fr

The Following address had delivery problems: irwinrivas (AT) powersb (DOT) po.my, 550 User unknown. .... Original header follows .... From...

irwinrivas@powersb.po.my

07-17-2005 09:00 PM
irwinrivas@powersb.po.my

Enter your vote today! A new poll has been created for the sql-general group: What is favorite programming language? o C# o Java o Asp o php o C++

sql-general@yahoogroups.com

07-17-2005 02:32 PM
sql-general@yahoogroups.com

Great thanks, worked like a charm.... James

minijuk2002

07-11-2005 10:01 PM
minijuk2002

HI All, We can delete a row from the identical rows in a table by using the rowid . try this. This is unique column to every table . --- In...

applyurresume

07-09-2005 01:03 PM
applyurresume

Any one please help me in give the query for the below problem say table with two columns ( name ,age,sex ) I need to query to get the ouput as the...

applyurresume

07-09-2005 12:59 PM
applyurresume

I am having trouble with creating a select statement that gets data employee data from one table, which doesnt appear in another table. Anybody have...

minijuk2002

07-05-2005 05:10 PM
minijuk2002

Do delete all duplicate records from a table, consider the following: for this table: CREATE TABLE test ( foo VARCHAR(100) NOT NULL, bar...

Renee Halbrook

06-08-2005 10:28 AM
Renee Halbrook

I am writing a report on sales and I have to rank each of our stores daily for each day in the current month. This is in Informix. Currently, we...

bitschon

06-07-2005 12:32 PM
bitschon

We are getting this random error on our SQL server when users try and connect with enterprise manager. Server user 'Auser' is not a valid user in...

Snake

06-01-2005 05:48 AM
Snake