Forum Replies Created

Viewing 15 posts - 1,456 through 1,470 (of 2,894 total)

  • RE: Extract Data from SQL table ( single record ) to text file - ( multiple lines )

    You can use SSIS, or write custom query and export to file using BCP.

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

    May 31, 2012 at 6:07 am

    #1495151

  • RE: User permissions required for executing ad hoc OPENROWSET() query?

    Looks like problem with connection string, try:

    SELECT *

    FROM OPENROWSET('SQLNCLI', 'Server=myserver;Database=DBA;UserId=ImaUser;Password=TopSecretPass',

    'SELECT * FROM DBA.dbo.LDAP') as a

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

    May 30, 2012 at 12:00 am

    #1494456

  • RE: A Little String Separation

    All done by J. Moden:

    http://www.sqlservercentral.com/articles/Tally+Table/72993/

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

    May 29, 2012 at 8:42 am

    #1494212

  • RE: Improving Delete Query

    Is it one-off data-fix task? If you have no triggers on the table which you need to execute on delete, if it's not referenced by FK relationships and you need...

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

    May 29, 2012 at 8:39 am

    #1494210

  • RE: Select specified records from a full outer join given from and end dates

    KS-321165 (5/29/2012)

    Hi,

    I have two tables A and B which are joined by the EmployeeBadgeID. I have to capture all the records that have changed in both the tables...

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

    May 29, 2012 at 7:18 am

    #1494152

  • RE: error

    ramyours2003 (5/29/2012)

    i got error "PK_ violation" while exporting data from sql 2008 r2 to sql 2008 , how to solve this ?

    Sort out records with duplicate PK, or, 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]

    May 29, 2012 at 7:16 am

    #1494151

  • RE: Help with Query(Matrix Format)

    Just to Note: not everyone will have ability (or wish) to download attached files from i-net, especially at their work places...

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

    May 29, 2012 at 7:12 am

    #1494148

  • RE: Rename badly named index

    can you post the exact line of SQL you run to create your index?

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

    May 29, 2012 at 7:10 am

    #1494147

  • RE: rowid in SQL server?

    you will need to use some unique key, try using primary keys in:

    row_number() OVER (ORDER BY [YourPKColumnOrColumns])

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

    May 29, 2012 at 7:08 am

    #1494145

  • RE: Issue with SQL server using very inefficient query plan

    Have you considered using Full-Text?

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

    May 29, 2012 at 5:22 am

    #1494101

  • RE: Join Issue

    or a bit smaller:

    ;with allrules

    as

    (

    select s.id, min (d.id) mdid

    from dbo.Test_Join_Source2 s

    join dbo.Test_Join_Destination2 d

    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]

    May 29, 2012 at 5:06 am

    #1494098

  • RE: Join Issue

    It is done in SETS, using correlated sub-query.

    There is another way:

    ;with allrules

    as

    (

    select s.id, s.name1,s.name2,d.[DESC]

    ,d.id did

    ...

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

    May 29, 2012 at 5:03 am

    #1494097

  • RE: Join Issue

    Pravasis (5/29/2012)

    Eugene Elutin (5/29/2012)

    and what is the priority of your rules? which record from destination table you want to select first?

    the one with minimum id where any of the names...

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

    May 29, 2012 at 4:22 am

    #1494077

  • RE: Trigger behaves differently when invoked from an Access form

    I'm not going to fix the whole your trigger, but the following should give the idea of how it should be done.

    The existing part for updating Planning_Applications :

    DECLARE @AgentValue nvarchar(50)

    set...

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

    May 29, 2012 at 4:02 am

    #1494065

  • RE: Join Issue

    and what is the priority of your rules? which record from destination table you want to select first?

    the one with minimum id where any of the names match or 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]

    May 29, 2012 at 3:31 am

    #1494048

Viewing 15 posts - 1,456 through 1,470 (of 2,894 total)