Forum Replies Created

Viewing 6 posts - 1 through 7 (of 7 total)

  • RE: Stored proc with variables

    Thx Gail,
    you are the second, who advice me for not use dynamic code
    i'am a beginner and every advice is very welcome,
    So i go try one other solution...

    Ken er nog niet veel van, maar leer het wel
    Do not know much about it yet, but learn

    February 6, 2018 at 4:18 am

    #1978674

  • RE: Stored proc with variables

    Thx John
    you helped me very fast,
    and i go try to do something on this injection,

    Ken er nog niet veel van, maar leer het wel
    Do not know much about it yet, but learn

    February 5, 2018 at 8:45 am

    #1978567

  • RE: Stored proc with variables

    Dear John 
    i  try only to look in the table @dbname
    without the variable 

    Ken er nog niet veel van, maar leer het wel
    Do not know much about it yet, but learn

    February 5, 2018 at 8:17 am

    #1978557

  • RE: Nested If statements

    Thx mr Eriksson for your quickley reaction
    15 years ago i create 1 app in Delphi with foxpro as database
    now i wil create this in VB.net and Sql Server

    Ken er nog niet veel van, maar leer het wel
    Do not know much about it yet, but learn

    November 18, 2017 at 2:44 am

    #1968636

  • RE: ORDER BY with CASE in SELCT DISTINCT

    Thx Cris for this good and quickly reaction
    ORDER BY CASE @id WHEN 1 THEN varieteit ELSE stockeerder END DESC
    I hav done what you proposed ans it works very...

    Ken er nog niet veel van, maar leer het wel
    Do not know much about it yet, but learn

    July 24, 2017 at 11:52 am

    #1952436

  • RE: ORDER BY with CASE in SELCT DISTINCT

    Sorry for my bad first question, i hope that i follows the rules now😉
    --===== If the test table already exists, drop it
      IF OBJECT_ID('TempDB..#Multisorting','U') IS NOT...

    Ken er nog niet veel van, maar leer het wel
    Do not know much about it yet, but learn

    July 24, 2017 at 7:47 am

    #1952371

    • Viewing 6 posts - 1 through 7 (of 7 total)