|
I don't think you finished what you intended to write, but what you did write looks bad.
|
|
|
|
|
Raman samineni wrote: I have 3 select statments
Funny I count 5, the ability to count is reasonably fundamental to stating your problem. You also need to be much clearer what your goal is.
Do some reading on UNION and UNION ALL, these will help. Your queries must have the same fields and formats so your first query should be something like
Select E.FirstName +' ' + E.LastName as FullName, 'Supervisor' as TypeName
INNER JOIN [cgs].dbo.tems h ON(h.Supervisor = E.EmploId)
where h.temId = 336
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I put Union and Union all, it does not work.
Thanks
Regards
Raman
|
|
|
|
|
Did you do some reading on how to use UNION or did you just stick it in between the select queries. RTFM
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello sir,
Just stick in between the select queries. I dont want use Union , Because this qry goes to in the program.
Regards
Raman
|
|
|
|
|
Raman samineni wrote: I need to write all in one query
What would you gain from having it in a single statement? As PIEBALD stated, you can put them in a single SqlCommand and execute them.
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
Hello sir
Thank you. My out put was
Supervisor- AgentName-Hours-Tran-Completed,
when I ran the qry i need to get this report.
Regards
Raman
|
|
|
|
|
Raman samineni wrote: when I ran the qry i need to get this report.
You could put the other query in there too, as a subquery. The other queries might be combined, depending on "what" you are selecting from. I have not seen a corrected version of that code yet; I suggest you start writing and testing
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
hello sir,
How all three statments be written as one query.
Regards
Raman
|
|
|
|
|
how I will put in the sql Command all three query
Thanks
Raman
|
|
|
|
|
Raman samineni wrote: how I will put in the sql Command all three query
Do you need them in a single "sql statement", or do you need them in a single "SqlCommand"? For either way you have been given a solution - did they not work, and if so, what went wrong?
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
send me both, No problem
Thanks
Raman
|
|
|
|
|
Raman samineni wrote: send me both, No problem
AFAIK, we're volunteers here. Why should I provide two pieces of code??
The first query from your list is simply invalid, as it lacks a FROM statement. You can search on the internet what a "subquery" is and how to write one, and try to combine that code as suggested. Also reread PIEBALDs' suggestions, there's a good reason they get upvoted every time.
Good luck, you'll need it
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
hello sir,
My OUT PUT Report was
SuperName Agent Name Hours Trans Compl
Thanks
Raman
|
|
|
|
|
I can't help you, sorry.
We gave quite some answers and options, and your response was "write them both for me". Unless you can answer whether you need them in a single SqlCommand or as a single Sql-statement, there will not be any progress.
Now, it doesn't add anything of value to have them in a single statement, but I'm willing to help. When I say "help", I mean that I can point out how some things are done, it does not mean that I am going to write YOUR code.
|
|
|
|
|
yes, that is true, I need them in SQLCOMMAND or String query in the program
I appreciated
Raman
|
|
|
|
|
You're welcome
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
Hi friends,
I want to know the future of SSRS in SQL .
|
|
|
|
|
Arul R Ece wrote: I want to know the future
Hang on a second, while I go fetch my crystal ball.
Arul R Ece wrote: of SSRS in SQL
There's a 95% chance that it will still be supported in the next five years.
Anything particular that you're worried about? If not, I suggest bookmarking their blog[^].
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
i need source code of replication database in c#. who can help me?
|
|
|
|
|
pashmakjoon wrote: i need source code of replication database in c#.
This is not a take-out restaurant.
pashmakjoon wrote: who can help me?
MSDN[^].
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
i can't find your code.
where is your code?
|
|
|
|
|
He left it under a rock outside. Have you gone out and looked for it?
|
|
|
|
|
I didn't supply any; the relevant sections are in the manual, and it takes some study and configuration.
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
pashmakjoon wrote: i need source code of replication database in c#
Major databases have tools in the database itself which is used to replicate the database.
|
|
|
|