Forum Replies Created

Viewing 15 posts - 406 through 420 (of 8,731 total)

  • RE: how to concert nvarchart to int in case statement

    dinaalesin - Wednesday, July 18, 2018 9:07 AM

    The query above works, I just need to modify it a little and show: instead...

    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

    July 18, 2018 at 9:20 am

    #1998020

  • RE: how to concert nvarchart to int in case statement

    dinaalesin - Wednesday, July 18, 2018 8:46 AM

    Hi All,

    I'm not good at SQL at all (self-taught), and could use your help. I...

    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

    July 18, 2018 at 8:54 am

    #1998016

  • RE: Find the variance in a group

    NineIron - Wednesday, July 18, 2018 7:39 AM

    Yes. No luck.
    I found this using Google but, the Value for the DateRange will...

    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

    July 18, 2018 at 7:50 am

    #1998000

  • RE: String Segregation

    vs.satheesh - Wednesday, July 18, 2018 7:15 AM

    Dear all

    In my table one column i have records in following formets

    mat201
    mat202
    sci12
    science203

    In this above value...

    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

    July 18, 2018 at 7:27 am

    #1997992

  • RE: Find the variance in a group

    NineIron - Wednesday, July 18, 2018 7:15 AM

    Yes. I need an expression for SSRS.

    Have you tried getting the correct value with VarP()...

    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

    July 18, 2018 at 7:21 am

    #1997990

  • RE: Find the variance in a group

    You might be using the wrong function as well that might not correspond to the formula that you're trying to get.

    CREATE TABLE #Heights(
      Height DECIMAL(16,10))

    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

    July 18, 2018 at 7:10 am

    #1997986

  • RE: Find the variance in a group

    NineIron - Wednesday, July 18, 2018 6:18 AM

    I have a very simple report grouped by "Payer". There are two rows of 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

    July 18, 2018 at 6:56 am

    #1997980

  • RE: Convert Access SQL to SQL Server

    sgmunson - Tuesday, July 17, 2018 12:20 PM

    steven.littlewood16 - Monday, July 16, 2018 3:53 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

    July 17, 2018 at 1:02 pm

    #1997897

  • RE: Removing decimal place from amount field

    machzy - Tuesday, July 17, 2018 5:35 AM

    I'm using Report Builder 3.0 to try and create a bank report.

    One of 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

    July 17, 2018 at 6:33 am

    #1997799

  • RE: how can i get the top 3, after i count the column ?

    Jeff Moden - Tuesday, July 17, 2018 6:12 AM

    Folks are still forgetting about "ties".  If you have a dozen ties for 1st,...

    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

    July 17, 2018 at 6:19 am

    #1997796

  • RE: Are the posted questions getting worse?

    Ed Wagner - Monday, July 16, 2018 11:44 AM

    WayneS - Monday, July 16, 2018 11:27 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

    July 16, 2018 at 12:38 pm

    #1997725

  • RE: how can i get the top 3, after i count the column ?

    BONITO - Monday, July 16, 2018 7:40 AM

    Luis Cazares - Monday, July 16, 2018 7: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

    July 16, 2018 at 8:15 am

    #1997678

  • RE: Left(null,5) 'anything' is not true?

    From Microsoft Docs

    :exclamationmark: Important

    In a future version of SQL Server, ANSI_NULLS will be ON and any applications that explicitly set 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

    July 16, 2018 at 7:45 am

    #1997665

  • RE: how can i get the top 3, after i count the column ?

    BONITO - Monday, July 16, 2018 6:57 AM

    select top 3 count(UUT_SN) as Total_Fail,Fail_Description,Station_No from Test_table
    WHERE SQLDateTime >= '2018-07-01' 
    AND SQLDateTime <=...

    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

    July 16, 2018 at 7:29 am

    #1997655

  • RE: Convert Access SQL to SQL Server

    steven.littlewood16 - Monday, July 16, 2018 3:53 AM

    Hi,

    I am new to SQL server and Access and I really need to convert an...

    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

    July 16, 2018 at 6:59 am

    #1997650

Viewing 15 posts - 406 through 420 (of 8,731 total)