Forum Replies Created

Viewing 15 posts - 331 through 345 (of 2,894 total)

  • RE: ORDER BY when inserting into table variable

    Luis Cazares (6/28/2013)

    Eugene Elutin (6/28/2013)

    We don't order INSERTS, we order SELECTS.

    Until we have identity and we want to populate it in a specific order...

    Or want to do a clustered insert...

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

    June 28, 2013 at 10:23 am

    #1628350

  • RE: How to replace a value in Bracket with negative value in ssis

    SQL_Learning (6/28/2013)

    Hi,

    I have imported data into a database from an excel file and some of the columns contain values are like (392.03), (2.25),...

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

    June 28, 2013 at 10:10 am

    #1628346

  • RE: ORDER BY when inserting into table variable

    We don't order INSERTS, we order SELECTS.

    Until we have identity and we want to populate it in a specific order...

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

    June 28, 2013 at 9:53 am

    #1628341

  • RE: Full Text Search Index Problem

    suresh0534 (6/25/2013)

    Select * from candidates WHERE contains(c_resume_text,'"c++" or "houston" or "New York" or "Amsterdam"')

    I have passed nearly 550 cities to search condition.

    when i passed the 550 cities and run the...

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

    June 28, 2013 at 9:39 am

    #1628331

  • RE: how to write query to show in desired table fomat

    you need to use FULL OUTER JOIN

    SELECT ISNULL(t1.name, t2.name) AS name

    ,t1.JANclient

    ,t2.FRBClient

    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]

    June 28, 2013 at 9:25 am

    #1628328

  • RE: How to convert binary file to text file in ssis or in SQL server.

    You cannot convert "any kind" of binary file into text file.

    Binary file may contain any type of data in any format.

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

    June 21, 2013 at 8:58 am

    #1626360

  • RE: How to convert binary file to text file in ssis or in SQL server.

    What binary file?

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

    June 21, 2013 at 8:14 am

    #1626334

  • RE: Generate a table with all possibilities.

    The best way to present such question would be with bigger example of required output.

    If I understood you correctly your final table should have 6 columns...

    So, may be that:

    ;WITH vals

    AS

    (

    SELECT...

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

    June 21, 2013 at 8:04 am

    #1626331

  • RE: qry options

    Tara-1044200 (6/11/2013)

    I want to do this.

    select count(*) from

    (

    select col1,col2,......col18 from REVemployee.tbemp

    group by col1,col2,......col18 HAVING COUNT(*)>1

    )a

    is there a better way of doing the same for better proformance?

    Looks fine to...

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

    June 12, 2013 at 3:00 am

    #1623245

  • RE: Rollback statement in T-SQL

    GilaMonster (6/11/2013)

    Eugene Elutin (6/11/2013)

    I will be very brave to disagree with Gail on this one. But...

    There are such thing as a "nested transaction" in MS SQL Server.

    There are 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]

    June 12, 2013 at 2:52 am

    #1623242

  • RE: Rollback statement in T-SQL

    I will be very brave to disagree with Gail on this one. But...

    There are such thing as a "nested transaction" in MS SQL Server. They just are not what...

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

    June 11, 2013 at 7:43 am

    #1622932

  • RE: Data Cube / SQL Server 2012 / BI

    Do not need in dopuble posting!

    Your starting point might be here:

    http://msdn.microsoft.com/en-US/library/ms170208(v=sql.110).aspx

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

    June 11, 2013 at 6:09 am

    #1622840

  • RE: Benefits in using a unique login for each user.

    Zeev Kazhdan (6/11/2013)

    Thanks for the ideas!

    In terms of auditing we thought as well that SQL is better, but the customer insists they do better auditing within their 4G application.

    Thanks...

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

    June 11, 2013 at 3:49 am

    #1622792

  • RE: Case statement with subquery

    tshad (6/7/2013)

    I have a CASE statement with a subquery that works most of the time but if the subquery comes back with zero rows, I get a null and 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]

    June 11, 2013 at 3:12 am

    #1622769

  • RE: not able to understand that store procedure running recursively or not

    DataAroma (6/11/2013)

    create procedure testRecur()

    BEGIN

    if

    call testRecur();

    end if;

    select...

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

    June 11, 2013 at 3:08 am

    #1622768

Viewing 15 posts - 331 through 345 (of 2,894 total)