Forum Replies Created

Viewing 15 posts - 5,506 through 5,520 (of 8,731 total)

  • RE: Problem using bcp

    It seems that you have some things that don't belong there.

    bcp Weather.dbo.TestTable in C:\wdisplay\webfiles\customtextout7.txt -c -S localhost\PSIMONDS\SQLEXPRESS -T

    Read more about bcp in here:

    http://msdn.microsoft.com/en-us/library/ms162802.aspx

    http://www.sqlservercentral.com/articles/BCP+(Bulk+Copy+Program)/105867/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 21, 2014 at 9:13 am

    #1760200

  • RE: tsql with out using cursors

    I think that you missed my point. A cursor IS a while loop (well, not exactly but it needs it to be useful).

    There's a different way to do that, but...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 21, 2014 at 8:54 am

    #1760192

  • RE: tsql with out using cursors

    Damian-167372 (11/21/2014)

    is there a way we can do this in WHILE Loop?

    What do you think this is? A pizza?

    WHILE @@FETCH_STATUS = 0

    begin

    -- my query

    FETCH cr into @dbname

    end...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 21, 2014 at 8:06 am

    #1760158

  • RE: SQL Job to run .vsb

    I was on my mobile, but now that I'm back on the desktop, I can elaborate a little more.

    SQL Server is identifying master as a linked server instead of a...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 20, 2014 at 2:41 pm

    #1759974

  • RE: SQL Job to run .vsb

    You have 3 dots instead of 2.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 20, 2014 at 1:32 pm

    #1759962

  • RE: SQL Job to run .vsb

    Have you noticed the vsb instead of vbs?

    Does the account used by xp_cmdshell has permissions to execute the scripts?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 20, 2014 at 12:14 pm

    #1759942

  • RE: SQl if statement in where clause

    Here you go:

    A solution

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 20, 2014 at 12:02 pm

    #1759939

  • RE: SQL Job to run .vsb

    Don't you hate those vendors? 😀

    Have you tried changing the type of the step to an ActiveX Script or Operating System?

    What is the problem that you have?

    I suppose you're using...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 20, 2014 at 10:32 am

    #1759911

  • RE: SQL Job to run .vsb

    Simple question.

    Why do you want to stop app services to backup the DB? Backups can be done online.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 20, 2014 at 10:13 am

    #1759903

  • RE: Replace(UPPERCASE GO ONLY)

    You can try a case sensitive collation.

    SET @SQL = 'EXEC (''' + REPLACE(REPLACE(@SQL COLLATE Latin1_General_BIN, '''', ''''''), 'GO', ''');' + + CHAR(13) + ' EXEC(''') + ''');'

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 20, 2014 at 9:49 am

    #1759889

  • RE: Query if extract failed and/or succeed the same day

    For datetime columns, you should use a range to prevent the use of functions in your column. You might also want to have a computed column either for duration or...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 20, 2014 at 8:22 am

    #1759862

  • RE: How to import json from http request into SQL table by using SSIS 2008

    Does this help?

    Consuming JSON Strings in SQL Server by Phil Factor[/url]

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 19, 2014 at 7:01 pm

    #1759703

  • RE: Best Practices

    ramana3327 (11/19/2014)

    That is not related to parameter sniffing.

    Why because we are passing 3 input parameters. Those are default parameters. We are not changing either in SP or Report also.

    Just tested...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 19, 2014 at 3:50 pm

    #1759678

  • RE: add string WHERE filter that will match everything

    Even that option could filter something.

    DECLARE @test-2 TABLE(

    string varchar(30)

    )

    INSERT @test-2 VALUES ('dasfsa'),('%!·$%/'), (''), (NULL)

    SELECT *

    FROM @test-2

    WHERE string LIKE '%'

    SELECT *

    FROM @test-2

    --What about this?

    SELECT *

    FROM @test-2

    WHERE...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 19, 2014 at 3:49 pm

    #1759677

  • RE: need table returning function with input table name as parameter

    It's not that we don't want to share information because we're jealous. If that were the case, we wouldn't be helping on the forums. The idea of not posting it...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 19, 2014 at 3:46 pm

    #1759676

Viewing 15 posts - 5,506 through 5,520 (of 8,731 total)