Forum Replies Created

Viewing 15 posts - 2,296 through 2,310 (of 8,731 total)

  • RE: Rounding in tsql

    ntreelevel (8/16/2016)

    Hi all, Thank you for the answers but I figured out that using a case statements for custom rounding is the best way and it worked out

    Do you mean...

    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

    August 16, 2016 at 6:50 am

    #1895623

  • RE: Today's Random Word!

    whereisSQL? (8/15/2016)

    Revenant (8/15/2016)

    Ray K (8/15/2016)

    Ed Wagner (8/15/2016)

    djj (8/15/2016)

    Grumpy DBA (8/15/2016)

    djj (8/15/2016)

    Ed Wagner (8/15/2016)

    Sweet

    Treat

    Trick

    Joke

    Puzzle

    Jigsaw

    Tools

    Power

    Unlimited

    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

    August 15, 2016 at 11:58 am

    #1895497

  • RE: how to check duplicated records (combitation of 3 fields)

    That seems correct. Have you tried 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

    August 15, 2016 at 11:57 am

    #1895496

  • RE: Apply Pivot in SQL Server

    Just a small changes based on preferences. I prefer to make the FROM clause as simple as possible, that's why I use CTEs instead of derived tables (same thing different...

    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

    August 15, 2016 at 11:32 am

    #1895493

  • RE: Low Cardinality estimate in Hash match operator

    Are you sure that you're querying the tables correctly?

    You don't have alias for your tables and that might be causing to use the incorrect columns on what should be 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

    August 15, 2016 at 9:25 am

    #1895472

  • RE: How to query a crosstab

    You forgot the commas and to put brackets around your column names.

    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

    August 15, 2016 at 7:07 am

    #1895440

  • RE: How to change Column with row in SQL

    You can use a method called cross tabs (or the pivot operator) which is explained in here:

    http://www.sqlservercentral.com/articles/T-SQL/63681/

    Here's an example based on your greatly posted sample data.

    SELECT ComputerID,

    ...

    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

    August 15, 2016 at 6:58 am

    #1895431

  • RE: create single quotes around @variable

    Just because this thread was revived after 9 years, I'd like to make a few suggestions.

    Use parametrized dynamic sql and always define precision and scale for your types. In 2000,...

    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

    August 15, 2016 at 6:54 am

    #1895427

  • RE: Today's Random Word!

    whereisSQL? (8/12/2016)

    Ray K (8/12/2016)

    Ed Wagner (8/12/2016)

    Kaye Cahs (8/12/2016)

    Ed Wagner (8/12/2016)

    djj (8/12/2016)

    Finalist

    Win

    Doze

    Coffee

    Caffeine

    Stimulant

    Sugar

    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

    August 12, 2016 at 12:52 pm

    #1895282

  • RE: need to copy a 600 gig table

    Snargables (8/12/2016)

    I didn’t mean not log at all. I just don’t want it to use one continuous transaction to load 2.5 billion records. SSIS is doing it in batches freeing...

    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

    August 12, 2016 at 12:11 pm

    #1895278

  • RE: Are the posted questions getting worse?

    ChrisM@Work (8/12/2016)

    Steve Jones - SSC Editor (8/11/2016)

    ...

    Part of the process noted that we have a few "how to post code, how to ask a question, how to format code" articles....

    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

    August 12, 2016 at 9:26 am

    #1895239

  • RE: need to copy a 600 gig table

    Jeff Moden (8/11/2016)

    Luis Cazares (8/11/2016)

    Everything that changes data in a database writes to trans log.

    You might have some options to copy the table, but answer Eirikur's questions so we can...

    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

    August 12, 2016 at 7:12 am

    #1895209

  • RE: Negative duration

    What happens if you don't convert to time? Maybe you have some very long running process or transactions that were left open.

    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

    August 12, 2016 at 6:55 am

    #1895206

  • RE: I Need to Keep a Running Total From Two Columns

    Check the following article for the best options on doing this in 2008 and previous versions.

    http://www.sqlservercentral.com/articles/T-SQL/68467/

    If by any chance you're on 2012 or a more recent version, a simpler option...

    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

    August 11, 2016 at 1:47 pm

    #1895101

  • RE: Calculating time between two times five an arithmetic overflow

    SQLTestUser (8/11/2016)

    Result For Hour

    XXX38532962 which makes no sense as i just want to figure out how much time they spent, i.e. total time on the system in a way that...

    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

    August 11, 2016 at 12:37 pm

    #1895087

Viewing 15 posts - 2,296 through 2,310 (of 8,731 total)