|
Hi,
I have 2 Tables with each his own columns
but they have both 1 identical column
I want to make a 3th table with the identical columns in
but not twice the same!
For example:
Table 1: ID1,Title,pages
Table 2: ID2,Title,Author
Table 3: ID3,Title (but when my title is the same in table1 and table2 i only want to insert it once)
So i thought,
I insert whole table1 in table3
then with a cursor, run through table2
and if i don't find the value in table3 insert Title from table2 in Table3
Is there another work around?
Thanks,
A.
|
|
|
|
|
Are the IDs in tables 1 & 2 the same? If not, what value will you insert into column ID3 in table 3 when you find matching rows?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Insert into table3
(ID3,Title,xxx)
Select ID1,Title,pages from Table1
Union
(Select ID1,Title,author from Table2
Where Title Not In (Select Distinct Title From Table1))
Best Regards,
Chetan Patel
|
|
|
|
|
Thank You,
I was looking way to far, for a solution...
|
|
|
|
|
i enter data in table at this order
kamal 78
kamal 78
kamal 78
kamal 45
kamal 45
mohan 12
mohan 12
suresh 23
suresh 23
ram 78
ram 78
mahi 23
mahi 23
and i want to display data on this like [note display according entry]
out put
name amount timeofpaid
kamal 78 3
kamal 45 2
mohan 12 2
suresh 23 2
ram 78 2
mahi 23 2
no knowledge in .net
|
|
|
|
|
You can do it with the help of Group By clause and count function.
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
by using group by clause and count function
never give correct format according the order of entry in table
no knowledge in .net
|
|
|
|
|
select count(amount) as appeartimes,[name]<br />
from tablename group by amount,[name]
I Love SQL
|
|
|
|
|
Mr blue boy
i want to display record in order as entry in table
like first time kamal pay 78 amount three time then pay 45 amount two time
in table
according entry order i want display record
kamal 78 3
kamal 45 2
such like that
ur quiry never give actual format like entry
no knowledge in .net
|
|
|
|
|
hope this helps
select name,count([amount]) as timeofpaid<br />
from tablename group by [name],amount order by name,timeofpaid
I Love SQL
|
|
|
|
|
i have a column of datatype string in the sql server 2000 database.
following is the data in that table
1
2
11
12
a
if i sort the data then output comes in the following manner
1
11
12
2
a
, but i want 1 2 11 12 a
to sort out this problem i thought to make two unioun queries
to fileter the numeric values and alphanumeric values.
no the questio is can somebody tell me how to filter the numeric and alphanumeric values .
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
Don't double post, it's rude.
|
|
|
|
|
i want to use the DateDiff() procedure of VB6.0 but iam getting Run-time error 5: Invalid Procedure call or Argument.i want to know the exact syntax of using DateDiff() procedure.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
If this is a VB6 method, using VB6 objects, then it's not really SQL, or am I misunderstanding you ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Sorry i didn't get you.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
He means - this is not a SQL question. It's a VB6 question - hence it shouldn't be in the SQL forum.
|
|
|
|
|
Try pressing F1 for help.
Also, VB6 is not a SQL question.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Ashfield wrote: Also, VB6 is not a SQL question
Nope. It is questionable though.
|
|
|
|
|
i don't have MSDN installed.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
Well try the granddaddy of all things, google!
To help, here's a link to vb6 functions
Visual Basic Command Syntax
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Thanx. Sure it is very helpful to me and for all the others who are beginners. Thanx.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
While trying to process multiple select statement and retreiving files from my database I get the following message:
"ContextSwitchDeadlock was detected
Message: The CLR has been unable to transition from COM context 0x271130
to COM context 0x2712a0 for 60 seconds. The thread that owns the destination
context/apartment is most likely either doing a non pumping wait or
processing a very long running operation without pumping Windows messages.
This situation generally has a negative performance impact and may even
lead to the application becoming non responsive or memory usage accumulating
continually over time. To avoid this problem, all single threaded apartment
(STA) threads should use pumping wait primitives (such as
CoWaitForMultipleHandles) and routinely pump messages during long running
operations."
How do I resolve this problem, I am using C# and SQL Server.
Thanks in advance,
Michael
|
|
|
|
|
The documentation for this can be found at http://msdn2.microsoft.com/en-us/library/ms172233.aspx[^]. It's a Managed Debugging Assistant, which is a component that is invoked by the .NET Framework Common Language Runtime (CLR) when debugging.
It's very unusual to get this message - I've never seen it in debugging .NET applications that work with databases. I believe it indicates that your UI thread was blocked for a long period of time. You should strongly consider moving any long-running queries to other threads.
All calls to COM objects that are marked Apartment thread model have to run on the thread which created them. This includes cleanup code. .NET's garbage collection model pushes anything that needs cleanup after garbage collection onto a finalization queue, which is read by a separate finalization thread. That finalization thread has to cause the thread that created the COM object to run the cleanup code. While it's blocked waiting for the original thread, other objects which require finalization just build up on the queue, because there is only one finalization thread in the process.
You should check that you're using the SqlConnection family of objects throughout and not trying to use OleDbConnection or use the classic ADO objects.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
Hi,
I need to have a Matix report which looks like :
...............|YEARS
--------------------------------
...............|Class1|Class2|Class3
Programme|StudNo|StudNo|StudNo
ie; The Matix will look like this
Programme|.......2001.................|........2002............|.
------------------------------------------------------------------------
..............|Class1|Class2|Class3|Class1|Class2|Class3|.....
IT...........|..23...|...24..|..45....|..12...|..23...|..12..|.....
MBA........|..34...|...12..|..12....|..31...|..13...|..14..|.....
I don't know how to split the YEARS' column into 3 different subcolumns which has got class1,class2,class3.Each year has got the 3 different staic classnames. Under that the no of students in each class comes. The students in each class in each year should be calculated based on some condition. Its not available directly from a dataset. Hope u can understand the matix.
PLEASE HELP!!! 
Thanks & regards,
Payal
modified on Thursday, March 6, 2008 8:38 PM
|
|
|
|
|
Your column groupings need to be Year and Class.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
