Forum Replies Created

Viewing 15 posts - 1,426 through 1,440 (of 8,731 total)

  • RE: Normalise not normalised data

    ip13791113 - Friday, March 31, 2017 7:59 AM

    Hi all,

    is there any trick 22 to select from this table
    Testcase Table
    Test_ID   ReqID
    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 31, 2017 at 8:12 am

    #1935986

  • RE: sql query

    hlsc1983 - Thursday, March 30, 2017 1:46 PM

    thanks. got it!!
    is my table design alright?

    Hard to say. As you might have noticed, designing...

    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 30, 2017 at 2:00 pm

    #1935839

  • RE: sql query

    hlsc1983 - Thursday, March 30, 2017 1:35 PM

    Home .But i am not getting the desired values. These are the values in 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

    March 30, 2017 at 1:43 pm

    #1935835

  • RE: sql query

    hlsc1983 - Thursday, March 30, 2017 1:12 PM

    select Students.student_rollno, marks, Subjects.subject_name ,Gradetype.Grade_id
    from Students_Subjects_junction
    join Subjects on Students_Subjects_junction.subject_id =...

    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 30, 2017 at 1:18 pm

    #1935830

  • RE: sql query

    hlsc1983 - Thursday, March 30, 2017 12:31 PM

    From the tables given below i need to know the values of  'ThPr_name'  from TheoryPractical...

    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 30, 2017 at 12:46 pm

    #1935821

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Wednesday, March 29, 2017 8:26 AM

    Thom A - Wednesday, March 29, 2017 8:12 AM

    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 29, 2017 at 8:59 am

    #1935514

  • RE: missing concatenated star

    I'm glad that you were able to solve your problem.

    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 28, 2017 at 11:31 am

    #1935336

  • RE: Deny execute of native functions

    alexeliasrp - Tuesday, March 28, 2017 8:27 AM

    Thanks for the answer!
    I did a script to exemplify what I need to prevent 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

    March 28, 2017 at 9:24 am

    #1935297

  • RE: missing concatenated star

    rot-717018 - Tuesday, March 28, 2017 7:32 AM

    Hi all,
    I have got something weird, I've never seen before.

    Running the query ...

    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 28, 2017 at 7:50 am

    #1935265

  • RE: Two sets of numbers, one 6 in LEN, the other 7..need to match the first 6 digits in both as a query?

    chef423 - Monday, March 27, 2017 12:31 PM

    I will only be comparing nvarchar(20) which is mainly INT data, I only care about...

    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 27, 2017 at 1:15 pm

    #1935150

  • RE: looping through INSERT results: what's the best way?

    The update seems to be working correctly with the sample data. The results don't match but that's only because you're adding the order number to the description.

    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 27, 2017 at 12:07 pm

    #1935143

  • RE: Are the posted questions getting worse?

    drew.allen - Monday, March 27, 2017 10:17 AM

    Now that I'm officially unemployed, I finally got around to downloading SQL 2016 developer edition...

    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 27, 2017 at 11:58 am

    #1935141

  • RE: Two sets of numbers, one 6 in LEN, the other 7..need to match the first 6 digits in both as a query?

    Here are my suggestions depending on the data type.
    DECLARE @NUMLIST TABLE
    (
    NM_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED
    ,SKU BIGINT  NOT NULL
    );

    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 27, 2017 at 9:57 am

    #1935120

  • RE: please help with SQL interview question

    caojunhe24 - Monday, March 27, 2017 9:23 AM

    Thanks John, it works and it's more easier!! You are awesome 

    select a.*,
    avg(salary)...

    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 27, 2017 at 9:44 am

    #1935118

  • RE: looping through INSERT results: what's the best way?

    rgouette - Monday, March 27, 2017 9:22 AM

    sorry for the lack of detail, here's what I tried:
       BEGIN
        UPDATE o
        SET generic_custom_description...

    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 27, 2017 at 9:35 am

    #1935116

Viewing 15 posts - 1,426 through 1,440 (of 8,731 total)