Forum Replies Created

Viewing 15 posts - 46 through 60 (of 290 total)

  • Reply To: nested subqueries vs separate queries performance difference

    Jonathan AC Roberts wrote:

    water490 wrote:

    Jonathan AC Roberts wrote:

    The optimiser should be able to simplify the query to remove the nesting so it might not make much difference.

    One of the big advantages of putting you...

    March 15, 2024 at 12:10 am

    #4395595

  • Reply To: temp table level of precision

    Ken McKelvey wrote:

    water490 wrote:

    Jeff Moden wrote:

    water490 wrote:

    I have never used float for table definitions.  I am not sure why the INTO command I used ended up with that data type.

    You did some...

    March 14, 2024 at 11:53 pm

    #4395565

  • Reply To: nested subqueries vs separate queries performance difference

    Jonathan AC Roberts wrote:

    The optimiser should be able to simplify the query to remove the nesting so it might not make much difference.

    One of the big advantages of putting you results into...

    March 14, 2024 at 11:51 pm

    #4395564

  • Reply To: nested subqueries vs separate queries performance difference

    ratbak wrote:

    For some reason, you didn't ask -- perhaps deliberately -- about the simplest and probably the best option, which is just:

    SELECT field1,field2
    FROM table1

    Because there is no...

    March 14, 2024 at 9:52 pm

    #4395530

  • Reply To: temp table level of precision

    Jeff Moden wrote:

    water490 wrote:

    thank you everyone!

    I used the script that Jonathan provided.  It turns out that temp was using float when I used numeric.  Once I made this change the numbers...

    March 14, 2024 at 7:20 pm

    #4395456

  • Reply To: temp table level of precision

    thank you everyone!

    I used the script that Jonathan provided.  It turns out that temp was using float when I used numeric.  Once I made this change the numbers match.

    March 14, 2024 at 5:35 pm

    #4395409

  • Reply To: incremental load

    Phil Parkin wrote:

    How many tables are updated during this process?

    Does each table have date created / date modified columns?

    Is the incoming data purely inserts, or inserts + updates, or inserts +...

    March 12, 2024 at 3:15 pm

    #4394060

  • Reply To: SSIS error

    Jeffrey Williams wrote:

    Just curious - but you stated you are using SSIS, but here you are using a stored procedure to execute a BULK INSERT?

    I have to ask why you decided...

    March 12, 2024 at 1:11 am

    #4393672

  • Reply To: SSIS error

    Ed B wrote:

    Does this work?

    'INSERT INTO DBO.DataTable
    SELECT *, NULL, ''N'' AS PROCESSED_FLAG
    FROM #TEMP_TABLE'

    it worked!  thank you so much!

    • This reply was modified 8 months, 3 weeks ago by  water490.
     
     
     
    March 12, 2024 at 1:06 am
     
    #4393670
         
     
    •  
  •  
     
     Reply To: SSIS error 
     
       
    Ed B wrote:
    I assume the source file does not contain a processed_flag or processed_date column. I just ran a quick bulk insert test and when I added an extra column to...
     
     
     
    March 11, 2024 at 4:53 pm
     
    #4393497
         
     
    •  
  •  
     
     Reply To: SSIS error 
     
       
    MarkP wrote:
    Next step on the debug root now we've sorted the "is it plugged in" equivalent.
    Can you swap the exec for print so that you can see exactly what is...
     
     
     
    March 11, 2024 at 4:38 pm
     
    #4393496
         
     
    •  
  •  
     
     Reply To: SSIS error 
     
       
    MarkP wrote:
    I'd check your variables.  No sign of @FILEPATH being declared or populated anywhere in that.
    What does the execute statement of the stored procedure that you are issuing look like?
    [quote-1...
     
     
     
    March 11, 2024 at 4:35 pm
     
    #4393493
         
     
    •  
  •  
     
     Reply To: SSIS error 
     
       
    MarkP wrote:
    I'd check your variables.  No sign of @FILEPATH being declared or populated anywhere in that.
    What does the execute statement of the stored procedure that you are issuing look like?
    it...
     
     
     
    March 11, 2024 at 4:31 pm
     
    #4393481
         
     
    •  
  •  
     
     Reply To: SSIS error 
     
       
    frederico_fonseca wrote:
    error is very clear - your bulk insert is failing because of data conversion between input (your file) and the output (#TEMP_TABLE).
    it has Nothing to do with that flag...
    • This reply was modified 8 months, 3 weeks ago by  water490.
    • This reply was modified 8 months, 3 weeks ago by  water490.
    • This reply was modified 8 months, 3 weeks ago by  water490.
     
     
     
    March 11, 2024 at 2:39 pm
     
    #4393402
         
     
    •  
  •  
     
     Reply To: SSIS error 
     
       
    Jeff Moden wrote:
    Does you code actually look like what you posted?  I ask because there is no space between the terms "SET" and "Processed_Flag" and there needs to be.
    there are spaces. ...
     
     
     
    March 11, 2024 at 2:33 pm
     
    #4393400
         
     
    •  
 
Viewing 15 posts - 46 through 60 (of 290 total)