.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

using aliases with select

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :ASP.Net
 

Hiiii Friends,

I m creating a procedure like this one-

create proc proc1
@var1 varchar(30)
as
begin
select cust_id,cust_name,sum(bill_amount)
from cust_table
where cust_id=@var1
group by 
cust_id,cust_name

select cust_id,bill_no,bill_date
from cust_table
where cust_id=@var1

end


Now i would like to join two select statements based on cust_id.

can u plz tell me how can i uses aliases for the above select satements.

Is there any article that will make me concept o aliases for select statements very much clear.?

thanx and regards 




View Complete Post


More Related Resource Links

AJAX GridView Checkbox Select All in ASP.Net

  
In the previous article GridView Select Multiple Rows you learnt the multiple row selection in GridView control. Here you will get the C# code sample to select all the gridview rows using single checkbox server control. You can highlight the selected rows with different color and Font state Bold. If you want to use the selection values on different ASP.Net

Select value in gridview

  

Hi, I am new to gridview. I want to make a gridview. Its row when selected should direct me to a specific .aspx page.Each row should direct to a different page. Should I use querystrings for this? Please suggest. Regards, ap.


The XML Files: XSLT Keys, Select vs. Match, Conflict Resolution, and More

  

This month Aaron Skonnard covers how keys work in XSLT, XSLT match and select attributes, SelectNodes order, finding