|
Many thanks for your reply.Its Much appreciated
Table1
id int
Cli Nvarchar(200)
Timestamp datetime
100 records
Table2
id int
Cli nvarchar(200)
40 records
Select distinct(cli) from Table1 where Cli not in (select Cli from table2)
This should at least return 60 records.
Regards
Select
|
|
|
|
|
|
<blockquote class="FQ"><div class="FQA">kibromg wrote:</div>Select distinct(cli) from Table1 where Cli not in (select Cli from table2)</blockquote>
Select distinct(cli) from Table1 where Cli not in (select Cli from table2 where Cli is not null)
FTFY, SQL server has some floopy processing when it does 'not in' queries.
The true man wants two things: danger and play. For that reason he wants woman, as the most dangerous plaything.
|
|
|
|
|
and where does this happens: in code or in database
if it is in code try running it in some plsql developer and see what you get
|
|
|
|
|
Thanks very much for your reply.It runs on a database.
|
|
|
|
|
Select distinct(cli) from Table1 where cli not in (select Cli from table2)
try this with small c in second cli
|
|
|
|
|
Still the same.I have tried that also.
|
|
|
|
|
Have you got nulls in your fields? That would cause it.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Yes Please.when i select distinct(cli) there is one record NULL.
When i try to remove it delete from Table1 where cli like NULL it does nothing.
Can you please advice how can i remove it?
|
|
|
|
|
You cannot do like null (or = null either), you have to do
where cli is not null (or cli is null depending on whic you want)
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
this can help
select table1.cli from table1 left join table2 on table1.cli=table2.cli
where table2.cli is null
|
|
|
|
|
This is a SQL question. I would suggest you break it down to try to work out why it doesn't work.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Yes Please.when i select distinct(cli) there is one record NULL together with other records
When i try to remove it delete from Table1 where cli like NULL it does nothing.
Can you please advice how can i remove it?
|
|
|
|
|
Hi Christian,
Can you help me with a script on how to check and remove any Null script from a table.
Many thanks
|
|
|
|
|
You should try IS NULL instead of LIKE NULL
|
|
|
|
|
What is C#'s equivalent to VFP's CursorAdapter?
|
|
|
|
|
Depends, what does it do ? You can set the cursor with Cursor = Cursors.xxx
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Hi,
I think you want to open a database cursor, aren't you? Then you're search for class:
System.Data.Common.DbDataReader
or if you're searching e.g. for MS SQL Server:
System.Data.SqlClient.SqlDataReader
or OleDb:
System.Data.OleDb.OleDbDataReader
or Odbc:
System.Data.Odbc.OdbcDataReader
king regards
|
|
|
|
|
|
How to connect to MS Access Database and display result to grid?
|
|
|
|
|
do a google search and ill bet you will get loads of examples.
try looking at the System.Data.OleDb classes, its very straight forward from a programmers perspective
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
Thanks. Your answer guided me to the right trajectory.
|
|
|
|
|
|
it's easy for you because you already know
But the link that you gave me is very helpful so I will vote 1 for you.
|
|
|
|
|
I have asked this question several times in Code Project.
I am looking to upload my data with resume feature.
Is there any .Net Class or namespace or any algorithm to provide me a feature where i can upload my data in different segments and with resume feature?
|
|
|
|