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 gkittelson 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. techmaniac15

    declaring a temp table variable.

    Golf_GetPlayers is a stored procedure. I ended up just using a string select on the table instead. Thank you for the information. Just for my personal knowledge, if I'd made @Players #Players that would have made the original code work?
  2. techmaniac15

    declaring a temp table variable.

    This SP throws a syntax error on @players declaration. That doesn't appear to be the problem though, as debugging I've determined it's somewhere else in the code... BUT WHERE!?? ALTER procedure [dbo].[Golf_ModifyPlayers] @paramID int, @paramPlayerNames varchar(500) AS declare @spot int...
  3. techmaniac15

    dynamically enter records

    Thanks, I've used this technique now and it's working as planned. Your response is highly appreciated.
  4. techmaniac15

    dynamically enter records

    Wow... NOBODY?
  5. techmaniac15

    dynamically enter records

    I'm trying to have a stored procedure that enters the information for a golf registration. I'd like to dynamically add the players based on how many they registered. So either 2,3 or 4. The code for the SP: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER procedure...

Part and Inventory Search

Back
Top