|
hello all,
I have 3 tabels empployees(empid int,empname nvarchar 50),departement(depid int,depname nvarchar 50)and a table called intermediate(empid int,depid int) that join the other two tables I want to know the employees that doesn't belong to any departement.
I'v try the following:
select empname from emps join intermediate on emps.empid!=intermediate.empid
but it doesn't work as expected.
Dad
|
|
|
|
|
hadad wrote: select empname from emps join intermediate on emps.empid!=intermediate.empid
select empname from emps left join intermediate on emps.empid = intermediate.empid Look for any nulls in the Intermediate.EmpID column.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
select * from employees where empid not in (select empid from intermediate)
|
|
|
|
|
Hello friends,
Can anybody tell me about Hash table?
advantages of this table??
Thanks,
Ankur Bakliwal
|
|
|
|
|
Google broken where you live ?
Hash tables have nothing to do with SQL. They are a container which allows you to store values against an index. Google will tell you more.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Google hashtable and collections. There are some good articles on the collections classes on the msdn website. A hashtable is a type of collection used for storing objects in memory and has no relation to sql or Ado.net classes.
_____________________________________________________________________
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 all,
I have an asp.net webform which is exporting a crystal report in to Excel format. But what I need is, I would like to format the excel cells so that it should adjust the cell size or wrap the cell according to the data given in it by using VB.Net. If anybody know it pls. advice me or give me some code snippet if possible. Thank you.
Regards,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
hi i have two tables like want to display based on the date:
eg:
table1:
Id cardDate Intime1 Outtime1
1 12/22/2006 09:00 20:00
2 12/22/2007 09:00 20:00
3 12/22/2006 09:00 13:00
and table 2:
Id leaveDate Intime2 Outtime2
3 12/22/2006 13:00 20:00
4 12/22/2006 09:00 20:00
5 11/11/2006 09:00 20:00
If i select the date 12/22/2006" then it want to display like:
Id Carddate InTime1 Outtime1 Leavedate Intime2 Outtime2
1 12/22/2006 09:00 20:00 null null null
3 12/22/2006 09:00 13:00 12/22/2006 13:00 20:00
4 12/22/2006 09:00 20:00 null null null
I am week in sqlquery,plz hlp me...,
Magi
|
|
|
|
|
Hi
Before filtering based on Date, you need to convert to a specific format.
For eg., Convert(nvarchar(12),@DateParameter,101) where 101 displays date in mm/dd/yy.
So if you want to display based on date.
Select * from Table1 where convert(nvarchar(12),DateCol,101) = Convert(nvarchar(12),@DateParameter,101)
Where @DateParameter is the parameter to be passed from front-end.
Hope this is clear.
Harini
|
|
|
|
|
Hi
i have following tables
Table:Messages, Fields: msg_id,message
Table:Msg_groups, Fields:msg_id,Group
now i want to select msg_id and group, a msg_id can have more than one group it should display like this:
msg_id....group
123.......22,23,24
222.......22
122.......23,24
Any help will be appreciated.
Shahzad Aslam
-- modified at 5:37 Tuesday 27th March, 2007
|
|
|
|
|
the below query select groups for each msg_id
SELECT Messages.msg_id, Msg_groups.Group
FROM ( Messages INNER JOIN Msg_groups
ON Messages.msg_id=Msg_groups.msg_id )
enjoy it 
|
|
|
|
|
can write a function which accepts "msgid" and fatches all "group" returns concatenated group.
using
select msgid, fugroup(msgid) ......
will give output as required.
Regards
KP
|
|
|
|
|
can u help to develop the fugroup(msgid) function
Shahzad Aslam
|
|
|
|
|
CREATE FUNCTION fnRegions (@msgid int) RETURNS VARCHAR(100) AS
BEGIN
DECLARE c1 CURSOR FOR SELECT DISTINCT CAST(groupid AS VARCHAR(40))
FROM msg_groups WHERE msg_id = @msgid
DECLARE @row VARCHAR(50)
DECLARE @retval VARCHAR(50)
OPEN c1
FETCH c1 INTO @row
SET @retval = ''
WHILE @@FETCH_STATUS = 0
BEGIN
SET @retval = @retval + @reg + ', '
FETCH c1 INTO @row
END
RETURN @retval
END
Regards
KP
|
|
|
|
|
its great
Thanx!!
Shahzad Aslam
|
|
|
|
|
|
hi all,
I have created a report using sql server 2005 RS.Ive deployed it in the server(localhost)also.In the subsription section of the report manager ive mentioned a emailid to whom ive to send the report.Ive selected the report server email delivery method from the dropdown list.After entering the emailid and scheduling the report and when i click ok i find that the report was not delivered.Im getting this error.
Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.
I culdnt find enything in the log files.
Can any1 help me as how to accomplish this?
T.Balaji
|
|
|
|
|
You do have the SMTP server configured
|
|
|
|
|
yup smtp server has been configured..stil then pls help me
T.Balaji
|
|
|
|
|
Hi
Northwind database is not installed in my Database Server. I have installed this database from Microsoft's Site.
Anybody can tell me how to include this database in my SQL SERVER 2005.
Replay ASAP
Thanks
CARE CARRER
|
|
|
|
|
Have you tried attaching the database?
|
|
|
|
|
Most examples for SQL Server 2005 involve a sales table that you split based on date, i.e. sales records prior to 2000 go to this partition, and the ones after that go to another one. Nice and simple.
Say I have a sales table:
id.....Amount....Date
1......10........1/1/1999
2......9.99......1/1/2007
Now then, I put all the records prior to 2000 in it's own partition.
So when I do something like this: SELECT * FROM Sales WHERE DATE = 1/1/1999
the SQL server will know which partition to look at. Very nice.
Now then, if I do this: SELECT * FROM Sales WHERE id = 1
How will the SQL server know which partition to look at?
Thank You!
|
|
|
|
|
It will look in both partitions. However, you probably have a unique index on "id" so the cost will be minimal.
|
|
|
|
|
when more than one user connect to the database in server with application, they have very low return!
is there any settings for connection that more than one user could connect in same time without low spead?
|
|
|
|
|
What's the database ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
