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!

Search results for query: *

  1. misgirlny

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

    CREATE FUNCTION claim_procs ( @claim varchar(12) ) RETURNS @pivot TABLE ( proc1 char(5), qty1 int, proc2 char(5), qty2 int, proc3 char(5), qty3 int ) AS BEGIN declare @temp_pivot table ( proc# char(5), id_num int IDENTITY(1,1), rec#...
  2. misgirlny

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

    Hi stnkyminky, It took me awhile to refresh my memory. So I was trying to create a table claim#,proc1,qty1,proc2,qty2,proc3,qty3 using the following query: select claim#,y.proc1,qty1,y.proc2,qty2,y.proc3,qty3 from claims_tables, udf_claim_procs(claim#) y I mistakenly expected that for...
  3. misgirlny

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

    Thank you for your response. You are probably right. I assumed that in my case the UDF result set(table) is working like a correlated subquery in the FROM clause and produces result set for each claim# from the outer query. I'll try to modify UDF. Thanks again
  4. 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...
  5. misgirlny

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

    Thank you for you response. Unfortunately it does not work that way when subreport is based off a stored procedure with the same set of parameters that a main report. when I link the reports on a set of parameters, subreports promt for the main report passed parameters and for subreport's...
  6. 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...
  7. misgirlny

    How do I import data from one table to another conditionally?

    If I undestand correctly what you need to do - the solution is very simple: update asset set department = u.department from asset a,users u where a.login = u.login
  8. misgirlny

    Exclude data from a query

    In fact what your query does is the following: select * from activity where product_code between 'committee/104' and 'committee/199' and thru_date >= getdate() and action_codes in ('m','a') order by product_code What exactly you want to do?
  9. misgirlny

    Help with dynamic column names

    Try this: Execute ('ALTER TABLE eodReport ADD' + @idx + ' int')
  10. misgirlny

    Restoring a database

    Follow the recommendations in the article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q304692 I used those recommendations when moved SQL Server DBs across the network.

Part and Inventory Search

Back
Top