User Profile

Collapse

Profile Sidebar

Collapse
sqlDon
sqlDon
Last Activity: Mar 28 '08, 02:43 PM
Joined: Oct 11 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • sqlDon
    started a topic Extranet web apps with authentication
    in .NET

    Extranet web apps with authentication

    We have two Web applications. Developed in Visual Studio 2003 .NET C#.

    Web application1 is on ExtranetServer1
    Web application2 is on ExtranetServer2

    Users, outside our network, are challenged with a Windows login and password, when accessing the home page of application1 (as expected).

    However, we have a hyperlink to a menu for application2 on Extranet2. They again are challenged to enter their...
    See more | Go to post

  • sqlDon
    replied to Extranet web apps with authentication
    Thanks CroCrew. I will try reposting under the .NET forum
    See more | Go to post

    Leave a comment:


  • sqlDon
    started a topic Extranet web apps with authentication

    Extranet web apps with authentication

    We have two Web applications. Developed in Visual Studio 2003 .NET C#.

    Web application1 is on ExtranetServer1
    Web application2 is on ExtranetServer2

    Users, outside our network, are challenged with a Windows login and password, when accessing the home page of application1 (as expected).

    However, we have a hyperlink to a menu for application2 on Extranet2. They again are challenged to enter their...
    See more | Go to post

  • sqlDon
    started a topic Help with Subquery

    Help with Subquery

    I am looking for some suggestions for rewriting a subquery to be more efficient.

    Select * from A where A.col1+A.col2 in (Select A.col1+A.col2 from A where A.Col3 = 'TEST1' and A.Col4 = 'TEST2')

    The above works, but is slow.

    I know this can probably be written using a JOIN to be more efficient, but everything I am trying is not returning what I want.

    Thanks
    See more | Go to post

  • sqlDon
    started a topic Parameterized Query Performance Help!

    Parameterized Query Performance Help!

    I am having trouble with paramterized query. This will end up being a stored procedure in the end, but for now I am working with it in Query Analyzer.

    DECLARE

    @Tax_ID varchar(9)
    @Badge_ID varchar(9)

    SET @Tax_ID = '1234'
    SET @Badge_ID = '5678'

    Select * from Test where tax_id = @Tax_ID and badge_id = @Badge_ID


    -This executes and returns 17 records in...
    See more | Go to post
No activity results to display
Show More
Working...