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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: ReportingAnalyst
  • Content: Threads
  • Order by date
  1. ReportingAnalyst

    How to show this data as indented?

    Hi, This is my result set from which I would like to show an indented hierarchy: Emp_Name Indent Mgr_ID Sub_ID Lft Rgt William McMonigal 4 862336 862336 604 617 David Block 5 862336 627298 605 606 Joseph Hennessy 5 862336 862337 607 608...
  2. ReportingAnalyst

    How to modify the query to get the required resultset?

    Using this query, I got the indentation of everybody in the orgstructure. I just showed the data for one top level manager - W. McMonigal so that you can see the indentation for him and his subordinated who have the indentation of 5. The query I made to get this indented Org Structure is...
  3. ReportingAnalyst

    Unknown Runtime Error Message

    Hi, This question is related to AJAX. I am trying to display a list of products for the category "Beverage" using the Northwind database. When I click on the link "Beverage", I get thie error - "Unknown runtime error". In the code below, I made the error line bold. What is causing it? My...
  4. ReportingAnalyst

    Nested structure.

    Hi, I have 2 seperate queries from a nested table structure. This query returns the emp and his subordinates. SELECT s2.*, dbo.Employee.FirstName + ' ' + dbo.Employee.LastName AS Emp_Name FROM dbo.Stack1 s1 INNER JOIN dbo.Employee ON s1.employee =...
  5. ReportingAnalyst

    How to show indentation?

    Hi, I built indentation that would show the the hierarchy of the people in the org structure in the SQL Server database. So I have got rows with values like this: Indentation Employee 1 4655 2 5623 2 8956 2...
  6. ReportingAnalyst

    Indentation

    Hi, In the process of building a nested table from a adjancency table, I built indentation that would show the the hierarchy of the people in the org structure. So I have got rows with values like this: Indentation Employee 1 4655 2 5623 2...
  7. ReportingAnalyst

    What is the meaning of this syntax?

    Hi, I am trying to get a list of subordinates from a nested table model. What is the meaning of the bold part in the SQL query below? SELECT P2.* FROM Personnel AS P1, Personnel AS P2 WHERE P1.lft BETWEEN P2.lft AND P3.rgt AND P2.emp = :myEmployee; Thanks.
  8. ReportingAnalyst

    Why do I have to doubleclick on this link to see?

    Hi, Hi, I have link on which I click and I am able to see all the products for the link. However when I refresh it, I need to click on the link 2 times and it displays and hides the products below the category link. Thereafter when I click on the link once, I get to show and hide the products...
  9. ReportingAnalyst

    Object Required Error

    Hi, I built a small ASP page which pulls the top level category "Beverage" from Northwind database. When I click on the link, Beverage, I can see all the products that fall under the category "Beverage". However I would like to click on the link again to hide the products and click on the link...
  10. ReportingAnalyst

    ASP function with AJAX calls

    Hi, Can you please let me know what I am doing wrong in the ASP and AJAX part because I do not seem to be calling the AJAX function properly... What I would like to see is onload of the page, I see only the top level category "Beverage" which is a link. When I click on the "Beverage", then I...
  11. ReportingAnalyst

    Row_Number()

    Is Row_Number() a function within SQL Server 2000? I guess not, because it errs. My code is: INSERT INTO chain1(seq, emp, chain) SELECT row_number() Over (order by chain) as seq, emp, chain from Organization
  12. ReportingAnalyst

    "No column was specified" Error

    Hi, I get the error: No column was specified for column 4 of 'organization'. in the following code: select * from ( select 1 as depth, emp, boss, cast(rtrim(emp) as varchar (400)) from tree where boss is null union all select a.depth + 1 as depth...
  13. ReportingAnalyst

    Error Syntax with 'WITH'

    What is the syntax error near the WITH statement? Thanks. with organization (depth, emp, boss, chain) as ( select 1 as depth, emp, boss, cast(rtrim(emp) as varchar (400)) from tree where boss is null union all select a.depth + 1 as depth, b.emp...
  14. ReportingAnalyst

    Array assistance

    Hi, I request for form variables. I would like to grab all the values and dump into an array. How can I do that? I am trying to modify this part of the code to my case. I request from another form. I do not request from a URL. '/// Collect the Values wanted into the dictionary object for i =...
  15. ReportingAnalyst

    Infinite Loop - What could be causing it?

    I have a simple table Tree which has 6 rows of data. I want to convert this data to nested table Stack. But it seems that I am entering into an infinite loop. Any ideas what I am doing wrong... --select member_subordinate, member_manager --from amp_allmysubordinates_postings --WHERE...
  16. ReportingAnalyst

    How to check if a table exists?

    Hi, Before dropping a table, I would like to see if the table exists. Only if it exists, then I would like to drop it. Thanks.
  17. ReportingAnalyst

    Invalid Column Name Error

    Hi, Can anybody point me why I get the error "Invalid Column Name - emp" error. Thanks. Table structures are: Tree create table tree (emp Char(10) Not Null, Boss Char(10)); Stack CREATE TABLE Stack (Stack_top INTEGER Not Null, emp Char(10) Not Null, Lft Integer NOT NULL UNIQUE CHECK (Lft...
  18. ReportingAnalyst

    Left and Right in Nested Set Model

    Hi, I would like to convert my adjancey set model to a nested set model with a left and right. I understood this part. Root Node is always with a a Left = 1, right = 2*(Select Count(*) from Table) How do the leaf node get the left and right numbers. I was reading an article of Joe Celko...
  19. ReportingAnalyst

    AJAX with ASP

    Hi, I am building a sample ASP page which pulls from the Northwind database where I display the category Beverage and on click of the "Beverage" link, I can pass the category id to the sql statement to display the products which fall under the "Beverage" category. Now I want to include AJAX to...
  20. ReportingAnalyst

    Where do I post AJAX related questions?

    Where can I post AJAX related questions? THanks.

Part and Inventory Search

Back
Top