Forum Replies Created

Viewing 15 posts - 256 through 270 (of 8,731 total)

  • RE: Query Question

    You might need to unpivot and pivot again your data if you want to call the descriptions table just once and keep the structure in your results. Here's an example:

    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

    January 28, 2019 at 2:33 pm

    #2020342

  • RE: trying to learn SQL development

    Here is a page with 500+ T-SQL puzzles that could help. https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
    You could also try to solve problems from the forums which are more focused on...

    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

    January 28, 2019 at 11:23 am

    #2020316

  • RE: What is Alternative of numbered_procedures?

    parviz.vakili - Sunday, January 27, 2019 6:44 AM

    fahey.jonathan - Wednesday, January 23, 2019 9:29 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

    January 28, 2019 at 9:52 am

    #2020306

  • RE: Order BY clause in View using Stuff Function.

    jkramprakash - Monday, January 28, 2019 9:38 AM

    I tired  the ORDER BY before FOR XML but it is showing error message.

    Are we supposed...

    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

    January 28, 2019 at 9:45 am

    #2020304

  • RE: Order BY clause in View using Stuff Function.

    jkramprakash - Monday, January 28, 2019 8:41 AM

    I have two views.

    My First View definition

    CREATE VIEW FIRST_VIEW AS
    SELECT PT.F_PRODUCT AS F_PRODUCT,...

    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

    January 28, 2019 at 9:12 am

    #2020290

  • RE: Polling Datawarehouse Design

    I don't see how QTD or YTD are measures. They certainly look as calculations done on measures using a time dimension.

    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

    January 28, 2019 at 8:39 am

    #2020287

  • RE: DEV - Execution plan IF there were more CPUs

    Jeff Moden - Friday, January 25, 2019 2:32 PM

    Davis H - Friday, January 25, 2019 1:19 PM

    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

    January 25, 2019 at 2:42 pm

    #2020176

  • RE: Are the posted questions getting worse?

    drew.allen - Friday, January 25, 2019 9:46 AM

    Got back from a meeting this morning to discover that I suddenly had a second...

    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

    January 25, 2019 at 11:48 am

    #2020156

  • RE: Combining Two Queries into Single Query

    Will there only be 2 values or could you have more than 1 alias?

    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

    January 24, 2019 at 12:32 pm

    #2020023

  • RE: How do I change a SELECT statement in a stored procedure based on the value of a variable?

    Lorna-331036 - Thursday, January 24, 2019 6:31 AM

    I tried CAST and CONVERT but it's still throwing up errors.  I need to learn...

    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

    January 24, 2019 at 8:49 am

    #2019977

  • RE: Inside out on my Where clause logic

    What if we work with some sample data.

    CREATE TABLE SolTracker(
        eligibility_flg char(1) NULL
    );

    CREATE TABLE DutyManager(
        eligibility_flg char(1) NULL
    );

    INSERT INTO SolTracker...

    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

    January 23, 2019 at 2:31 pm

    #2019881

  • RE: Split a range of numbers in equal parts

    kgresham - Wednesday, January 23, 2019 12:01 PM

    Recursion works well for this:

    set nocount on
    declare @GroupCount int = 5
    declare @MinValue bigint = 5000000000000480...

    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

    January 23, 2019 at 12:39 pm

    #2019860

  • RE: How do I change a SELECT statement in a stored procedure based on the value of a variable?

    Lorna-331036 - Wednesday, January 23, 2019 9:14 AM

    Thanks all - I followed the link from Jeff and created the following stored procedure...

    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

    January 23, 2019 at 9:30 am

    #2019838

  • RE: Get results between 2 date fields?

    Neil Burton - Tuesday, January 22, 2019 5:14 AM

    mick burden - Tuesday, January 22, 2019 4:47 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

    January 23, 2019 at 8:48 am

    #2019827

  • RE: How do I change a SELECT statement in a stored procedure based on the value of a variable?

    Lorna-331036 - Wednesday, January 23, 2019 7:01 AM

    I've got a web page (.Net web forms) where a user can display sales invoices...

    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

    January 23, 2019 at 8:24 am

    #2019823

Viewing 15 posts - 256 through 270 (of 8,731 total)