Forum Replies Created

Viewing 15 posts - 2,041 through 2,055 (of 2,894 total)

  • RE: convert from MM/DD/YYYY to YYYYMMDD

    Jeff Moden (3/4/2012)

    BWWWAAAA_HAAAA!!!! I know this thread is old but I think it's a funny thread. Let me replay the whole thing for you...

    We have a team...

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

    March 5, 2012 at 3:14 am

    #1454701

  • RE: SELECT to transform a csv of INT into VARCHAR

    Jeff Moden (3/4/2012)

    Eugene Elutin (3/2/2012)

    It may be that I will be killed by the community for the following advice :

    Ummmm... so what's your address, Eugene? 😉

    Jeff, personally, you have no...

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

    March 5, 2012 at 3:01 am

    #1454693

  • RE: How to JOIN tables with no keys between

    Could you please post the query with LEFT JOIN you've tried and also add some test data into setup...

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

    March 2, 2012 at 10:08 am

    #1454284

  • RE: Search Issue

    ColdCoffee (3/2/2012)

    ...

    Hello Eugene, i had posted similar approach already on the same thread; i doubt if it will preform well.

    ...

    Which one? Yours or my one? Compare to what?

    My one does...

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

    March 2, 2012 at 10:04 am

    #1454281

  • RE: Exporting to Excel via stored procedure

    I think you still can do it with ##table, but you need to make everything in to your dynimc sql string:

    DECLARE @sql VARCHAR(8000)

    DECLARE @IdNbr VARCHAR(50)

    SET @IdNbr = '312012145014'

    SET @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]

    March 2, 2012 at 8:33 am

    #1454227

  • RE: Dynamic query

    SELECT r.session_id,r.command,CONVERT(NUMERIC(6,2),r.percent_complete)

    AS [Percent Complete],CONVERT(VARCHAR(20),DATEADD(ms,r.estimated_completion_time,GetDate()),20) AS [ETA Completion Time],

    CONVERT(NUMERIC(10,2),r.total_elapsed_time/1000.0/60.0) AS [Elapsed Min],

    CONVERT(NUMERIC(10,2),r.estimated_completion_time/1000.0/60.0) AS [ETA Min],

    CONVERT(NUMERIC(10,2),r.estimated_completion_time/1000.0/60.0/60.0) AS [ETA Hours],

    CONVERT(VARCHAR(1000),(SELECT SUBSTRING(text,r.statement_start_offset/2,

    CASE WHEN r.statement_end_offset = -1 THEN 1000...

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

    March 2, 2012 at 8:06 am

    #1454195

  • RE: SELECT to transform a csv of INT into VARCHAR

    Nope, you will not.

    What you need to do is to have the splitter function.

    It may be that I will be killed by the community for the following advice :hehe::

    If...

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

    March 2, 2012 at 7:46 am

    #1454179

  • RE: Exporting to Excel via stored procedure

    If you go with the route with having permanent table, don't forget to implement some sort of clearing mechanism to keep the table size under control.

    Also, as you will...

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

    March 2, 2012 at 7:11 am

    #1454150

  • RE: How to pad a string with spaces when size of data is unknown

    Looks like OP is happy with his SPACE-noodles and has lost the interest to the thread, while the busy people (us we all are) still in the process of discussion...

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

    March 2, 2012 at 7:06 am

    #1454145

  • RE: Search Issue

    ColdCoffee (3/1/2012)

    Hey R.P.R , the OP does not want the rows that have 12 values , instead the rows that contain the value 12 ; look at the expected output...

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

    March 2, 2012 at 6:57 am

    #1454138

  • RE: Query to return single result from multiple tables

    Mark-101232 (3/2/2012)

    ...

    Good catch!. If the OP had provided tables with primary keys, things would have been easier

    ...

    Could be easier, but also it may not be the case, depends on real...

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

    March 2, 2012 at 6:50 am

    #1454134

  • RE: Exporting to Excel via stored procedure

    Use permanent table instead of ##table, tag each row with UserId and, if you have any, session token.

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

    March 2, 2012 at 6:29 am

    #1454120

  • RE: SELECT to transform a csv of INT into VARCHAR

    Use string splitter function (SQL one based on Tally-table is well described in http://www.sqlservercentral.com/articles/Tally+Table/72993/ by Jefff Moden).

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

    March 2, 2012 at 6:27 am

    #1454118

  • RE: Query to return single result from multiple tables

    As everyone else I would suggest to read through forum etiquette article by Jeff Moden, link also can be found at the bottom of my signature.

    Here I try to show...

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

    March 2, 2012 at 5:17 am

    #1454102

  • RE: Cached Data Performance issues

    sotn (2/29/2012)

    ...The logicial reads are the same but the duration on one server is between 50% and 100% slower, from 9 seconds to between 13 and 17 seconds to return...

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

    March 1, 2012 at 11:12 am

    #1453794

Viewing 15 posts - 2,041 through 2,055 (of 2,894 total)