Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. aselvan

    CSS and XML

    The display:none declaration can be used to suppress an element type. following code in CSS will suppress the publisher. publisher (display:none}
  2. aselvan

    Reference Column to Row

    Also, another approach could be select a.name as your_name , a.po_id as your_po_id , b.name as your_fathers_name from tablename a left outer join tablename b on a.po_id = b.id This also may work.
  3. aselvan

    NULL problem

    In ASP, it would be possible to pass a value null as a parameter to storedprocedure. Inside the stored procedure, it is possible to evaluate(instead of IF @Reason <> '') as below: IF @Reason is not null so is it possible to set null for parameter, in sp. If so, that may, take care of...
  4. aselvan

    Reference Column to Row

    You may want to give the following a try(I have not tried it). Assuming to determine the details of po_id for a specific @ID passed as a parameter. Select a.name as your_name , a.po_id as your_po_id , (select b.name as your_po_name from tableName b where b.id...
  5. aselvan

    where are my tables ?

    'Refresh' the view by right clicking on Tables.
  6. aselvan

    asp &amp; olap

    You may want to try this. Check the properties of sql server. Right click on server click the properties.click the security tab and and check authentication.Select sql server and windows mode. If the above works let me know. Thanks.
  7. aselvan

    How do I exculde the rows with null values while counting?

    I have a table named Job with columns Jobid, Industry & Wage. The measures I am interested are Count of Jobs and Count of Jobs with valid wage(ie. Wage > 0). The database is in MSSQL. How can I determine the number rows with value > 0 in Wage column? Thanks.

Part and Inventory Search

Back
Top