|
I have a parent table Item and a child table Grade. For a query, I would like to be able to select from a view or function that gives me one Item per row (as if I were selecting right from it) but adds an ntext column to the output, where its child Grades are listed in a delimited list. I'm not entirely sure where to go with this, without making it too terribly complicated. Please advise?
|
|
|
|
|
Google[^] is your friend here...
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Not sure how feasible this is, but will ask in case someone has figured it out:
I have a table of people with people and a unique id and a name (amongst other things of course)
e.g.
uid | uName
I have a separate table that has entries where two of the IDs will get recorded
e.g.
date|signed(bit)|approved (bit)|signerID|approverID
I want to be able to retrieve the uName for signerID and approverID
e.g.
SELECT t2.date,t2.signed,t2.approved,t1.userName as signerName,t1.userName as approverName
JOIN (so that signerName and approverName both get resolved).
WHERE date < _SOMEDATE_
I know I could dump using a insert select on the people table into a temp table and JOIN against that, but wanted to see if anyone had a fancier/more elegant solution than that ...
TIA
|
|
|
|
|
Something like:
SELECT Approvals.Date, Approvals.Signed, Approvals.Approved, Signer.uName, Approver.uName
FROM Approvals
INNER JOIN People AS Signer
ON Approvals.SignerID = Signer.uid
INNER JOIN People AS Approver
ON Approvals.ApproverID = Approver.uid
Regards
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Works great! I've become so fixed on Left Joins lately ... I knew there was a way to do it with a 'looser' join, but couldn't quite nail it down. Thanks!
|
|
|
|
|
How can I change column orders by Transact Sql in Sql Server 2005?
I can do it in sql server 2000 by updating colid in syscolumns table . but sql server 2005 does not allow us to update system tables directly.
please help me. 
modified on Friday, March 7, 2008 9:52 AM
|
|
|
|
|
|
Hi,
I'm designing a reporting program that is being fed with a pre-defined and pre-filled dataset(passed with constructor to report form).The data set is consist of 2 tables and both of them are needed to display.I maked an exact replica of that dataset with dataset designer and dragging fields to report(Reporting Services Report).But the problem is only the first table of dataset is recognised and whille adding any field of of second one to Details section of report , designer produces something like this:
First(Fields!QTY,"Bill_OrderDetails")
(Bill is the replica Dataset and orderdetails is the second table)
and removing First Function causes compiler complains about not using
an aggergate function in detail section.
How can I use the second Table?
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
