Forum Replies Created

Viewing 15 posts - 5,881 through 5,895 (of 8,731 total)

  • RE: Using COALESCE and also trying to multiply and divide

    Someone call the normalization police, we have an offender in here.

    That Rents table is not normalized. What will happen when there's more concepts needed? Will you just add columns? What...

    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

    September 3, 2014 at 1:47 pm

    #1742992

  • RE: Problem when pass parameters on Query

    Hi Luis,

    First of all, I'm sorry for the comments made that didn't help you on your task.

    Second, you shouldn't keep something that is fast enough right now. You should...

    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

    September 3, 2014 at 1:32 pm

    #1742984

  • RE: Simple looping problem

    ROW_NUMBER won't work on SQL Server 2000.

    You could use a running total solution and the fastest is the quirky update. You can find different type of solutions in the following...

    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

    September 3, 2014 at 11:42 am

    #1742945

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (9/3/2014)

    Koen Verbeeck (9/3/2014)

    TomThomson (9/3/2014)

    Luis Cazares (9/3/2014)

    xsevensinzx (9/3/2014)

    Koen Verbeeck (9/3/2014)

    xsevensinzx (9/3/2014)

    I keep coming to this thread just to read all your fueled responses. It's baiting me to post 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

    September 3, 2014 at 11:27 am

    #1742939

  • RE: Rounding with a Decimal

    Oh my, so much work when ROUND function has a truncation option.

    DECLARE @MyPay decimal(12,9);

    SET @MyPay = 258.235543210;

    SELECT ROUND(@MyPay,2,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

    September 3, 2014 at 11:23 am

    #1742935

  • RE: Are the posted questions getting worse?

    xsevensinzx (9/3/2014)

    Koen Verbeeck (9/3/2014)

    xsevensinzx (9/3/2014)

    I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the...

    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

    September 3, 2014 at 8:41 am

    #1742838

  • RE: How bad this in terms of performance; udf in WHERE

    HowardW (9/3/2014)

    Grant Fritchey (9/3/2014)

    Pretty much that whole WHERE clause is an issue. Functions on columns or functions to determine values within a WHERE clause, JOIN criteria or a HAVING clause...

    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

    September 3, 2014 at 8:17 am

    #1742814

  • RE: Are the posted questions getting worse?

    TomThomson (9/2/2014)

    Sean Lange (9/2/2014)

    Lynn Pettis (9/2/2014)

    AARRRGGGGGGG!!!!!!!!!!! Someone fire the man. He has no business in this business.

    In my experience nearly 95% of the people in this business...

    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

    September 2, 2014 at 6:11 pm

    #1742651

  • RE: How do I write this code?

    Lynn's code is explained in here:

    http://www.sqlservercentral.com/articles/comma+separated+list/71700/

    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

    September 2, 2014 at 1:38 pm

    #1742577

  • RE: Understanding Joins !!!

    Alan.B (9/2/2014)

    In this query this is what happens:

    1. A is joined to B to create AB.

    2. AB is joined to C to create ABC

    Let's say you had 5...

    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

    September 2, 2014 at 1:13 pm

    #1742564

  • RE: Function to Convert Current Date to SQL Sever Date format.

    David Burrows (9/2/2014)

    I do not oracle

    You're lucky 😀

    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

    September 2, 2014 at 8:46 am

    #1742469

  • RE: Understanding Joins !!!

    JackTimber (9/1/2014)

    Hi all expert,

    I am having some problem understanding joins (Specially left,right and outer apply)when it comes to more then 3 tables.

    Like how are the result set formed , which...

    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

    September 2, 2014 at 8:43 am

    #1742468

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (9/1/2014)

    Lynn Pettis (8/22/2014)

    And Mr. Celko is back with his baseball bat. :Whistling:

    In more than one thread. :Whistling:

    Now he has put the bat aside and instead taken up the...

    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

    September 1, 2014 at 5:12 pm

    #1742270

  • RE: Problem when pass parameters on Query

    CELKO (9/1/2014)

    there's no 1NF violation since each value of the column is a scalar value.

    NO! The column itself has to be scalar, not each value in a list, not...

    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

    September 1, 2014 at 4:54 pm

    #1742269

  • RE: Problem when pass parameters on Query

    CELKO (9/1/2014)

    I have the following code and I want to pass more than one value:

    DECLARE @myvendedor VARCHAR (255);

    SET @my_vendor = '87,30';

    Please read any book on RDBMS. In...

    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

    September 1, 2014 at 4:06 pm

    #1742266

Viewing 15 posts - 5,881 through 5,895 (of 8,731 total)