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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Want to show all rows from one table but only those relating to a single week in the other

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server
 
This must be a simple one and I am just having a block
I have two tables, Personnel and working details.
I want to show all staff working in a single building but only the working details for a specific week
I have added a join which should list all staff but won't because of the date filter in the working detail table it returns only an exact match, I have added ' or is null' for the date filters but just returns all staff from all buildings
SELECT        [8977].cTblPersonnel.Firstn, [8977].cTblPersonnel.Surname, [8977].cTblWagesFcst.StartDate
FROM            [8977].cTblWagesFcst RIGHT OUTER JOIN
                         [8977].cTblPersonnel ON [8977].cTblWagesFcst.PersonnelID = [8977].cTblPersonnel.PersonnelID
WHERE        ([8977].cTblPersonnel.UnitID =544) 

View Complete Post


More Related Resource Links

no of rows in single table

  
hi friends...i need one count...one sql table how many rows able to create or write in sql server 2005

Using jQuery to Filter Table Rows

  
The project is using the .net GridView control, so I had limited control over the output HTML code. Still, I think this code can work for most tables. One thing to notice: you should use the class "filterable" on your table or on one of its parents for the code to work.
First, we need a text box:

RadioButton Groups, Table Rows And NamingContainers in asp.net

  
The RadioButtonList. Very handy for inviting users to select just one item from a list although because of the screen real estate it takes up, used less and less in favour of the DropDownList. In plain HTML, the browser knows to enforce the unique selected value amongst a list of radio buttons because they all have the same value for their name attributes.

RadioButton Groups, Table Rows And NamingContainers

  
(In which AJAX-enhanced CheckBoxes become more useful than RadioButtons but inheritance saves the day, and a simple RadioButton-derived control establishes the purpose of a control's naming container)

The RadioButtonList. Very handy for inviting users to select just one item from a list although because of the screen real estate it takes up, used less and less in favour of the DropDownList. In plain HTML, the browser knows to enforce the unique selected value amongst a list of radio buttons because they all have the same value for their name attributes.

merging multiple tables in a single dataset to single table

  

 i have a stored procedure which returns three tables to a dataset ..... now i need to merge all three tables to a single table from d same dataset 


like dataset1 has table1 table2 and table3 .... i want all the three tabels to be merged into dataset1 itself .... instead of three diffrent tables so that i can show all three table data in a single datagrid  as a compact data and combination of 3 tables from d single dataset.....



can some1 help me please.....


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

label inside table inside div won't show

  
I have a label inside a table cell that is coded to change backcolor conditionally. The table is inside a div tag. The label doesn't appear at runtime. Has anyone experienced this before? Is there a workaround? Thanks. 

How to get the Top N rows from SQL Table..

  
Hello Friends..                 Recently i have come across one question in sql queryQuestion:         Which SQL Query helps to view the TOP N rows From the particular SQL table?I request anyone please solve this question... Thanks...                   

Expand rows in a data grid to show details in the same page

  
<asp:templatecolumn headertext="Purchase Order"> <headerstyle horizontalalign="center"></headerstyle> <itemstyle horizontalalign="center"></itemstyle> <itemtemplate> <%# DataBinder.Eval(Container.DataItem, "PurchaseOrder") %> </itemtemplate> </asp:templatecolumn> <asp:templatecolumn headertext="Order"> <headerstyle horizontalalign="center"></headerstyle> <itemstyle horizontalalign="center"></itemstyle> <itemtemplate> <a href="OrderDetail.aspx?Order=<%# DataBinder.Eval(Container.DataItem, "OrderNumber")%>"> <%# DataBinder.Eval(Container.DataItem, "OrderNumber") %> </a> </itemtemplate> </asp:templatecolumn> <asp:templatecolumn headertext="Ack Date"> <headerstyle horizontalalign="center"></headerstyle> <itemstyle horizontalalign="center"></itemstyle> <itemtemplate> <%# DataBinder.Eval(Container.DataItem, "AcknowledgeDate") %> </itemtemplate> </asp:templ

Report Builder 2.0: duplicate rows do not show on reports

  
Hello,Created a report using a report model.the problem is that duplicate rows do not show on the report.Why?And also how can this be fixed?the report shows product ids, that may or may not have serial numbersticket numbers can have mulitple products associated with them and they may or may not have serial numbersthe report data row is as follows:example:order number, ticket number, product id, manufacturer id, serial number123                  456               dsl_router 12  cisco123                  456               dsl_router 12  ciscothe above data shows as one row on the report, thus, showing it to be one product, but really there are 2 products and there should be 2 rows.is this a bug?how can this be fixed?Thanks.

Tricky SELECT query from a Single Table

  
Hi I have a 2 rows of data in a table as mentioned below   Table1             ElementID Month Year Planned Cost UnplannedCost PlannedExpense UnPlannedExpense 4 9 2010 NULL 40 NULL 20 4 9 2010 400 NULL 200 NULL  I need a SELECT query to get the output in a single row as ElementID Month Year Planned Cost UnplannedCost PlannedExpense UnPlannedExpense 4 9 2010 400 40 200 20 Could anybody help me in writing a query for this? Thanks

Duplicate rows in Table

  
Hi, I have a table with two rows Name  ||    Surname || Account No || Money Expensise || Amount                                                     Total ------------ Amount How can I display the last row Total at the bottom of the table not for every first row.  Thanks Anyone helps!

Grouping by week, but show day range

  
SELECT SUM(T.SPEED_OCCURRENCES) AS TOTAL_SPEED_OCCURRENCES, CONVERT(NVARCHAR, DATEPART(WEEK, T.DATE), 101) AS STRDATE FROM VEHICLE_TRENDS T, @VIEWABLE V WHERE T.VEHICLE_ID = V.VEHICLE_ID AND T.DATE BETWEEN @START_DATE AND DATEADD(DAY, 1, @END_DATE) GROUP BY DATEPART(WEEK, T.DATE) ORDER BY [STRDATE] ASC; So we have a query that returns results like: TOTAL_SPEED_OCCURRENCES       STRDATE 34                                               34 45                                               35 67                                               36 Where STRDATE is the week number. This is correct grouping, but we want STRDATE to select the range of day

generate dinamic rows with tetxbox in asp:table

  
) dynamically generated new rows containing two columns, one with a display name and the other a textbox for the user to enter a value. " ye="Hola, en TablaVenta () genero dinamicamente nuevas filas que contienen dos columnas una con un nombre para mostrar y la otra un textbox para que el usuario ingrese un valor." closure_uid_83htk5="176" mce_style="BACKGROUND-COLOR: #ebeff9">Hello, in TablaVenta (<asp:table>) dynamically generated new rows containing two columns, one with a display name and the other a textbox for the user to enter a value.When I want to retrieve those rows from the code, I notice that there are no rows created in the tableList<BLL.Producto> productos = new List<BLL.Producto>(); for (int i = 0; i <= TablaVenta.Rows.Count; i++) { TableRow tr = new TableRow(); tr = (TableRow)TablaVenta.Rows[i]; for (int c = 1; c <= tr.Cells.Count; i++) { BLL.Producto unProd = new BLL.Producto(); unProd.Nombre = TablaVenta.Rows[i].Cells[c].Text;   Error: Specified argument was out of the range of valid values.Parameter name: index Do you know, what i can will do? Thankss

Want to show FormView in Edit mode with specific table columns depending on their Genre??

  
hi, I have  a table in my database called "Profiles". This holds data on Female and Male personal characteristics. On my aspx, I have a formview in edit mode which is binded to an object data source with a GetDataByUserId Select method which retrieves data from the "Profiles" Table via a DAL. The "Profiles" table has some columns which relates to females only and some just males and some are generic to both. See example below     UserId - / of Type GUID GenreId /  of Type BOOL. Hip Size (For females) Dress Size ( For Females) ChestSize (For Men ) TrouserSize (For Men) Weight ( For both )   When the User logs in , they go to an update Page which has the Formview in Edit Item Mode and contains drop down Lists which are binded to the Users Selected Value. The DDL are in turn bound to their related table such as HIP, Dress, Chest, Trouser etc. Objective If a female user logs in I just want to show them the (Hip Size) DDL  and DressSizeDDL in the Edit item template of the formview and not the ChestSize DDL or  TrouserSize DDL. At present the GetProfileByUserId returns all colums from the table My question is how do I do this and just show DDL which are relevant to the Female or Male Only. In some cases the user may not have selected an item in the previous form so they could also be

How to get column value difference of rows in same table

  
Dear all, I need a TSQL statement to find the difference of values of two rows in the same table, by taking into consideration some conditions. I have the following rowss in a table named table1 dbname  sqlinst     size1   ddate sqldb1    inst1        200    1/1/2009 sqldb1    inst1        250    1/1/2010 sqldb1    inst1        170    1/1/2008 sqldb2    inst2        300    1/1/2009 sqldb2    inst2        340    1/1/2010 I need to find the difference between size1 values, for columns where their dbname and sqlinst are the same. I also need to define in TSQL that the ddate of row from where I subtract (size1) from is 1/1/2010 and that the ddate of the row I subtract (size1) is 1/1/2009 (e.g. in the above example: for sqldb1 inst1, I need to perform 250-200 and ignore 170, and for sqldb2 inst2  340-300). Please let me know if you have a solution for this. A million thanks!

How to declare a table variable in SSIS and then insert rows into it

  
Hello everyone,   I'll try to explain my problem as clearly as I can: 1)I have an Execute SQL Task that's inside a Foreach Loop Container. 2)Inside the Execute SQL Task, I have an int OUTPUT column. 3)With each iteration, I need to insert the data from the INT output colum into a table variable. 4)After the Foreach Loop finishes the iterations, I need to use the table variable to create a report based on the data inside.   My question is the following: How can I declare a table variable so that I can do all of the above?   Thank you, CostinP
Categories: 
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