Forum Replies Created

Viewing 15 posts - 2,836 through 2,850 (of 15,381 total)

  • RE: Stored Procedure Creation

    v.malyutin (5/19/2015)

    Sean Lange (5/19/2015)

    v.malyutin (5/19/2015)

    The question is incorrect. The procedure is executed 32 times. Or there must be an answer regarding recursion.

    It executes inside an implicit transaction until it raises...

    May 19, 2015 at 12:42 pm

    #1799131

  • RE: How to choose which row to use

    giszzmo (5/19/2015)

    Awww how sad for you. You must think nobody works in education. How narrow minded of you.

    And being condescending is NOT a good way to illicit help from...

    May 19, 2015 at 7:57 am

    #1799026

  • RE: Stored Procedure Creation

    v.malyutin (5/19/2015)

    The question is incorrect. The procedure is executed 32 times. Or there must be an answer regarding recursion.

    It executes inside an implicit transaction until it raises an exception and...

    May 19, 2015 at 7:54 am

    #1799025

  • RE: SQL Equivalent of Oracle OVER (PARTITION BY ORDER BY RANGE UNBOUNDED PRECEDING)

    xizwyck (5/18/2015)

    It's 2015. Just had to say, thank you for not even trying to answer the question. You are technically correct; however, very unhelpful to those who might stumble across...

    May 18, 2015 at 11:56 am

    #1798751

  • RE: Alternate to CASE in SQL

    newbieuser (5/18/2015)

    Hi Sean

    It is an error from our application.. not sure if will help

    “An attempt was made to call a stored procedure that expects a boolean value.”

    Thanks

    Well that certainly...

    May 18, 2015 at 10:55 am

    #1798722

  • RE: Alternate to CASE in SQL

    newbieuser (5/18/2015)

    Thanks Luis.. We will try it out..

    Sean, the query works from SQL Server but not from the application. So we are trying to try alternate SQLs..

    Thanks

    Yes you...

    May 18, 2015 at 10:45 am

    #1798718

  • RE: how to run a transaction accross multipale instance of sqlserver without linked server

    rajemessage 14195 (5/18/2015)

    hi,

    i want to run a transaction across mulitpule instences of sqlserver with out linked server.

    distributed trnasaction can do it with link server ,...

    May 18, 2015 at 10:24 am

    #1798705

  • RE: Alternate to CASE in SQL

    newbieuser (5/18/2015)

    Hi friends,

    We are getting an error for the below query via application program, it works from the database. Wondering if it is possible to tweak the SQL...

    May 18, 2015 at 10:22 am

    #1798704

  • RE: implicit conversion failure varchar to numeric using DelimitedSplit8K function

    ChrisM@Work (5/18/2015)

    Sean Lange (5/18/2015)

    There is something missing here for sure. You stated that you use the DelimitedSplit8K function in your 2000 instance. In the original format it would NOT work...

    May 18, 2015 at 10:18 am

    #1798700

  • RE: implicit conversion failure varchar to numeric using DelimitedSplit8K function

    There is something missing here for sure. You stated that you use the DelimitedSplit8K function in your 2000 instance. In the original format it would NOT work in 2000 because...

    May 18, 2015 at 8:59 am

    #1798662

  • RE: Need help writing SQL query

    mw112009 (5/18/2015)

    No HELP needed.. I figured out

    Select *

    FROM

    (

    Select Pat_ID, reg, date_of_lvad, method_found as [method_found]

    FROM ABCD

    )as s

    PIVOT

    (

    COUNT(method_found)

    FOR [method_found] in ( [QUERY-4301],[QUERY-4723],[REGISTRY],[REGISTRY-(NO ADM DT)] )

    )AS p

    Glad you figured it...

    May 18, 2015 at 8:11 am

    #1798630

  • RE: Here are some SQL Server Interview Questions

    Michael L John (5/18/2015)

    Jeff Moden (5/18/2015)

    andrew gothard (5/18/2015)

    Jeff Moden (5/14/2015)

    This one is actually true.

    Me, the interviewer: As the Lead Developer on this project, we're very interested in someone that...

    May 18, 2015 at 8:10 am

    #1798628

  • RE: Need help writing SQL query

    mw112009 (5/18/2015)

    Please see attached. It comes from a table by the name 'HOS_EMPLOYEES'

    I need to write a PIVOT statement that will produce the following columns:

    pat_id, date_of_lvad...

    May 18, 2015 at 7:50 am

    #1798617

  • RE: Here are some SQL Server Interview Questions

    Jeff Moden (5/15/2015)

    Lynn Pettis (5/15/2015)

    Jeff Moden (5/14/2015)

    Luis Cazares (5/14/2015)

    You receive a late call during the night to inform you that the server is down and must be working correctly before...

    May 16, 2015 at 10:42 am

    #1798427

  • RE: Here are some SQL Server Interview Questions

    David Webb-CDS (5/15/2015)

    Sean Lange (5/15/2015)

    David Webb-CDS (5/15/2015)

    Your customer comes to you and says the query he has run daily for the last two years is suddenly taking hours instead of...

    May 15, 2015 at 1:58 pm

    #1798335

Viewing 15 posts - 2,836 through 2,850 (of 15,381 total)