Database

how to put date from 2nd table to 1st table.

11-Apr-07 1:10

YES.

backword compatibility is possible. But the other is not

Regards
KP

music play

pratima19-Apr-07 22:46

pratima1

9-Apr-07 22:46

hi,
how to play music during the processes of downloading a document in webapplication.

p.sethi

Re: music play

_mubashir9-Apr-07 23:08

_mubashir

9-Apr-07 23:08

This is not the right forum to ask such a question.

Mubashir

Every job is a self portrait of the person who did it.

Re: music play

Colin Angus Mackay9-Apr-07 23:26

Colin Angus Mackay

9-Apr-07 23:26

You might want to try the ASP.NET forum[^]

Upcoming events:
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)
* Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

Re: music play

Paddy Boyd10-Apr-07 5:38

Paddy Boyd

10-Apr-07 5:38

You might also want to consider how annoying that could become and the fact that you're taking up valuable bandwidth streaming the music along with whatever you're downloading...

I for one would just quit the download and leave.

honda15i9-Apr-07 22:21

honda15i

9-Apr-07 22:21

I'm new in mssql. I was trying various ways, but no luck.
I have two tables "jobs" and "measures".

JOBS fields are:

[U]JOBID JOBNAME MEASURE[/U]
1 programming 11
2 corbel 22

MEASURES fields:
[U]ID MEASURE[/U]
11 hours
22 lb

[U]The result should be:[/U]
1 programming hours
2 corbel lb

Regards Arthur S.

Re: how to put date from 2nd table to 1st table.

_mubashir9-Apr-07 22:46

_mubashir

9-Apr-07 22:46

Hi,
try the following

Select jobs.JOBID, JOBS.JOBNAME, MEASURES.MEASURE
from JOBS, MEASURES
WHERE JOBS.MEASURE = MEASURES.ID

Mubashir

Every job is a self portrait of the person who did it.

Re: how to put date from 2nd table to 1st table.

Krish - KP10-Apr-07 2:11

10-Apr-07 2:11

SELECT j.jobid, j.jobname, m.measure
FROM Jobs j
INNER JOIN Measures m ON j.measure = m.id

Regards
KP

Error!

nclauder9-Apr-07 21:27

nclauder

9-Apr-07 21:27

Hi,
Im inserting into one column image at the same time text. but when I insert data I get this error:
Specified argument was out of the range of valid values. Parameter name: Images/laughing.gif
Why is it so?
Thanks

Re: Error!

_mubashir9-Apr-07 23:10

_mubashir

9-Apr-07 23:10

nclauder wrote:
Im inserting into one column image at the same time text

Where r u inserting the this data?

Mubashir

Every job is a self portrait of the person who did it.

Re: Error!

nclauder10-Apr-07 1:06

nclauder

10-Apr-07 1:06

In sqlserver database.
Thanks

retrieve auto number ID

playout9-Apr-07 19:56

playout

9-Apr-07 19:56

Hi,

I am inserting a new record to a SQL 2005 database table(tClients). I have a Primary Key called iClientID in that I use to bind clients, that is Auto Number.

I want to retrieve the iClientID once I inserted the record, as part of my stored procedure. Here is my insert statement.

<br />
<br />
INSERT INTO tClients(sClientName, sClientAddress, sClientContact, iClientOrder)<br />
VALUES ('Joe Simpson', '3 Green Ave' , 'Mr. R Simpson' , 3)<br />
<br />

Colin Angus Mackay9-Apr-07 20:25

Colin Angus Mackay

9-Apr-07 20:25

DECLARE @Id INT
INSERT INTO tClients(sClientName, sClientAddress, sClientContact, iClientOrder)
VALUES ('Joe Simpson', '3 Green Ave' , 'Mr. R Simpson' , 3)
SELECT @Id = SCOPE_IDENTITY();

playout9-Apr-07 20:58

playout

9-Apr-07 20:58

Thanks Colin,

I just have one more question... What is SCOPE_IDENTITY()?

Colin Angus Mackay9-Apr-07 21:03

Colin Angus Mackay

9-Apr-07 21:03

playout wrote:
I just have one more question... What is SCOPE_IDENTITY()?

What you asked for. The ID of the most recently inserted row (in this scope).

Krish - KP9-Apr-07 21:14

9-Apr-07 21:14

SCOPE_IDENTITY
Returns the last IDENTITY value inserted into an IDENTITY column in the same scope. A scope is a module -- a stored procedure, trigger, function, or batch.

Regards
KP

Sathesh Sakthivel10-Apr-07 19:31

Sathesh Sakthivel

10-Apr-07 19:31

Returns the last identity value inserted into an identity column in the same scope. A scope is a module: a stored procedure, trigger, function, or batch. Therefore, two statements are in the same scope if they are in the same stored procedure, function, or batch.

Regards,

Satips.

merging two database

chandru709-Apr-07 18:47

chandru70

9-Apr-07 18:47

i have 3 tables
1 master
2 advance
3 loan
here some employe taken only advance,some only loan ,some both and some not availed.
i want to list like this those are availed.

emp_code emp_name adv_amt, loan

emp_code is id for all three files

regards
chandru

vivek-g9-Apr-07 20:28

vivek-g

9-Apr-07 20:28

SELECT MASTER.EMP_CODE,MASTER.EMP_NAME,ADVANCE.ADV_AMT, LOAN.LOAN
FROM MASTER ,ADVANCE,LOAN
WHERE
MASTER.EMP_CODE=ADVANCE.EMP_CODE
AND
MASTER.EMP_CODE=LOAN.EMP_CODE
AND
LOAN.AVAILED='Y'

vivek

chandru709-Apr-07 23:04

chandru70

9-Apr-07 23:04

by excuting this query only those records who are availed both loan, advance will be displayed.
thank you
chandru

Krish - KP9-Apr-07 20:57

9-Apr-07 20:57

SELECT emp_code, emp_name, sum(adv_amt) as adv_amt, sum(load) AS loan
FROM (
SELECT emp_code, emp_name, adv_amt, 0 AS loan
FROM master m
INNER JOIN advance a ON m.emp_code = a.emp_code

UNION ALL

SELECT emp_code, emp_name, 0 AS adv_amt, loan
FROM master m
INNER JOIN loan l ON m.emp_code = l.emp_code
)a
GROUP BY emp_code, emp_name

Regards
KP