Forum Replies Created

Viewing 15 posts - 1,681 through 1,695 (of 2,894 total)

  • RE: paramatize case statement?

    Why not just use LEFT JOIN?

    _____________________________________________
    "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]

    April 27, 2012 at 2:37 am

    #1480238

  • RE: If proc1 calls procB, can proc1 complete without waiting for procB?

    I agree that Service Broker would allow you to call procs asynchronously from within a proc. However, personally, if I would have the same needs, I would do it from...

    _____________________________________________
    "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]

    April 26, 2012 at 9:44 am

    #1479858

  • RE: decimal to char

    google CAST or CONVERT

    _____________________________________________
    "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]

    April 26, 2012 at 8:04 am

    #1479755

  • RE: decimal to char

    use CAST or CONVERT function

    _____________________________________________
    "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]

    April 26, 2012 at 8:01 am

    #1479751

  • RE: CASE Statement problem

    SUM(CASE WHEN Status = 'RG' THEN 1 ELSE 0 END) AS CountRGStatus

    SUM(CASE WHEN Status = 'GS' THEN 1 ELSE 0 END) AS CountGSStatus

    _____________________________________________
    "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]

    April 26, 2012 at 7:57 am

    #1479740

  • RE: Can you have a non-aggregate field?

    Check it here:

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    _____________________________________________
    "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]

    April 26, 2012 at 7:37 am

    #1479713

  • RE: SQL to get all Days in the month in Group by even with Zero values

    As I don't have a crystal ball or magic mirror, I cannot see what you are doing without you posting complete query and tables DDL. It doesn't matter how good...

    _____________________________________________
    "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]

    April 26, 2012 at 7:36 am

    #1479711

  • RE: SQL to get all Days in the month in Group by even with Zero values

    kotharibij (4/26/2012)

    Thank you Eugene.

    Both my SQL and yours (very interesting SQL), gives the same result.

    Day RegTotal

    116

    4121

    532

    636

    737

    836

    933

    1046

    1145

    I thought of a calendar table but...

    _____________________________________________
    "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]

    April 26, 2012 at 6:18 am

    #1479622

  • RE: Stored procedure sorting - possible?

    Which input parameter you want to use to define the order? Which column should it apply to?

    You can do something like:

    ORDER BY (CASE WHEN SomeColumn = @HigherPriorityValue THEN 1...

    _____________________________________________
    "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]

    April 26, 2012 at 5:29 am

    #1479595

  • RE: paramatize case statement?

    Without knowing what your tables are and what your full query is, the maximum what I can come up with:

    SELECT t.ApprovalID

    ,u.UserName ...

    _____________________________________________
    "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]

    April 26, 2012 at 5:25 am

    #1479589

  • RE: Quering with "google-style" operators

    Then tell your customer he cannot have the "google-style" search as their IT prohibits it.

    _____________________________________________
    "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]

    April 26, 2012 at 5:16 am

    #1479586

  • RE: split string separated by special character .

    select replace(left(val, charindex('^',val)),'^','') as LeftPart

    ,replace(substring(val, charindex('^',val), len(val)),'^','') as RightPart

    from...

    _____________________________________________
    "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]

    April 26, 2012 at 5:00 am

    #1479577

  • RE: Quering with "google-style" operators

    ...

    Unfortunately, Full Text Search is not an option - for some weird reason, it's not allowed in our corporate servers. Neither dynamic sql.

    ...

    The closest to "google-style" search in SQL is...

    _____________________________________________
    "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]

    April 26, 2012 at 4:50 am

    #1479571

  • RE: SQL to get all Days in the month in Group by even with Zero values

    The best option is to create and use CalendarTable, but you can do it by:

    select convert(integer,DATENAME(day,m.MonthDay)) as Day, count(*) as RegTotal

    from (SELECT DATEADD(DAY,ROW_NUMBER() OVER (ORDER BY (SELECT NULL))-1,'20120401') as MonthDay

    ...

    _____________________________________________
    "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]

    April 26, 2012 at 4:02 am

    #1479546

  • RE: Replacement for Cursors

    vinu512 (4/26/2012)

    Thanks Eugene.

    As simple it may be....but that was what I was looking for. 😎

    The key in using CURSORS (or loops, which are no much difference to cursors), as 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]

    April 26, 2012 at 3:36 am

    #1479540

Viewing 15 posts - 1,681 through 1,695 (of 2,894 total)