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 wOOdy-Soft 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 EBrownSQL

  1. EBrownSQL

    running sp_MakeWebTask from non admin acct

    I suggest you check the permissions on your stored procedure. Also, is dbo the owner of the stored procedure. If all this is correct, check the database role for the user trying to execute the stored procedure.
  2. EBrownSQL

    Changes not made, not using Shadow

    I am having the same problem with vss. But I've leaned this only occurs when I try to check in a report. The report has two seperate files with different extensions. One has an extension of .dsx and it appears to have been checked out and checked back in, but the file with extension .dsr...
  3. EBrownSQL

    is this nested select possible?

    Your select statement should look like this: Select c.case_id as 'CASE_ID', case when c.reaction_id_eyes is null then '(none)' else (select reactions.reaction_name_eyes from reactions where reactions.reaction_id = c.reaction_id_eyes) end as...
  4. EBrownSQL

    Passing a table name into a stored procedure as a variable

    I have to populate tables monthly for a printing job. Each table is populated using the same code. Is there a way to pass the table name into a stored procedure and have it populated. When I try to just pass it into the stored procedure I get an error, because the code does not recognize the...
See more

Part and Inventory Search

Back
Top