Forum Replies Created

Viewing 15 posts - 3,151 through 3,165 (of 8,731 total)

  • RE: sql and stored procedure

    I can think of 3 possible solutions. The first one is to use a table variable.

    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

    March 24, 2016 at 10:49 am

    #1867515

  • RE: Today's Random Word!

    Revenant (3/24/2016)

    Ray K (3/24/2016)

    ThomasRushton (3/24/2016)

    Ed Wagner (3/24/2016)

    ThomasRushton (3/24/2016)

    EL Jerry (3/23/2016)

    Ed Wagner (3/23/2016)

    TomThomson (3/23/2016)

    Ed Wagner (3/23/2016)

    Claymore

    Broadsword

    Katana

    Suzuki

    method

    Property

    theft

    Insurance

    Premium

    Freemium

    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

    March 24, 2016 at 8:49 am

    #1867466

  • RE: Are the posted questions getting worse?

    Sean Lange (3/24/2016)

    ChrisM@Work (3/24/2016)

    Sean Lange (3/24/2016)

    --I posted in another thread by accident a couple of days ago--

    Thank you Mr. Moden. Another interview cut short with the simple "Name one way...

    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

    March 24, 2016 at 8:47 am

    #1867465

  • RE: Are the posted questions getting worse?

    Sean Lange (3/24/2016)

    Eirikur Eiriksson (3/24/2016)

    Sean Lange (3/24/2016)

    --I posted in another thread by accident a couple of days ago--

    Thank you Mr. Moden. Another interview cut short with the simple "Name one...

    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

    March 24, 2016 at 8:05 am

    #1867432

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/24/2016)

    I need some SSIS script task help (2008 / 2012) over on this thread here. All assistance would be appreciated.

    Google doesn't seem to recognize the first error at...

    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

    March 24, 2016 at 8:04 am

    #1867431

  • RE: Dynamic Lag Function

    I'm not sure that LAG function would work here.

    I have 2 options that work for this example, but you might have to do further testing.

    SELECT at.ID,

    at.Score,

    ...

    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

    March 24, 2016 at 7:59 am

    #1867427

  • RE: sp_whoIsActive 101 help...

    Have you read this? Including the links https://www.brentozar.com/archive/2010/09/sql-server-dba-scripts-how-to-find-slow-sql-server-queries/

    Also, the procedure is heavily commented to document functionalities, or you could use the help parameter.

    EXEC dbo.sp_WhoIsActive @help =1;

    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

    March 23, 2016 at 2:29 pm

    #1867243

  • RE: Today's Random Word!

    Grumpy DBA (3/23/2016)

    DonlSimpson (3/23/2016)

    Ed Wagner (3/23/2016)

    djj (3/23/2016)

    Ed Wagner (3/23/2016)

    Grumpy DBA (3/23/2016)

    Ed Wagner (3/22/2016)

    Altruism

    Unselfish

    Humble

    Pie

    Apple

    IIe

    6502

    2319

    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

    March 23, 2016 at 11:44 am

    #1867184

  • RE: how to export and import table single table in databe

    radireddy18 (3/23/2016)

    what if the table is in GB size?

    You'll have to wait for a while. 😀

    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

    March 23, 2016 at 8:24 am

    #1867101

  • RE: SQL convert

    So much trouble adding and removing quotes to a smallint column. Why?

    You could add the zeros before converting the value to string.

    SELECT field10,

    field5,

    ...

    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

    March 23, 2016 at 7:59 am

    #1867084

  • RE: Insert records count reach limit

    Charmer (3/23/2016)

    Hi Luis,

    I am not sure but I think they are going to refer these tables in a ssrs report. I heard that they are using share point and report...

    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

    March 23, 2016 at 7:15 am

    #1867070

  • RE: Using the STUFF command??

    Read the following article: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

    It explains what each part does. Be sure to understand how it works and ask any questions you might have. You could also read BOL to...

    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

    March 22, 2016 at 10:59 am

    #1866872

  • RE: conditionally count method

    This might help. If you want your results to be grouped, you don't use the OVER clause, you need to use GROUP BY.

    SELECT 'NW' AS Region,'chocolate Swirl' As Flavor, 1...

    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

    March 22, 2016 at 10:53 am

    #1866869

  • RE: Insert records count reach limit

    Charmer (3/22/2016)

    Hi Friends,

    I have a scenario that I have records incoming from a table and have to insert into another table. Incoming count is usually in millions. I have been...

    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

    March 22, 2016 at 9:48 am

    #1866845

  • RE: Trying to count distinct warehouses per order and get the total

    Alan.B (3/21/2016)

    You can't do what Luis suggested because you can't COUNT(DISTINCT) with an OVER clause.

    You're right, I didn't test it.

    An alternative could be something like this:

    WITH CTE AS(

    ...

    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

    March 21, 2016 at 2:53 pm

    #1866620

Viewing 15 posts - 3,151 through 3,165 (of 8,731 total)