Forum Replies Created

Viewing 15 posts - 736 through 750 (of 2,894 total)

  • RE: Calculate date using dateadd and datepart type held in data

    Then use CASE WHEN:

    ...

    WHERE CASE WHEN DateTimeInterval = 'mm'

    ...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 25, 2013 at 8:08 am

    #1581060

  • RE: Calculate date using dateadd and datepart type held in data

    Dynamic sql.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 25, 2013 at 5:47 am

    #1580976

  • RE: Joins

    Minnu (1/25/2013)

    Hi Team,

    Please suggest the best join to get the records(avioiding duplicates)

    am having 20 joins.

    if particular record is not there in that table, then it should not join that table,...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 25, 2013 at 3:51 am

    #1580919

  • RE: Table with month and year not sorted

    leesider (1/24/2013)

    Actually it's OK. The records go into the table in the proper order so when I do a simple select without an "order by" clause, they come back in...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 24, 2013 at 3:53 pm

    #1580746

  • RE: pass through query from access to sql-how can I select all records witha date greater than a fixed date

    I have tried the following without success

    WHERE orderdate >= '31/10/2010'

    Any error returned?

    Anyway, whenever you are using date strings, make sure they are in non-locale dependent format. Best is ISO:...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 24, 2013 at 9:56 am

    #1580620

  • RE: Table with month and year not sorted

    Whenever you want to see records in tables selected in the specific order, you should apply ORDER BY.

    Actually, you cannot enforce the order of how data is stored physically on...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 24, 2013 at 9:49 am

    #1580614

  • RE: Joins

    you need to learn how to use OUTER JOIN's (LEFT or RIGHT)

    SELECT t1.col1, t2.col2

    FROM table1 AS t1

    LEFT JOIN table2 AS t2

    ON...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    January 24, 2013 at 8:00 am

    #1580556

  • RE: ORDER BY Should be same as my input in IN()

    And OP only wanted to sort his SELECT...

    😉

    But on this forum we do love to go dip! :hehe:

    Merry Christmas to everyone 😀

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 22, 2012 at 5:36 am

    #1571131

  • RE: joins

    kapil_kk (12/22/2012)

    But all the columns on which you are suggesting to creating indexes, all are PK in their respective tables and as per my concern when we creating a PK...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 22, 2012 at 5:31 am

    #1571129

  • RE: SET QUOTED_IDENTIFIER ON

    Phil Parkin (12/21/2012)

    Eugene Elutin (12/21/2012)

    Phil Parkin (12/21/2012)

    ...

    And as to common practice - not in my experience. I guess it depends on whatever standards are in place where you are working.

    In...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 11:19 am

    #1571018

  • RE: SET QUOTED_IDENTIFIER ON

    Phil Parkin (12/21/2012)

    ...

    And as to common practice - not in my experience. I guess it depends on whatever standards are in place where you are working.

    In SSMS Object Explorer, go...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 8:29 am

    #1570942

  • RE: Unwanted parameter truncation

    If your values potentially may contain separator characters then you have two choices:

    use more complex multi-character separator, for example ~^~. (very often used practice eg. for BCP) or...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 8:24 am

    #1570940

  • RE: joins

    I think it will.

    Why you don't have any WHERE condition? Do you really intent to bring all fact records?

    You outer join to your dimensions on their legacy keys. So...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 8:16 am

    #1570937

  • RE: Configuring Line Graphs in SSRS for color blind?

    You can do it in SSRS.

    Create a chart and select your series. Right-click series and select Series Properties.

    Select Border. You can use function for setting different line styles.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 8:06 am

    #1570929

  • RE: SET QUOTED_IDENTIFIER ON

    Abu Dina (12/21/2012)

    Then that's normal application behaviour I'm afraid.

    If you want SQL Server to retain your comments within the stored procedure then you need to include the comments within...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    December 21, 2012 at 7:53 am

    #1570920

Viewing 15 posts - 736 through 750 (of 2,894 total)