Forum Replies Created

Viewing 15 posts - 4,816 through 4,830 (of 8,731 total)

  • RE: Problem in procedure

    j.grimanis (6/16/2015)

    The second procedure( which does not work correct some times) is being executed after a "Commit Transaction" inside the first proc. Is there a possibility that rows are...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 16, 2015 at 9:10 am

    #1805763

  • RE: Problem in procedure

    j.grimanis (6/15/2015)

    Hi,

    I have a procedure which inside I call two other Procedures, the first one is updating table Purchase Order and the second one is updating an intermediary table afterPurchase...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 15, 2015 at 2:21 pm

    #1805579

  • RE: Cannot return correct value in SQL statement

    The column t00.[CustNo] is never NULL, so you'll always end up with a value of 0.

    You don't need the nested CASE, you can just add more conditions as needed.

    Select t00.[InvDate]

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 15, 2015 at 2:17 pm

    #1805578

  • RE: Concatenation of three fields with conditional parenthesis around last two fields for a field in a View

    Full example:

    CREATE TABLE dbo.SampleData(

    Stip_Abv nvarchar(10),

    Dt_Start nvarchar(10),

    Dt_End nvarchar(10))

    INSERT INTO SampleData

    VALUES( 'PM', '05/15', '06/20'),

    (...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 15, 2015 at 2:07 pm

    #1805574

  • RE: Concatenation of three fields with conditional parenthesis around last two fields for a field in a View

    If you can have either start date and end date or no dates at all, you can make it simpler.

    ISNULL(dbo.APD_Stips1.Stip_Abv + N' ', N' ') + ISNULL( N'(' + dbo.APD_Stips2.Dt_Start...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 15, 2015 at 2:01 pm

    #1805573

  • RE: No of Months between two dates in YYYYMM format

    sgmunson (6/15/2015)

    sqlinterset (6/15/2015)

    I am looking to calculate no of months between two dates which are in YYYYMM format.

    Like no of months between 201505 and 201305

    WITH DATEFIELDS AS (

    SELECT DATEFIELD1 =...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 15, 2015 at 1:50 pm

    #1805569

  • RE: Need help converting excel pivot table to SSRS

    From your private message, I could understand that your 2 recordsets have the same information but one has details and the other one has totals. SSRS is able to group...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 15, 2015 at 8:51 am

    #1805470

  • RE: Lock level

    You don't need an explicit transaction for a single statement.

    Using a top 1 in an update makes no sense.

    Your WHERE clause is not SARGable. A possible better way would be...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 14, 2015 at 4:35 pm

    #1805374

  • RE: SQL Join

    Your join condition will never evaluate TRUE and that's why you're always getting NULLs.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 14, 2015 at 4:23 pm

    #1805371

  • RE: Need help converting excel pivot table to SSRS

    There's a problem here. Even if you explained exactly what you need to do, it's too generic. We can't help with the stored procedure because we can't see it. We're...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 12, 2015 at 2:20 pm

    #1805233

  • RE: Prompt for Date Range?

    tsobiech (6/12/2015)

    Luis Cazares (6/12/2015)

    Or you could use SSRS to create a nice report with parameters that can be exported to Excel, Word, PDF & others.

    The Stairway to Reporting Services will...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 12, 2015 at 1:53 pm

    #1805224

  • RE: Prompt for Date Range?

    Or you could use SSRS to create a nice report with parameters that can be exported to Excel, Word, PDF & others.

    The Stairway to Reporting Services will guide you step...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 12, 2015 at 1:21 pm

    #1805218

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/12/2015)

    Alvin Ramard (6/12/2015)

    Lynn Pettis (6/12/2015)

    Has anyone ever heard about "disk unformating?" Did not know if you formatted your hard drive you could undo it. Maybe if...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 12, 2015 at 10:54 am

    #1805154

  • RE: Are the posted questions getting worse?

    I suppose that you could create an unformatted partition for the disk or simply deallocate all the space. I'm not sure what are you referring to.

    Also, a disk corruption might...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 12, 2015 at 10:51 am

    #1805151

  • RE: Beginner wants general overview

    Try the stairways[/url] on this site or the books section[/url] or even the Videos. The entire site is full of valuable information on SQL Server and we'll be happy to...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 12, 2015 at 9:38 am

    #1805098

Viewing 15 posts - 4,816 through 4,830 (of 8,731 total)