Forum Replies Created

Viewing 15 posts - 841 through 855 (of 5,109 total)

  • Reply To: Waking Up to No Support

    Somebody wrote:

    From what little I am able to see it seems like there are a LOT of companies still running SQL 2008R2.

    There definitely are. You still see questions about SQL...

    Thom~

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

    July 10, 2019 at 3:13 pm

    #3661616

  • Reply To: Newest record based on column criteria

    Yes, the common way is using a CTE and ROW_NUMBER or using ROW_NUMBER in the ORDER BY and TOP 1 WITH TIES. There's plenty of examples on the internet on...

    Thom~

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

    July 10, 2019 at 10:21 am

    #3661499

  • Reply To: read txt file data into excel

    Phil Parkin wrote:

    If there's a question here, I can't see it.

    The data isn't even well formed either. If we assume that the | not contained in a " is a delimiter,...

    Thom~

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

    July 10, 2019 at 7:55 am

    #3661465

  • Reply To: More Linux than Windows

    Steve Jones - SSC Editor wrote:

    That's not good enough for most CPAs, my Mom, and lots of other business users. The online version seems to be a last resort for most people.

    I don't...

    Thom~

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

    July 9, 2019 at 3:37 pm

    #3661230

  • Reply To: More Linux than Windows

    Steve Jones - SSC Editor wrote:

    I think that the authentication on Linux is still a hassle. I know some people have it working, but it certainly isn't easy right now. That will get lots...

    Thom~

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

    July 9, 2019 at 3:16 pm

    #3661208

  • Reply To: Open Query Column List

    Andrey wrote:

    eobiki10 wrote:

    I was able to resolve this by making the open query select list a CTE and selecting from the CTE.

    also, procedure sp_describe_first_result_set can be useful in...

    Thom~

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

    July 9, 2019 at 2:19 pm

    #3661192

  • Reply To: SSIS, PORTS and Access categories

    hurricaneDBA wrote:

    For the above data sources which access level can i give to the SSIS packages? Is it only read and write or are there other options?

    What permission you need...

    Thom~

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

    July 9, 2019 at 1:09 pm

    #3661167

  • Reply To: Using Correlated Queries with OPENQUERY

    I'm actually a little bit confused as to what you're trying to achieve here. Are you trying to delete rows from the table MA_HST_PW_EM on the linked server, where the...

    Thom~

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

    July 9, 2019 at 11:27 am

    #3661075

  • Reply To: More Linux than Windows

    I actually do use Linux as a Desktop PC at home. This is more of a hangover from when I was living at my parents for an interim period and...

    Thom~

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

    July 9, 2019 at 11:02 am

    #3661069

  • Reply To: Run SQL Job from a Bat file

    Seems like it would be easier to have the user update a table to update a status to say that the file is available, and your SQL job pools the...

    Thom~

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

    July 9, 2019 at 8:48 am

    #3661031

  • Reply To: Run SQL Job from a Bat file

    This sounds like an "XY problem". I assume you want the user to be able to start a SQL Agent job? Is it a specific job you want them to...

    Thom~

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

    July 9, 2019 at 8:14 am

    #3661018

  • Reply To: query with CTE

    nooshin wrote:

    Hello, I need help to write a query with CTE. I wanna write a query for TotalPrice of Last Sunday of each month between some years.

    Why do you need...

    Thom~

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

    July 7, 2019 at 9:30 am

    #3660516

  • Reply To: SSIS and SQL Linked Server

    hurricaneDBA wrote:

    So to connect between SSIS package and a separate linked server I would create an OLEDB connection using the connection managers.

    You just need to create an OLEDB connection for...

    Thom~

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

    July 4, 2019 at 8:46 am

    #3659992

  • Reply To: SSIS and SQL Linked Server

    You don't have linked servers in SSIS; Linked Servers is a Data Engine "thing". You can have multiple OLEDB Connections in a package, and those can reference different Servers/Instances in...

    Thom~

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

    July 4, 2019 at 7:37 am

    #3659982

  • Reply To: Status Update 2 Jul 2019

    Site Owners wrote:

    Thanks for posting your issue and hopefully someone will answer soon. This is an automated bump to increase visibility of your question.

    I'm sorry, but this amused me far more...

    Thom~

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

    July 3, 2019 at 3:25 pm

    #3659816

Viewing 15 posts - 841 through 855 (of 5,109 total)