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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

how to add this two sum column to show in one

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

hi this is my query im struct

select SUM(a.SqFt + b.SqftDespatch)as Qt  from dbo.Batch_reg a 
left join dbo.QCM_Descp b on a.BatchNo=b.BatchNo where a.MPONo='M1'

select SUM(a.qty) as Qt, SUM(b.Dqty) as Qt1  from dbo.table1 a 

left join dbo.table2 b on a.No=b.DNo where a.No='M1'

im getting output like this

Qt          Qt1

1500      200

I need output like this


Note: if Qt1 return Null then i need to show 1500 only for above example.

how to do?

View Complete Post

More Related Resource Links

How to show 0 as first number in column


Hi guys. I have two little problem.

I have database with one table and it has 4 rows.

1. I want to show a zero in front of all number. Actually i added but it doesn't show.

2. If i don't put any value in column is it possible to have minus for example instead of 0?




I post it like that because i can't see how to post pics directly.

P.S. The columns with numbers have checked "allow nulls".

I draw in paint so it's not so good but i think it's understandable.

10x in advance.

SQLCE table column DefaultValues don't show up in XSD Dataset designer

Using Visual Studio 2008 with SQL CE 3.5, I notice that default values in the creation scripts for the database tables are not reflected in the dataset designer XSD file.  For example, the following SQL script creates the non-nullable table column names "Content" with a default value of 'Image':    "Content" nchar(20) NOT NULL DEFAULT 'Image',But in the column properties of the dataset designer (XSD) panel, this column correctly shows up as non-nullable, but with a DBnull default value as follows:     Name: Content    Allow DBnull: False    DefaultValue: <DBnull>Am I missing something somewhere, or is this a VS bug?  Also, how do I get the XSD file to regenerate after schema changes in the database?  Sqlmetal doesn't do it.Thanks,    -BGood

How do I get a new column I created to show-up in the DisplayForm.aspx page?

Here's a little introduction to how I got here:

Downloaded the WSS Help Desk application template and installed it and now my company wants to add a column to the ServiceRequests list called "Service Request Type".  So I created a new column and made it a choice of "Incident" or "Change".  I then customized the EditForm.aspx and NewForm.aspx to provide the new entry.  Other than losing the ability to attach documents the forms are working perfectly and collecting the data.  My problem is that when I open the DisplayForm.aspx and attempt to add a new row and use the <xsl:value-of select="@SRType" /> I don't see any values displayed.  Also, I can browse  the Data Source Library and click on Service Requests > Show Data and see the new list item but when I choose the button for "Insert Selected Fields as...", the Item is greyed-out.  

Tried manually inserting code based-on similiar entries but still no luck.  Here's what I have so far:

      <td width="190px" valign="top" class="ms-formlabel">
         <H3 class="ms-standardheader">
           <nobr>Service Request Type</nobr>
      <td width="400px" valign="top" class="ms-formbody"><

How programmatically change Additional Column Settings - Show field?


Hello. I use the SPFieldUser in my list. I can change Additional Column Settings - Show field: "Name with Presense" on the "Name (with Picture and details)" using the WSS Web interface. How do it programmatically, using Object Model WSS?

Default Column Values in a Document Library (SP2010) do not show up in word 2010 until you save and


when you create a document in a SP 2010 document library (of a particular content type, by clicking new, letter (content type name) in sharepoint for example) which has default values set on in in the library (set by using library settings -> change default column values), the default values do not show up until you create the document , save it and reopen it again.  Is this a bug or by design.  If it is by design, it is horrible since if some of the column default values are mandatory in the content type then you actually have to type them in before you could possibly save the file which defeats the whole point of having default column values.  Also it is tremendously clunky for a user to have to create file, save it , close it, and reopen it just to view the default metadata in the document information panel that is supposed to be there.

Anyone have any thoughts/solutions to this problem?


Column to show count of attachments uploaded for each List item in MOSS 2007


We have two requirements:

First, we need a column which shows the count of attachments that are for uploaded each item, the list structure is like below:

No. Of Files Attached Title Category Description Owner

Add Column to show email has attachments




How can I add a column to a document libary to should that an email has an attachment.  I just want to mimic what you would see in outlook, ie the paperclip icon.



Show column headers when gridview returns empty data set




I have in my code a gridview that I redirect to excel, it works fine when I have data in the data set. waht I want is to show column headers when there is no data right now what i get is empty sheet. 

Only date is displayed in modified column. How do I get it to show time also?


I can't find out how to set the format for this column in document libraries. I have seen the column also display time so I know it's possible.



Content Type or Lists Lookup Column can't show additional fields which are Choice or lookup columns


I am trying to create some content types, but this also happens when creating new columns in a list.

Ok, here is my setup (which is the most basic way to replicate the issue):

List 1: Department List
Columns: Department Name (Single Line of Text)

List 2: Document Owners
Columns: Document Owner (single line of text), Department (Choice or Lookup from Department List), Email (single line of text), Lookup Field (Calculated).

Content Type: Quality Document
Columns: File Name, Title, Document Owners (Lookup from Document Owners List), Email (pulled in with Document Owner), Then i want to also pull in Department from the Document Owners list.

That is where my problem is.  When i select the Document Owners List as the list to get the information from, there isn't the option under "Add a column to show each of these additional fields" to pull in the Department column.  This occurs if i use a Choice in the Document Owners list, or if i do a lookup from the Department List.

My preferred method of implementing this system would be to have a multi-value lookup field in the Department List for Document Owners so that the Owners are attached to the Department, and if the owners change for the department they also change for the document that is for said department.  But, i run into the same issue that i c

How to show column value in display mode and hide in edit mode?


How to show column value in display mode and hide in edit mode for my custom page layout?

I need similar functionality like PublishingWebControls:EditModePanel with contrary behavior.

I cannot use nor server-side code neither third-party web-parts. Only pure APSX+SP Contol Libraries and client JS allowed.

Customized CQWP column are not show after publishing sharepoint 2007


Hi All,


I create a custom CQWP programmatically where i show two or three different column. When i configure it it work fine in "Edit Mode" (means all columns are visible) but when i check in only the title field is shown to me other field are invisible again when i edit the page all things are fine....Kindly help me...

Thanks and Regards Er.Pradipta Nayak

Customized CQWP column are not show after publishing sharepoint 2007


Hi All,


I create a custom CQWP programmatically where i show two or three different column. When i configure it it work fine in "Edit Mode" (means all columns are visible) but when i check in only the title field is shown to me other field are invisible again when i edit the page all things are fine....Kindly help me...

Thanks and Regards Er.Pradipta Nayak

How to - show previous versions values of column



Take a default WSS 3 server & site as the example.

I've created a custom list, one column has "Append Changes to Existing Text" (multi-line text box).  For example "People List":

  • Full Name (single line)
  • Comments (multi line & append changes)

I create a person, and make a comment.  Later I go in and make a second comment.

When I click on this individual record to view it, I can see all information, including both "entries" of comments.

Question:  I want to create a custom list view that will show me all people, and all comments (including previous 'versions' or entries).  When I try to do this, I can only view the most recent comment.


Any thoughts?



Tooltip for GridView Column Headers (ASP.Net)

I just wanted to add auto tooltips for my GridView headers. There are couple of ways but I don't want to use javascript and wanted to use simple 'title' attribute. It took couple of hours to get the working code supporting sortable columns. I thought it will be very useful for others. Here's the code and logic behind it.

GridView control to show master-child or master-slave data, written in c#, asp.net

I previously made a master slave datagrid using Visual Studio 2003 .Net (original article) that would allow users to show data to clients using collapse and expand features. These features however did not carry over to gridview for many users. This tutorial will explaing how to create a collapsable/expandable gridview in frameworks 2.0 and higher

Multiple Column Dropdownlist for the ASP.NET DataGrid

Based on my previous control "Multiple Column DropDownList for ASP.NET", I received many emails asking for the same control to be used in the DataGrid for web applications. Here we go.. This control can be used as the regular MS DropDownList in the DataGrid and also as a regular dropdownlist. It has all the properties, like DataTextField, DataValueField, DataSource, SelectedIndex etc. The download file contains the samples both in VB.NET and C#. In this sample, I have used the Northwind database of SQL Server.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend