Forum Replies Created

Viewing 15 posts - 2,521 through 2,535 (of 2,894 total)

  • RE: Returning data from Multiple tables.

    John Peter Fernandes (7/18/2010)

    ...

    Please advise. If this is possible or not.

    ...

    It is possible.

    For more details please follow the advice from the link in my signature.

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

    July 19, 2010 at 6:29 am

    #1194852

  • RE: Improve query performance with comma separated result of each member.

    Paul, yep, I was not exectly correct in my post, I should just say that it is impossible to create indices explicitly on table variable after its declaration, only implicitly...

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

    July 19, 2010 at 5:47 am

    #1194840

  • RE: Improve query performance with comma separated result of each member.

    Sagar Sawant (7/19/2010)

    Hi,

    Thanks for reply but some problems are

    #2: Indexed temp table allocating resources in temp db as compared to table variable.

    ...

    Who told you that? Is it your guess?

    Why you...

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

    July 19, 2010 at 4:13 am

    #1194787

  • RE: Between Statment only for current day

    jon pill (7/16/2010)

    1.

    ...

    I run this code from SQL server, New > query, I can run once only, if Drop Table is inserted I can run many times

    ...

    2.

    ...

    Else I am opening...

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

    July 16, 2010 at 6:28 am

    #1194043

  • RE: CTE - Avoiding the cursor

    Brandie Tarvin (7/16/2010)

    ...

    But I have tested your solution both using a normal update and using a Tally Table. In both methods, it still repeats numbers. So, I'm back where I...

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

    July 16, 2010 at 6:19 am

    #1194034

  • RE: Doing Column Updation while using SQL BulkCopy

    You need to read about using IDENTITY column in SQLServer...

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

    July 16, 2010 at 5:45 am

    #1194014

  • RE: Between Statment only for current day

    jon pill (7/15/2010)

    SQL messaging

    Without drop table I can only run once

    Jon, it is something wrong in a way you executing it.

    It looks like you have connection open between execution. 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]

    July 16, 2010 at 5:06 am

    #1193995

  • RE: Between Statment only for current day

    jon pill (7/15/2010)

    Really sorry about this,

    But I can only run the query once

    Msg 2714, Level 16, State 6, Line 1

    There is already an object named '#TodayRecords' in the database.

    I...

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

    July 15, 2010 at 9:06 am

    #1193563

  • RE: Query - Start Date, End Date count for each year

    bteraberry (7/14/2010)

    The problem I have with the case statements is that they're a bit ugly to work with (especially when you get more and more) and they're not dynamic

    ...

    1. We...

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

    July 14, 2010 at 12:06 pm

    #1193033

  • RE: query help

    bteraberry (7/14/2010)

    No left join is needed for this so I wouldn't use one either.

    ...

    One thing is when LEFT JOIN is not needed. Not trusting to LEFT JOIN (due to political...

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

    July 14, 2010 at 11:43 am

    #1193008

  • RE: Between Statment only for current day

    SELECT upvolume,downvolume,TotalTrades

    INTO #TodayRecords

    FROM DBVaskVbid WITH (NOLOCK) -- are you fully awre of what this hint does?

    WHERE BarStamp >= '7/14/2010'

    -- do you have huge vlume of records per...

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

    July 14, 2010 at 10:34 am

    #1192972

  • RE: Query - Start Date, End Date count for each year

    You are welcome!

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

    July 14, 2010 at 10:24 am

    #1192962

  • RE: Help with using mulitple replace in a function

    rdouglas66 (7/14/2010)

    Have you tried doing comparisons using the SOUNDEX function?

    I have tried, have you? I don't think it will help much in what the OP trying to do...

    Soundex is just...

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

    July 14, 2010 at 10:23 am

    #1192960

  • RE: Between Statment only for current day

    Chris Morris-439714 (7/14/2010)

    jon pill (7/14/2010)

    I have data that I want to find the Min and Max off, for 2 fields

    Upvolume and DownVolume

    Every day the Totaltrades field starts at zero and...

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

    July 14, 2010 at 10:05 am

    #1192948

  • RE: Query - Start Date, End Date count for each year

    try:

    SELECT

    SUM(CASE WHEN 2006 BETWEEN YEAR(STRTDATE) AND YEAR(ENDDATE) THEN 1 ELSE 0 END) AS Y2006,

    SUM(CASE WHEN 2007 BETWEEN YEAR(STRTDATE) AND YEAR(ENDDATE) THEN 1 ELSE 0 END) AS Y2007,

    SUM(CASE WHEN 2008...

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

    July 14, 2010 at 9:58 am

    #1192938

Viewing 15 posts - 2,521 through 2,535 (of 2,894 total)