|
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
|
|
|
|
|
Hi every one,
I installed SQL server 2005 enterprise edition on my pc and I selected SQLEXPRESS name for instance of it .I have a vb program and I can connect to database with below connection string.
SqlCon.ConnectionString = "Driver={SQL Server};Server=ComputeName\SQLEXPRESS;DataBase=DigitalSignature;Trusted_Connection=Yes;"
ComputerName is the name of my Computer and DigitalSignature is the name of my database in sql server.
My problem is :when my pc is connected to network I can connect to database completely but when I disconnect the pc from network I get error .
How can I connect to sql server from an application that both of them(Sql server and Application) are in one computer.I think the connection string is wrong.
If any one knows ,please inform me.
yours sincerely,
Orchid
|
|
|
|
|
Orchid85 wrote: I installed SQL server 2005 enterprise edition on my pc and I selected SQLEXPRESS name for instance of it
Why did your ENTERPRISE edition of SQL Server SQLEXPRESS? That makes no sense.
Orchid85 wrote: My problem is :when my pc is connected to network I can connect to database completely but when I disconnect the pc from network I get error .
What error? (Why do people insist on writing to a forum to say they have an error, but expect the world to guess what the error message is?! WE ARE NOT TELEPATHIC!)
Orchid85 wrote: How can I connect to sql server from an application that both of them(Sql server and Application) are in one computer.I think the connection string is wrong.
What makes you think the Connection String is wrong? It was working fine when the network was connected. Doesn't that indicate the connection string is valid?
I'm curious as to why you disconnected the network. SQL Server Enterprise Edition is designed to work in a networked environment.
I'm guessing that you need to go into the "SQL Server Configuration Manager". Go into "SQL Server Network Configuration"-->"Protocols for SQLEXPRESS" And in the right pane there will be a thing marked "Shared Memory". Right-click it and "Enable" it. That might solve your immediate problem.
|
|
|
|
|
Hi Guys,
I have a strange problem -
1) I created a dataset using data tables loaded from the SA connection string.
2) Setup these DS's and used them as test stubs with SQL squeries.
3) Created stored procs and pointed the SQL Functions at these instead.
4) Created a new user with just SP Access
5) Set the connection string to use this new user login in the connection
Now, after all this is complete, all references to the origional SA connection string have been removed, all the project Bin folders have been deleted, all the Obj folders have been cleared and the DTA's themselves say that they are using the new connection string, it still loads up using the SA connection.
Additional Info:
This is a seprate DB Library to the web project.
This project is running in Cassini.
I'm spooked. What's the deal?
Cheers
Tris
-------------------------------
Carrier Bags - 21st Century Tumbleweed.
|
|
|
|
|
Tristan Rhodes wrote: I'm spooked. What's the deal?
No idea. You have to trace where the connection string is coming from. Start with the point at which the connection is made, put a break point down at that point. Look where the connection string comes from and work backwards from there, putting break points further back in the code until you have your answer. Essentially, what you need is a break point that is set just before the connection string is generated or retrieved. Then you step into as much code to see what is happening as possible.
|
|
|
|
|
Weird
Seems my settings file wasn't updated.
Weird that nothing picked up on it, i did so many full text searches that i was certain it couldn't have existed. Just clicked on the settings file and it auto updated from the config.
That'd be my Inexcusable Stupid Noobie Mistake (tm) 1'567'445
Edit: No wonder i didn't find it - VB did a lovely '& _' line break in the middle of it.
-------------------------------
Carrier Bags - 21st Century Tumbleweed.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
