Forum Replies Created

Viewing 15 posts - 4,936 through 4,950 (of 8,731 total)

  • RE: Here are some SQL Server Interview Questions

    Alvin Ramard (5/15/2015)

    Grant Fritchey (5/15/2015)

    Alvin Ramard (5/15/2015)

    Grant Fritchey (5/15/2015)

    Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server,...

    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

    May 15, 2015 at 9:01 am

    #1798227

  • RE: Here are some SQL Server Interview Questions

    TomThomson (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 everyone arrives in the morning....

    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

    May 14, 2015 at 7:28 pm

    #1798053

  • RE: Running totals for previous X days

    I was wondering, why would you have a value before an event happened? Shouldn't you have zeros until the first real occurrence?

    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

    May 14, 2015 at 7:27 pm

    #1798052

  • RE: Here are some SQL Server Interview Questions

    You receive a late call during the night to inform you that the server is down and must be working correctly before everyone arrives in the morning. How many cups...

    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

    May 14, 2015 at 1:09 pm

    #1797993

  • RE: Running totals for previous X days

    Maybe this got overcomplicated and Dwain's solution is better. But I just thought it was good to give this a shot.

    DECLARE @DaysBefore int = 3; --Parameter?

    DECLARE @StartDate Date = dateadd(dd,...

    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

    May 14, 2015 at 12:53 pm

    #1797986

  • RE: Running totals for previous X days

    Now I get the point. It just didn't hit me because I thought that a filter would be the easy part. Of course is easier to get the logic 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

    May 13, 2015 at 3:37 pm

    #1797700

  • RE: QUESTION ABOUT MULTIPLE EXCEPT STATEMENTS

    It's possible, but you need to be sure that you're applying the correct precedence.

    From BOL:

    If EXCEPT or INTERSECT is used together with other operators in an expression, it is evaluated...

    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

    May 13, 2015 at 3:14 pm

    #1797697

  • RE: Running totals for previous X days

    Lynn Pettis (5/13/2015)

    May or may not answer the question. How do you want to handle the null date values? What would the results look like if you only...

    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

    May 13, 2015 at 3:08 pm

    #1797696

  • RE: Need Ammunition for Developers Doing Select *'s

    Maybe a real life scenario can help. Someone posted a problem that happens when using SELECT *.

    http://www.sqlservercentral.com/Forums/Topic1685042-392-1.aspx

    I'm sure that it's faster to code using * instead of the column names....

    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

    May 13, 2015 at 2:54 pm

    #1797690

  • RE: Running totals for previous X days

    This seems to do the trick. Please be sure to understand what it is doing and ask any questions that you have.

    Running totals became a lot easier on SQL Server...

    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

    May 13, 2015 at 2:37 pm

    #1797686

  • RE: Display all months even if values are NULL

    Oh yeah, I saw the error that came from using a table value constructor for testing purposes.

    The queries will give different results, but that's a difference on requirement understanding. I'm...

    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

    May 13, 2015 at 2:16 pm

    #1797676

  • RE: T-SQL Query Help

    tooba111 (5/13/2015)

    Luis I really apreciate your help. I am sure I am missing something. After I running Sample Query I am getting Error "Invalid Object Name dbo.Tally"

    Can You Please guide...

    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

    May 13, 2015 at 11:43 am

    #1797636

  • RE: T-SQL Query Help

    As long as this is only for reporting purposes, because as previously stated, it makes no sense to store so many repeated values.

    You just need to query your table joining...

    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

    May 13, 2015 at 11:01 am

    #1797623

  • RE: Display all months even if values are NULL

    This is very similar to what Lynn already posted, with a little improvement to make the JOIN clause SARGable. I agree that recursion is not needed, neither the UNION ALL...

    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

    May 13, 2015 at 9:25 am

    #1797589

  • RE: Issue with CASE statement

    You have a few syntax mistakes, but the logic seems correct.

    SELECT ProductSkuTypeId = pst.[ProductSkuTypeID],

    ProductSkuTypeName = pst.[Name],

    ProductTaxCodeID...

    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

    May 12, 2015 at 1:32 pm

    #1797370

Viewing 15 posts - 4,936 through 4,950 (of 8,731 total)