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 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 Selva123

  1. Selva123

    Working with strings wihtin Stored Procedures

    Hi Terry, I am using the set of codes for getting the empcode into one variable.I am getting tablename, where condition & orderby as an input parameters. set @sql = 'declare tempcursor cursor for Select empcode from ' + @tablename + ' where '+ @wherecondition + @Orderby Exec (@sql) OPEN...
  2. Selva123

    returning rows

    How to get the records between 5 and 10.? For example, If "select * from employee" is returing 100 records. How to get the records from 5 to 10? Selva Balaji
  3. Selva123

    Working with strings wihtin Stored Procedures

    Hi If I use above method, the following sql is not working "Select @tempvar = empcode from employee". What could be the problem?

Part and Inventory Search

Back
Top