Here is one way:
select Legend='Status 1', count(Weigh),sum(Weigh) from myTable where id=120 and status=0
UNION
select Legend='Status 2',count(Weigh),sum(Weigh) from myTable where id=120 and status=2
UNION
select Legend='Status 3',count(Weigh),sum(Weigh) from myTable where id=120 and status=3
ORDER BY Legend
Kalman Toth Database & OLAP Architect sqlusa.com
New Book / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012
I have one report item that can be used 2/3 datasets into a single report hw can we take those data sets into my report can some one tell me exact soluction step by step
I am trying to create a workflow which can send email with attachments. Also would it be possible to use InfoPath to submit the form and the attachment to the SP and send an email with the attachment simultaneously?
Regards,
TC
hi all
can i know, is it possible to implement file stream on shared hosting server, any difficulty occurs
Is it possible: Yes.
Can difficulties or problems arise: Yes as it's a shared server. But when it is a well managed server then the it should not be a problem.
