Get User In Reporting Services

  • Andy Warren

    SSC Guru

    Points: 119676

    Comments posted to this topic are about the item Get User In Reporting Services

  • rhythmk

    SSCertifiable

    Points: 7162

    Good question.Thanks for question Andy.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Good one, Andy, thank you for the post.

    I got tricked by first two options, and I did not select the first one and selected the other feasible two. Even though it was very simple (at the end) but the wording had me. 🙂

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Bhaskar.Shetty

    Hall of Fame

    Points: 3054

    Even I missed the first choice and felt later how easy that could have been!!!!;-)

    Thanks.. Andy.. Good One

  • Mighty

    SSCrazy Eights

    Points: 8452

    Not really happy with the wording of the answers.

    I left the first option out, because the second option seemed "supersede" the first option.

  • This was removed by the editor as SPAM

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Stewart "Arturius" Campbell (5/26/2014)


    ...as I could not get it working using T-SQL.

    .. you mean, the auto insert?

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • This was removed by the editor as SPAM

  • Hany Helmy

    SSChampion

    Points: 13321

    Mighty (5/26/2014)


    Not really happy with the wording of the answers.

    I left the first option out, because the second option seemed "supersede" the first option.

    +1 Agree, @ least I got 2 out of 3 options right :unsure:

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Stewart "Arturius" Campbell (5/27/2014)


    Raghavendra Mudugal (5/26/2014)


    Stewart "Arturius" Campbell (5/26/2014)


    ...as I could not get it working using T-SQL.

    .. you mean, the auto insert?

    that's the one...

    (not trying to sound extreme smart here..)

    actually, I have done this in MSSQL 2000 database. The code was in the Trigger. Say, in one particular grid, where we can add more than 20 rows in the FE and then submit the page, it writes the data to the table and for each row, I need to generate a custom format unique code, some thing like this "APETE/32434/1/PO/2313-A" and I wrote the code in the trigger to take the next available number for "APETE" and increment by 1 or if "APETE" is being used for the first time, then insert, and get next number, all using plain T-SQL and update the data in the #inserted table and then reflect it to the main table.

    you were using 2008, it must be possible, or was there any other issue apart from T-SQL?

    (just a normal curiosity to know what could have gone wrong 🙂 )

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Gary Varga

    SSC Guru

    Points: 82166

    Terrible "side effect" coding style!!!

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • PChiragS

    SSCarpal Tunnel

    Points: 4965

    got one option wrong.

    but great question.

    thanks Andy.

  • SQLRNNR

    SSC Guru

    Points: 281210

    Gary Varga (5/27/2014)


    Terrible "side effect" coding style!!!

    +10

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Koen Verbeeck

    SSC Guru

    Points: 258940

    Interesting question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Ken Wymore

    SSCoach

    Points: 16387

    Never used that proc before. Thanks for the question Andy!

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply