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 bkrike 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: thminer
  • Content: Threads
  • Order by date
  1. thminer

    variables in a table name

    i am trying to figure out if naming a table with a declared variable is possible. i have a stored procedure that runs one time a week. when i run the sproc, i enter a variable known as @weeknumber. i would like the result set to write to a table with the name of the @weeknumber variable. for...
  2. thminer

    syntax issues with if else stmt

    hey all having some trouble with this if else. getting errors like "error 209 - ambiguous column name emEmployee" this is because column emEmployee is in all of the joined tables. thanks for the help. IF EXISTS (Select * From tblbonus WHERE emSelect1 = 'Salary') Begin Select...
  3. thminer

    error in exporting report to sql server

    i am having more problems exporting reprots to sql server. my report has a group header for the records it pulls from the source tables. when i try to export the report, the error message is "column names in each table must be unique. column GH2_employee in table CREXPORT is specified more...
  4. thminer

    exporting to sql db in crystal 8.0

    i am trying to export a report into a table on a sql server. i am receiving error messages "Line1: syntax error near >". no more explanation is offered. where can i find out how to fix this error? it exports fine to excel
  5. thminer

    exporting to sql db in crystal 8.0

    i am trying to export a report to a sql db and am receiving sql errors such as Line1: error near '>'. is there a way to find this error or get around it?
  6. thminer

    SQL training

    does anyone know the best place to find online or CD based SQL training? i need it to be self paced so that i can learn faster than a traditional training class. CD is better for me, but anything will do. thnx
  7. thminer

    error 512- newbie

    i am now having difficulty with error 512, "Server: Msg 512, Level 16, State 1, Procedure WeeklyBonus, Line 40 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression." the issue is that there are...
  8. thminer

    Newbie- variables in stored procedure

    I have a problem with defining variables in my stored procedure. i need the proc. to pull in a bunch of data and do some calc's with about 10 variables. the variable @productivity. is a series of if then statements and calculations. i do not know the proper syntax for this variale. please...

Part and Inventory Search

Back
Top