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 Wanet Telecoms Ltd 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: misgirlny
  • Content: Threads
  • Order by date
  1. misgirlny

    'claim#' is not a recognized OPTIMIZER LOCK HINTS option.

    Hi there, I'm running the following query (SQL Server2000): select claim#,y.proc1,qty1,y.proc2,qty2,y.proc3,qty3 from claims_tables, udf_claim_procs(claim#) y udf_claim_procs is a user-defined function accepting one parameter claim# which is a primery key for claims_tables, and...
  2. misgirlny

    linking a main report to a subreport based off a stored procedure

    If anybody knows how to link a main report to a subreport on a parameter value if both are based off store procedures? I would like the main report's parameter values are passed to the subreports store procedures. I know how to do that if subreports a based off linked tables, but need to...

Part and Inventory Search

Back
Top