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

    Stored Procedure with a SELECT

    I have a Stored procedure that I want to have an 'if' statement in my SELECT statement. Can I do this. Here is an example of what I want to do: ALTER PROCEDURE AS SELECT fFirstName, fLastName, if(fLastName = 'Smith') then 1 as intTest else 2 as intTest, fPhone FROM tbEmployees Any help...
  2. JoshBN

    Stored Procedures

    I have a stored procedure that when I run it for the first each day, it takes 2 minutes to finish executing. After my first run each day of the stored procedure, it only takes around 5-6 seconds to run it. Does anyone have any ideas why this is or what I can do to speed up my first run of the...

Part and Inventory Search

Back
Top