Forum Replies Created

Viewing 15 posts - 3,016 through 3,030 (of 5,109 total)

  • RE: logins disappearing

    This doesn't look like the logins are "disappearing", but that the there is no user linked to that login on the database. When creating the login, are you also creating...

    Thom~

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

  • RE: Memory Optimization advisor (Next button is greyed out)

    GG_BI_GG - Friday, September 29, 2017 4:44 AM

    Microsoft SQL Server Business Intelligence (64-bit)

    SQL Server 2014 database

    As stated in that page that...

    Thom~

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

  • RE: A Window Function question...

    kevaburg - Friday, September 29, 2017 4:22 AM

    Although it is still a...

    Thom~

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

  • RE: query for all instance

    tony28 - Friday, September 29, 2017 4:00 AM

    Thanks guys,

    I will check.
    Goal is that I would like to have select of all...

    Thom~

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

  • RE: query for all instance

    Here's a very quick "introduction" that I wrote up while waiting for the coach. This might give you some idea on what you can do with powershell:
    [CmdletBinding()]
    Param(
     ...

    Thom~

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

  • RE: Change color of text by value

    Add an expression to the colour on the text box which returns the colour. To start you off:
    =iif((Fields!YourField.Value = "TOP RAIL") Or (Fields!YourField.Value = "BOTTOM RAIL"), "Red", iif((Fields!YourField.Value =...

    Thom~

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

  • RE: query for all instance

    When you say query, what is your goal? To run the same query on multiple instances, which will return many resultsets, or are you aiming to run one query/process that...

    Thom~

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

  • RE: Window Function Lag() - No previous Value when 1 row.

    With LAG([FieldName],2), I'd also expect the 2nd row to return a NULL as well. The 2 is telling SQL Server to return the result from 2 rows prior....

    Thom~

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

  • RE: [SOLVED] Filling Date Gaps

    A Calendar table is the right method, so if it's not working I would guess you're SQL isn't right.

    You need to use the dates in your Calendar table...

    Thom~

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

  • RE: saving variable from a stored proc

    sgmunson - Thursday, September 28, 2017 1:44 PM

    Okay, then what do you mean by "save" that parameter value?   Display it in...

    Thom~

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

  • RE: We Have a Date

    jasona.work - Thursday, September 28, 2017 1:44 PM

    Thom A - Thursday, September 28, 2017 11:39 AM

    Thom~

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

  • RE: SQL Server 2017

    Yes, it does (as shown in the picture in the highlighted text).

    https://www.microsoft.com/en-us/sql-server/sql-server-downloads

    Thom~

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

  • RE: SQL Server 2017

    sqlfriends - Thursday, September 28, 2017 12:52 PM

    Thank you, that is clearly stated in this document.

    But in Microsoft site and most of...

    Thom~

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

  • RE: We Have a Date

    jasona.work - Thursday, September 28, 2017 10:47 AM

    Heh
    One of my customers still pulls in data, in flat files, from a mainframe...

    Shush,...

    Thom~

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

  • RE: SQL Server 2017

    sqlfriends - Thursday, September 28, 2017 11:22 AM

    Have SQL server 2017 officially released or not?
    From Microsoft site, I can see there is...

    Thom~

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

Viewing 15 posts - 3,016 through 3,030 (of 5,109 total)