SQL Server Performance

Recent Activity

Activity stream for all registered members at SQL Server Performance Forums.

  1. Leo P replied to the thread Retrieving values from two columns based on different conditions.

    hello Moh, thanks for your reply, but I'm afraid I am not getting the result expected. here's what...

    Oct 30, 2014 at 12:34 AM
  2. SQL_notsure replied to the thread create better SQL storedProc in SQl 2008.

    Thank you for all your help. I tried everything exact and the ExecuteReader still generates error...

    Oct 29, 2014 at 7:50 PM
  3. moh_hassan20 replied to the thread create better SQL storedProc in SQl 2008.

    @sql_notsure //I am trying to pass the 4 values of @Field to my 'If else statement' here: If...

    Oct 29, 2014 at 3:21 PM
  4. moh_hassan20 replied to the thread Retrieving values from two columns based on different conditions.

    Welcome Leo, If I understand your question , the query is: select max (hwtype) hwtype , max...

    Oct 29, 2014 at 12:35 PM
  5. SQL_notsure replied to the thread create better SQL storedProc in SQl 2008.

    Thank you Moh for the suggestions. I need that kind of help. I also want to change my parameter...

    Oct 29, 2014 at 12:09 PM
  6. Leo P posted a new thread.

    Retrieving values from two columns based on different conditions

    hello SQL Experts, I have a question for you all. I have 'inherited' a DB at work and I have to...

    Forum: ALL SQL SERVER QUESTIONS

    Oct 29, 2014 at 7:25 AM
  7. vignesh123 set their location as chennai.

    Oct 29, 2014 at 2:38 AM
  8. moh_hassan20 replied to the thread create better SQL storedProc in SQl 2008.

    BTW, Avoid using sp_ as a prefix for naming stored procedures :) In SQL Server, the sp_ prefix...

    Oct 27, 2014 at 2:48 PM
  9. moh_hassan20 replied to the thread create better SQL storedProc in SQl 2008.

    The procedure returns data (select .. from ) , so you should use ExecuteReader not ExecuteNonQuery...

    Oct 27, 2014 at 1:51 PM
  10. SQL_notsure posted a new thread.

    create better SQL storedProc in SQl 2008

    I have a stored procedure I inherited that has 2 parameters @Field and @Search that I do not like,...

    Forum: ALL SQL SERVER QUESTIONS

    Oct 27, 2014 at 12:31 PM
Loading...