Forum Replies Created

Viewing 15 posts - 2,776 through 2,790 (of 13,879 total)

  • Reply To: Procedure edit for accumulated points

    Can you also show us what the data looks like?

    If you want a working solution, you'll need to provide a script with sample DDL, INSERT (for data) and desired results.

    April 14, 2020 at 12:27 pm

    #3742686

  • Reply To: Stored Procedure that joins tables and accepts a parameter to filter the result

    Data Rat wrote:

    Thanks for the great example. What if I wanted to display the SSN's with the Table Names ?

    Did you even read my answer?

    April 13, 2020 at 10:34 pm

    #3742570

  • Reply To: Stored Procedure that joins tables and accepts a parameter to filter the result

    Data Rat wrote:

    Thanks So Much For Your Help. I was wondering what will this stored procedure return if I the SSN doesn't exist in any table. Also I was wondering what...

    April 13, 2020 at 9:33 pm

    #3742563

  • Reply To: Stored Procedure that joins tables and accepts a parameter to filter the result

    Data Rat wrote:

    Thanks for your help and the critical thinking skills lesson, I greatly appreciate that. What I would like for the stored proc to return is all the rows (With...

    April 13, 2020 at 6:16 pm

    #3742509

  • Reply To: Stored Procedure that joins tables and accepts a parameter to filter the result

    But to answer your question ..

    You do realise that you have not done this, don't you?

    Let's say that the SSN exists in all but one of the tables.

    What should the...

    April 13, 2020 at 5:33 pm

    #3742494

  • Reply To: Stored Procedure that joins tables and accepts a parameter to filter the result

    What are the parameters for the proc? Table name and SSN? Or just SSN?

    Why do you think that the tables all need to be joined together?

    April 13, 2020 at 4:50 pm

    #3742471

  • Reply To: Setting up the identity key after creating a new table with data

    Please explain your thinking behind removing and adding the IDENTITY column. Why not leave the IDENTITY column there during data load?

    The PK is a separate matter, and there may be...

    April 13, 2020 at 2:48 pm

    #3742422

  • Reply To: Unable to create SSISDB

    I don't have 2019 yet. Can you provide some screenshots showing what you are seeing?

    April 13, 2020 at 2:30 pm

    #3742413

  • Reply To: Unable to import package

    What are you importing the package to? An SSIS project?

    April 13, 2020 at 2:27 pm

    #3742412

  • Reply To: Setting up the identity key after creating a new table with data

    If I understand what you are asking, SET IDENTITY_INSERT may be what you are looking for.

    April 12, 2020 at 4:06 pm

    #3742295

  • Reply To: Issue with a stored procedure when I run it as a job

    Maybe the SQL Agent user does not have rights to create files in the backup folder ...

    April 12, 2020 at 2:53 pm

    #3742286

  • Reply To: Top 10, count Distinct of multiple columns in select statement

    TOP 10 based on what metric? What are you ordering by?

    April 10, 2020 at 3:12 pm

    #3742011

  • Reply To: Exporting large amount of data out of AS400

    Brad Allison wrote:

    The only transformation I have right now is a data conversion.  Is that considered a blocking transformation?

    No, that should not be an issue.

    On your dataflow, what are the values...

    April 9, 2020 at 4:33 pm

    #3741824

  • Reply To: Exporting large amount of data out of AS400

    Are you including any blocking transformations in your data flow?

    April 9, 2020 at 1:54 pm

    #3741772

    • Viewing 15 posts - 2,776 through 2,790 (of 13,879 total)