Forum Replies Created

Viewing 15 posts - 3,001 through 3,015 (of 59,067 total)

  • Reply To: How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!)

    My apologies... there's a missing word as follows....

    "Each test will have the following nearly sections:" should have been "Each test will have the following nearly identical sections:"

    And I left an...

    August 5, 2022 at 4:30 am

    #4072756

  • Reply To: Informatica data ingestion

    Thanks, and, yes... it's there clear as day.  Thanks Frederico.

     

    August 4, 2022 at 9:23 pm

    #4072680

  • Reply To: sys.object

    Just had another thought... do you have privs to view everything?  It may be that the script will only return what YOU can see on the database.  Like I said,...

    • This reply was modified 3 years, 7 months ago by Jeff Moden. Reason: Added the hint about the "right click" for dependencies tip

    August 4, 2022 at 8:39 pm

    #4072673

  • Reply To: sys.object

    yrstruly wrote:

    Yes, it is the database thats hold the table in question. I got this as an instruction:

    "find out how the table is populated, fn_GetSummaryReport  only reads from the table. ...

    August 4, 2022 at 8:35 pm

    #4072672

  • Reply To: sys.object

    yrstruly wrote:

    Something is wrong. I just tried it with a table with data in it and i get nothing back.4f1

    That doesn't mean that there's a stored procedure...

    August 4, 2022 at 8:29 pm

    #4072666

  • Reply To: sys.object

    I'm thinking that you need to find out if it's "static" or not.  It's starting to sound like it and you may have to make a copy of the data...

    August 4, 2022 at 8:21 pm

    #4072663

  • Reply To: QUERY HELP

    Drew showed me his wonderful code to do this same thing on another thread.  I did a deep dive on it and the concept is wonderfully simple and it solved...

    August 4, 2022 at 8:19 pm

    #4072662

  • Reply To: Using LAG to return prior non null value

    Yeah... I definitely posted to the wrong thread.  Here's the thread I meant to post to.  The only thing my post on this thread does is show the performance.  It...

    August 4, 2022 at 8:15 pm

    #4072660

  • Reply To: Using LAG to return prior non null value

    Jonathan AC Roberts wrote:

    I don't understand what that query is doing?

    Is there another query written in a more standard way that produces the same results but is slower?

    It creates an million row...

    August 4, 2022 at 8:09 pm

    #4072659

  • Reply To: sys.object

    Is the current database that you're running the code in the same database as where the table is?

    If so, then I don't know what the issue is other than there...

    August 4, 2022 at 7:54 pm

    #4072639

  • Reply To: Using LAG to return prior non null value

    Drew, thanks again for the solution.  It's "Spec-hacular"!

    August 4, 2022 at 7:53 pm

    #4072638

  • Reply To: Using LAG to return prior non null value

    Drew showed me his wonderful code to do this same thing on another thread.  I did a deep dive on it and the concept is wonderfully simple and it solved...

    August 4, 2022 at 7:50 pm

    #4072637

  • Reply To: QUERY HELP

    Aye.  Thanks for the link.  The solution that you posted is even simpler than either of those two and now I understand about why you say it's not where you...

    August 4, 2022 at 6:45 pm

    #4072626

  • Reply To: Informatica data ingestion

    frederico_fonseca wrote:

    Jeff Moden wrote:

    It clearly states that you do NOT need to grant sys_admin privs...

    source connection must have the sysadmin role, OR have the db_owner role and the SELECT...

    August 4, 2022 at 6:29 pm

    #4072593

  • Reply To: sys.object

    yrstruly wrote:

    I have a table that is empty and it should have data in it. I need to find a stored procedure or table(s) that populates this table.

    How do i...

    August 4, 2022 at 6:22 pm

    #4072592

Viewing 15 posts - 3,001 through 3,015 (of 59,067 total)