|
I have this script here. But I need to redo it as a sub Query can someone help me?
SELECT
fp.flt_numb,
a.name as 'destination airport',
a.cty_iata_code,
b.name as 'possible landing airport'
FROM flight_profiles fp
JOIN airports a
ON a.iata_code = fp.to
JOIN airports b
ON a.cty_iata_code = b.cty_iata_code
ORDER BY fp.flt_numb;
|
|
|
|
|
|
I need to re-write this as a sub query:
Select
f.FLT_NUMB as 'Flight Number',
b.Name as 'Arrive Airpots',
a.Name as 'Airports'
from airports a
join flight_profiles f
join airports b
on a.cty_iata_code = f.to and b.iata_code = f.to
group by a.Name
order by f.flt_numb
|
|
|
|
|
I got re-wrote like this
select
d.flight_no,
d.destination,
a.Name as "Alternative Airort"
from airports a,
((SELECT b.FLIGHT_NUMBER FLIGHT_NO,
b.DESTINATION DESTINATION,
a1.cty_IATA_CODE AS CTY_CODE,
a1.name as airport_names
FROM AIRPORTS a1,
((SELECT FLT_NUMB FLIGhT_NUMBER,
F.TO DESTINATION FROM FLIGHT_PROFILES F) AS b)
WHERE b.DESTINATION=a1.IATA_CODE)as D)
where a.cty_iata_code=d.cty_code
order by d.flight_no
and its work fine.
|
|
|
|
|
Hi,
well i think i'm so stupide to ask that but i really tried ma besqt with it & it doesn't work
i created a stored procedure in this procedure i have 1 parameter type datetime
& i want to select * from a table where day(this table.dat_start)/month(dat_start)/year(the parameter) = the parameter
i will make it more clear
supposing parameter is '02/05/2006'
(select * from season where day(dat_start)/month(dat_start)/year('02/05/2006') = '02/05/2006')
it dosen't want to of course because the two types are defferent but i did a convert & it dosen't ant too
(select * from season where convert(datetime,day(dat_start)/month(dat_start)/year('02/05/2006')) = '02/05/2006')
& i did a cast & no result
(select * from season where cast(day(dat_start)/month(dat_start)/year('02/05/2006')as datetime) = '02/05/2006')
well i talked a lot i think i hope you understand please if you have the solution can you help, me ?
thank you very much
try to be good if you can't be the best
|
|
|
|
|
create Proc p_date (@dateS varchar(111))
as
Begin
select * from season where Convert(varchar,dat_start,111)=@dateS
end
if u have problem with this proc just mail me
moinul@apollodhaka.com
Moinul
Sr.Executive IT
Apollo Hospitals Dhaka
|
|
|
|
|
I need to run my program on my client machine.
I had developed my program on my machine and created the DB on my machine.
Now I need to transfer the db and my EXE file on to another machine
The server name on my machine shows
Running - \\Rch1 - MSSQLServer
But the server name on the second machine
Running - \\Krnot - MSSQLServer
How do I replace the servername.
My code;
Public conn As New OleDbConnection("Provider=sqloledb;server=Rch1;Database=Rch;Trusted_Connection=YES;")
Tnx
|
|
|
|
|
You should always put that kind of information in the app.cofig file. That way it can be changed when the application is moved around. Hardcoding this information into the app is just going to cause problems (as you have seen)
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Pls Could you give me some more info on this.
Tnx
|
|
|
|
|
|
What is the best way of distributing an empty (of transactional data) database in MS_SQL2k?
I have a database which has gone through system test and want to use this as the UAT baseline database - maybe do a backup and restore as a new database..or use tha database copy wizard?
Any other options?
'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd
|
|
|
|
|
Duncan Edwards Jones wrote: I have a database which has gone through system test and want to use this as the UAT baseline database - maybe do a backup and restore as a new database..or use tha database copy wizard?
I have some NUnit tests that restore a database in the TestFixtureSetUp method. It works very well - although sometimes it can be a little slow, so I have a set of delete scripts in reserve if I'm debugging though the unit tests and I need a quick reset between runs.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
-- modified at 9:01 Monday 15th May, 2006
|
|
|
|
|
You can use SQL Server Enterprise Manager to Generate Scripts of your entire database.
Right Click db -> All Tasks -> Generate SQL Script...
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
|
Hi,
I have one employ table, i want to find the nth max salary
can anybody know how to write a query please send to me
|
|
|
|
|
Something like this might work:
SELECT TOP 1 EmployeeID, Salary
FROM
(
SELECT TOP n EmployeeID, Salary
FROM EmployeeTable
ORDER BY Salary DESC
) AS TopSalaries
ORDER BY Salary ASCRemember to replace the n in TOP n with the actual literal value that you need (unless you are using SQL Server 2005)
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
If you don't mind temp tables this should work
######
DECLARE @TopSalary int
SET @TopSalary = 10 -- Get me the 10th hightest paid employee
create table #temp(id int Indentity(1,1) employeeID int, salary float)
insert #temp
insert employee, salary from YourTable
ORDER BY SALARY DESC
SELECT * from temp
WHERE ID = 10
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
|
|
That will get just the lowest Salary because the ORDER BY clause goes in ASCending order by default (i.e. Starting with the lowest)
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Select *,sal From Emp X Where n =
(
Select Count(Distinct Sal) From Emp Where sal >=X.sal
)
(Got it from the net somewhere )
By the way Colin, how do you post such nicely formatted code? Do you use any tool for that?
-
-- modified at 23:52 Tuesday 16th May, 2006
|
|
|
|
|
Dinuj Nath wrote: how do you post such nicely formatted code? Do you use any tool for that?
For the code to show up in the orange box, you use the <pre> tag and for the text in red like the TOP n that Colin uses, use the <code> tag that is in the Formatting selection of the Reply to a Message form.
I hope this helps,
Paul
|
|
|
|
|
|
hello,
I am using vb.net and I am a new comer to ADO.net! I have a relational database and I am confusing in it to connect it to vb.net. All I have is 4 tables. I want to make databinding in textboxes within the program. Can someone guide me somewhere pls  I am using MS Access 2003 not SQL. But i am trying to use SELECT statements and etc.
Thank you
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
-- modified at 6:25 Monday 15th May, 2006
|
|
|
|
|
well i see that no body answear i don't know i think it is easy
this is the way
well i don't know if you know something abt dataset have you heard abt that before ?
this dataset is a tomporary representation of a database in the memory
this dataset is used in the deconnected mode
i hope you know all that sh*t if you don't i can send you a good course of vb.net but in french else you can ask this in microsoft.com in MSDN & i'm sure you will get what you need
if you don't find neither you can just ask me i will help as much as i can i'm a beginner too 
try to be good if you can't be the best
|
|
|
|
|
|
Hi
i dont know when use a static method and when a non-static method in the data access layer
suppose we have
#1
public class Customer
{
.
.
.
publuc static DataSet GetCustomerList( int shopID )
{
//Do something and return a dataset
}
.
.
.
}
#2
public class Customer
{
.
.
.
publuc DataSet GetCustomerList( int shopID )
{
//Do something and return a dataset
}
.
.
.
}
#1 or #2 This is the problem
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
