|
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.
|
|
|
|
|
Hi all,
How do I make the date format to DD-MMM-YYY, ie. 01-APR-1998.
I have try to set 'DateStyle' to all options but none of them can show
this format.
Could someone help me please?
Suresh.R
|
|
|
|
|
What technology are you using? (That would be a help to finding your answer)
|
|
|
|
|
Hi
i want it in SQL...
my INPUT is GetDate() and
OUTPUT is 9-Apr-2007...ok..
Suresh.R
|
|
|
|
|
sooreeagt wrote: i want it in SQL...
All RDBMS support SQL. Did you mean Microsoft SQL Server?
If you meant SQL Server then there is no exact conversion to the format you want. Be aware that it is the responsibility of the Presentation layer to format data, not the database.
|
|
|
|
|
Hey to Crystal Report users
i have made report with crystal report viewer and crystal report tool but before i get the report wich one i can print.it is asking me the DATABASE password which i dont want the End user to know ?
Please help me
i just want the user to click on print button and get the report without the database authentication
ok
job
|
|
|
|
|
ON button click.
-- 1. First make the object of the report (say AA.rpt)
Dim obj As New AA
-- 2. Pass the database (userid,pwd, server, Database name)
obj.SetDatabaseLogon("sa", "sa", "10.179.10.38", "PUBS")
-- 3. Use the object of crystal report viewer.
crViewer.ReportSource = obj
crViewer.Visible = True
vivek
|
|
|
|
|
Is there a sql query which will help me get the names of all the tables in the database.
|
|
|
|
|
SELECT * FROM INFORMATION_SCHEMA.TABLES
|
|
|
|
|
If you are doing it from code you could use the GetSchema("Databases") command off of the sqlconnection.
_____________________________________________________________________
Our developers never release
code. Rather, it tends to escape, pillaging the countryside all around.
The Enlightenment Project (paraphrased comment)
Visit Me at GISDevCafe
|
|
|
|
|
Hi..
Try the following query..
select * from sysobjects where xtype='u'
Balaguru
|
|
|
|
|
Nothing is working. My db name is siebeldb and presently there is only 1 table in it, namely 'orders'. But knowing that siebeldb is the database, how do I get the names of the tables it contains. Also when I know a table, how do I get the fieldnames and fieldtypes in the table.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
