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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by BrianMarsh

  1. BrianMarsh

    IIS Sessions or Threads Problem

    ttt
  2. BrianMarsh

    IIS Sessions or Threads Problem

    I have a problem on a client system that I do not have access to. The problem appears to be connected to IIS. We have our webclass dll's and site out there working fine, however, occasionally, it appears that either sessions or threads of IIS are crossing. If you open two browsers and log...
  3. BrianMarsh

    Getting the record(s) returned from exec

    nm, figured it out.
  4. BrianMarsh

    Getting the record(s) returned from exec

    i spoke too soon. it looks to do the same thing as if i just executed the statement using execute ("select blah blah"). @amount3 prints out blank. the value is not assigned to it. am i doing something wrong? here is my code... Declare @BenefitAmount nvarchar(20), @amount3...
  5. BrianMarsh

    Getting the record(s) returned from exec

    that worked great! can't thank you enuf. one question more tho. what is the N for? pardon my ignorance, i'm very new to SQL and still learning.
  6. BrianMarsh

    Getting the record(s) returned from exec

    Basically, I have a field in a table that has a calculation with a field name. "1.5*Census.Pay1/12" So thats 1.5 times the field Census.Pay1 divided by 12. Now, based on the number that is returns, which is the monthly amount of pay, I need to determine the cost. The cost is...
  7. BrianMarsh

    Getting the record(s) returned from exec

    I am building a string from info found in a database. I then execute that string. execute(select * from whatevertable); in query analyzer it works find and returns the value i need. my question is, how can i use the values it gives me inside the stored procedure that it is in. I cannot...
See more

Part and Inventory Search

Back
Top