Forum Replies Created

Viewing 15 posts - 4,276 through 4,290 (of 5,109 total)

  • RE: Need Some Urgent Help in converting the 24 hour date format to grouping with 0-23 range

    ThomasRushton - Wednesday, February 8, 2017 2:18 AM

    Ravi Teja - Tuesday, February 7, 2017 7:44 PM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Your Favorite Feature that Needs Work

    GilaMonster - Tuesday, February 7, 2017 10:49 AM

    I saw a feature from Stream Analytics today that I would love to have in...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Using Variables at package level

    Phil Parkin - Tuesday, February 7, 2017 8:41 AM

    Thom A - Tuesday, February 7, 2017 7:54 AM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Using Variables at package level

    I feel like this question isn't as simple as I think it is, however, in your Variables Pane you have a column called Value. You can enter the value of...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Parameters that have more that one value?

    Yes, you can pass multiple values for a parameter in SSRS. I've assume you have already configured your report to allow to submit multiple parameters, so I'm going to straight...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Grouping and summing transactions from the same Oracle source table

    Something like this?
    CREATE TABLE #Sample (Contract INT,
                 Line VARCHAR(5),
                 Amount DECIMAL(12,2));

    INSERT INTO #Sample
    VALUES (1478, 'A1',...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Licensing

    Yes. If you wanted to run each service (let's say the Database Engine (DE), Reporting Services (RS), Analysis Services (AS)) on 3 different servers would would need to licence each...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: FAQ: Using the new forum Software (Jan 2017)

    I'm actually wondering if the Like button(s) are bloating people's points. I've noticed that since the new forums have come out I've probably earned about 700 points (700!). That's almost...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Query to show users who have been active for 4 hours straight

    I might be able to do something for you when I get to the office tomorrow with our own logs table again, like in the other post, but without DDL...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: datatype to store only date in SSIS

    nhapzz - Monday, February 6, 2017 10:31 AM

    what about cast(datecolumn as date) ?

    OP has Posted in the SQL Server 2005 forum. The...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Adding an extra column to show internal users

    Use a CASE statemnt:
    SELECT
     [AUTHN] AS [Auth Number]
    ,convert(date, [AuthDate], 1) AS [Effective Date]
    ,convert(date, [ExpirationDate] , 1) AS [Expiration Date]

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SSRS Arithmetic operator issue

    I think you need to handle this in your SQL, NOT SSRS. What version of SSRS and SQL Server are you using? Can you provide a copy of your query?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Issue with AutoRounding of decimal values on SSRS textbox

    Updated. It is worth noting that the values that SSRS is giving you is correct, 0.99995000 = 1 when rounding to 4 decimal places (2 decimal places in percentage format)....

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Issue with AutoRounding of decimal values on SSRS textbox

    Edit reread, will post back an answer.

    Edit, try:
    =FLOOR(Fields!MyField.Value * 10000) / 10000

    This preserves the field as a numeric, rather than turning it into a string.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Update not working after read database using CASE

    It's been quite some time since I've actually used VB, datagrids in virtualmode isn't something I've used so i wouldn't like to hazard a guess.

    I did wonder, instead,...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 15 posts - 4,276 through 4,290 (of 5,109 total)