Forum Replies Created

Viewing 15 posts - 5,986 through 6,000 (of 8,731 total)

  • RE: Help SQL question (Calculation)

    I could help you get the desired result in SQL Server, however, that might not work for you. You could try on a forum based on MariaDB which is 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

    August 15, 2014 at 2:40 pm

    #1738546

  • RE: SQL DBA high ended question (5+ years’ experience)

    Jeff Moden (8/15/2014)

    Brandie Tarvin (8/15/2014)

    GilaMonster (8/11/2014)

    paul.knibbs (8/11/2014)

    Jeff Moden (8/9/2014)

    With the understanding you have of that counting problem and the additional understanding that I don't ask "trick" questions or questions based...

    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, 2014 at 1:44 pm

    #1738535

  • RE: Help SQL question (Calculation)

    You seem to be working on something different to SQL Server. I had to translate the code to test the code.

    Let's review the rules.

    For each win, the team gets 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

    August 15, 2014 at 1:10 pm

    #1738518

  • RE: can sql server add columns dynamically

    With SELECT...INTO... you can create a table with the needed columns. However, what would you do next with that data? I assume that you'll insert base columns onto a table....

    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, 2014 at 11:23 am

    #1738478

  • RE: store procedue issue

    And John missed the part where OH_Message doesn't expects parameters and you're sending parameters. You're not using @Stud_id which is the base of your cursor and you have a begin...

    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, 2014 at 10:12 am

    #1738454

  • RE: How do I get part of URL?

    You know how this works.

    Please post DDL and sample data.

    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, 2014 at 10:00 am

    #1738442

  • RE: Is this the right forum for newbie sql server q's???

    Have you gone to the start page on win8 and then start writing "SQL Server" or "Management Studio"? That way Windows will look for you.

    You need to have at least...

    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 14, 2014 at 12:31 pm

    #1738182

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/14/2014)

    Evil Kraig F (8/14/2014)

    djj (8/14/2014)

    ChrisM@Work (8/14/2014)

    remember '76/'77

    Wish I could remember what last year was like, I remember some nice days for '77 as I have a picture...

    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 14, 2014 at 12:10 pm

    #1738168

  • RE: Copying from SQLSMS grid, pasting in Excel, the word "NULL" is pasted!

    Sean Lange (8/13/2014)

    eval_stuff (8/13/2014)

    Returning the four characters "NULL" is NOT the same as returning something that indicates that the content is NULL or that there is nothing to return. 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 13, 2014 at 2:28 pm

    #1737822

  • RE: Is this the right forum for newbie sql server q's???

    As I suspected, you had downloaded just the database engine. That's why you need the separate download.

    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 13, 2014 at 1:33 pm

    #1737802

  • RE: creating a SQL View with calculations

    tnthunder (8/13/2014)

    Luis Cazares (8/13/2014)

    You need to remove brvPRInsJob.InsCode from your GROUP BY clause.

    if you are talking about Group by in crystal reports, I have not used brvPRInsJob.InsCode it to Group...

    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 13, 2014 at 1:27 pm

    #1737798

  • RE: Is this the right forum for newbie sql server q's???

    Can you post the name of your original download?

    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 13, 2014 at 12:23 pm

    #1737763

  • RE: creating a SQL View with calculations

    You need to remove brvPRInsJob.InsCode from your GROUP BY 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

    August 13, 2014 at 12:00 pm

    #1737745

  • RE: Is this the right forum for newbie sql server q's???

    You might have only installed the database engine. You needed to install SQL Server Express with tools (or with advanced services). You could donwnload and install Management Studio from here:...

    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 13, 2014 at 11:42 am

    #1737738

  • RE: SQL Query question

    Just note that you have assigned_to column on both joins.

    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 13, 2014 at 11:22 am

    #1737723

Viewing 15 posts - 5,986 through 6,000 (of 8,731 total)