Forum Replies Created

Viewing 15 posts - 1,966 through 1,980 (of 5,109 total)

  • RE: Upgrading from SQL Server 2016 SP1 to SP2

    I'm not entirely sure what your question is here. The only thing you ask is (and I'm paraphrasing) "Is what happened what you expected to happen?". Well, you said you...

    Thom~

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

  • RE: Count

    saravanatn - Friday, June 1, 2018 11:27 AM

    I agreed Thorn . Kindly go through the document suggested by Thorn.


    SELECT...

    Thom~

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

  • RE: Count

    What have you tried so far? I suggest having a look at the documentation on COUNT: https://docs.microsoft.com/en-us/sql/t-sql/functions/count-transact-sql?view=sql-server-2017

    Thom~

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

  • RE: SSDT install fails in VS 2017 enterprise edition

    I had this problem with a few work PC's back in April. The solution? I rebuilt all 3 PC's, starting with a reinstallation of Windows 10... Sorry, not much help...

    Thom~

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

  • RE: with Execute as

    terry999 - Friday, June 1, 2018 8:33 AM

    Hi
    The table...

    Thom~

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

  • RE: I need help getting last day of prior month in a view statement

    Is that expression in your WHERE or SELECT? Dates don't have any kind of stored format, so using a WHERE clause with the format MM/dd/yyyy could yield very odd results,...

    Thom~

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

  • RE: SSRS Exporting Data to EXCEL does not work when Query returns 187326 Rows

    doug.brown - Thursday, May 31, 2018 12:47 PM

    When you successfully export other reports to Excel, are they in .xls or .xlsx format? ...

    Thom~

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

  • RE: with Execute as

    Why can you not, instead, grant the AD Group Execute permissions on the object? Is the dynamic SQL calling objects owned by other users, or another database?

    Also, are...

    Thom~

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

  • RE: YTD running balance including missing months

    jcelko212 32090 - Thursday, May 31, 2018 12:51 PM

    There is no such function in SQL as CHOOSE. Why would anyone want...

    Thom~

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

  • RE: Dummy_val

    A quick google of 'Entity Framework "DUMMY_VAL"' returned few results; one of which was this very topic. Sounds like somewhere in your application that's the query that is being used;...

    Thom~

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

  • RE: Are the posted questions getting worse?

    Jeff Moden - Thursday, May 31, 2018 12:13 PM

    frederico_fonseca - Thursday, May 31, 2018 4:00 AM

    Thom~

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

  • RE: Best way to delete records from multiple tables

    You can still delete rows without a relationship in your database (although I still suggest you build that relationship).

    It might be quicker, however, to actually delete the records...

    Thom~

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

  • RE: SQL Server 2017

    Ahh, so you mean an installation of Windows without a Graphical user Interface; very different to saying "non-desktop windows", which implies Windows designed for something other than a Desktop PC.

    Thom~

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

  • RE: YTD running balance including missing months

    jcelko212 32090 - Thursday, May 31, 2018 11:17 AM

    You probably don't remember this, but it one point thanks to the French...

    Thom~

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

  • RE: SQL Server 2017

    "Non-desktop version of Windows"? Do you mean Windows Server? Generally, in a business environment, that's the version of Windows that's going to be installed of; you don't install Windows Professional...

    Thom~

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

Viewing 15 posts - 1,966 through 1,980 (of 5,109 total)