|
hi,
how to play music during the processes of downloading a document in webapplication.
p.sethi
|
|
|
|
|
This is not the right forum to ask such a question.
Mubashir
Every job is a self portrait of the person who did it.
|
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
SELECT j.jobid, j.jobname, m.measure
FROM Jobs j
INNER JOIN Measures m ON j.measure = m.id
Regards
KP
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
In sqlserver database.
Thanks
|
|
|
|
|
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 />
|
|
|
|
|
DECLARE @Id INT
INSERT INTO tClients(sClientName, sClientAddress, sClientContact, iClientOrder)
VALUES ('Joe Simpson', '3 Green Ave' , 'Mr. R Simpson' , 3)
SELECT @Id = SCOPE_IDENTITY();
|
|
|
|
|
Thanks Colin,
I just have one more question... What is SCOPE_IDENTITY()?
|
|
|
|
|
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).
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
by excuting this query only those records who are availed both loan, advance will be displayed.
thank you
chandru
|
|
|
|
|
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
|
|
|
|
|
|
Dear All,
I am making web application using Asp.net C#(Visual Studio2005). And Sql server 2000 as a back End.
Actually I am fetching data from other database(named as retailexcel but in same server). I have wriiten a view (in retailexcel database) to get required data from four table of other database. My problem is when I fetch those data(about 40000 to 50000 record) It taking to much time. I tried catch feature of asp.net2.0. Time reduced but not significantly. So I am trying to import those tables to my database (named Inventory) from that retailexcel.
Now problem is every day or two, record of those tables changes. How can I keep update my tables (which are importing from retailexcel)
Please suggest me some idea.
Thanks
regards
imran khan
|
|
|
|
|
Can you schedule a SQL-Server job that runs once a day?
|
|
|
|
|
How would I update the field 'filename' in my SQL Server DB so that it replaces all '-' with an '_'? Is that possible?
FOUND IT.
|
|
|
|
|
Update FileTable
Set FileName = replace(FileName, '-', '_')
You have an arrow in your butt!
My name is Maximus Decimus Meridius, Commander of the Armies of the North, General of the Felix Legions, loyal servant to the true emperor, Marcus Aurelius. Father to a murdered process, husband to a murdered thread. And I will have my affinity, in this life or the next. - Gladiator. (Okay, not quite Gladiator but close.)
I work to live. I do not live to work. My clients do not seem capable of grasping this fact.
Ancient of days! august Athena! where, Where are thy men of might? - Lord Byron
|
|
|
|